• The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

MySQL Backups on Windows

Mr Fett

Basic Pleskian
Hi all,

I've searched all over the web, this forum and the manual and can't find a definitive answer as to how MySQL (or IF) is backed up by Plesk. The Scheduled Plesk Backup doesn't seem to do it, MySQL doesn't seem to backup any databases other than the Horde, Plesk, etc. ones (no Subscription or user databases).

The Backups folder I have specified has all sorted of backup data, XML files, ZIP files for email data and some even have 'databases' folders but none of those contain anything.

For SQL Server I have simply scheduled my own backups directly but there doesn't seem to be an easy way to do this with MySQL *on windows* for all currrent (and future added) databases (it looks fairly straight forward with Linux).

Any help or pointers would be much appreciated.

Thanks

Bob
 
Login to Plesk
Click Server on the left panel >> Click Scheduled Tasks >> Select the Root user >> Add New Task

Minute: 01 ( this means 01 minutes past the hour)
Hour: 02 (This means 02:00 AM)
Day of Month: * (This means every day)
Month: * (This means every Month)
Day of the Week : * ( This means every day)

Then for the command:

mysqldump --user=admin --password=youradminpassword --all-databases > /backup/mysqlall-`/bin/date +\%Y\%m\%d`.sql

That's for the database backup - This backs up ALL MySQL databases - for every website.
 
Back
Top