• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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