• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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