• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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