How to automatically create backups of all databases of customer MySQL/MariaDB server in Plesk?
Note: All customers data including the databases can be backed up using Plesk Server Backup. This article describes how to automatically backup only all databases of customer MySQL/MariaDB server on port 3306 and nothing more.
Log into the server via RDP
Create the directory
%plesk_dir%DatabasesMySQLbackupto store the backups in
backup.batfile in directory created in step 2. with the following content:
To store databases in a single file
To store databases in separate files
password_for_mysqlin backup.bat of step 3. with the password of MySQL server. If password is unknown, it can be reset via Tools & Settings > Database Servers > localhost (3306) > Change password
Log into Plesk
Go to Tools & Settings > Scheduled Tasks and click Add Task
Specify the path
%plesk_dir%DatabasesMySQLbackupbackup.batin the Command field:
Configure desired execution time for backups to be created in Run field
Save the task by clicking OK