• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Question SQL-BackUp

Hoerli

New Pleskian
Hello!

Is it possible to create an automatic backup of the MySQL database?

Problem what I currently have:
I can not use the normal backup function.
It creates a Backup of the website-files and databases in one backup.
The websites are big and are stored on a extra hard drive. The System-drive is a small ssd with only 32GB. Too little for sytem, plesk and websits.
The exclusion of the data via the backup-function does not work.
He adds every time all files.
If i write in the box something like /storage/Ples/* or domain.com/httpdocs/* ... he adds every time all files and fails because insufficient disk space.

In Plesk i can use the button to export the SQLs.
Can this be triggered automatically and the file stored on the webspace of the respective page?
I dont want to do this every time manually.

Or should I use tools like MYSQLDump?
 
You can use mysqldump and dump the full database to a location of your choice. Use the user name "admin" and the password from the file /etc/psa/.psa.shadow for it. The dump will contain security sensitive information.
 
Back
Top