• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

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