Automatic database backup generation for VPS Plesk
Note! This article encompasses only MySQL database backup via Plesk.
Plesk in Linux does not provide the option to generate backups for MySQL databases via Backup Manager. The only way to get a backup is to use the export option via phpMyAdmin. Please click here for details.
The only way to automate the backup process is to configure a CRON for the following script.
As per the above script, backup will be created under the /mysqlbackup directory (create it manually on your server) and the name of the backup will be as db-dbName-yyyymmdd.dump.gz. Furthermore, upon execution the script will check for old backups and delete them automatically depending upon the value of mtime you want to specify.