Plesk MySQL Daily Backup Script
Create file
mkdir /usr/serverok/
vi /usr/serverok/plesk-mysql-backup
With the following content
#!/bin/bash
# Author: [email protected]
# Web: https://serverok.in/plesk-mysql-daily-backup-script
if [ ! -d "/mysql-backup/" ]
then
mkdir /mysql-backup/
fi
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "show databases" | grep -v "+-------------" | grep -v "Database" | grep -v "information_schema" | grep -v "performance_schema" > /tmp/sok-dbs.txt
for db in `cat /tmp/sok-dbs.txt`
do
/usr/bin/mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` --opt --triggers --routines --events $db > /mysql-backup/$db.sql
if [ $? -ne 0 ]; then
# if you need email alert when backup fail, uncomment following line, add your email address
# echo "database backup $db failed - `date`" | mail -s 'MySQL Backup failed' [email protected]
echo "Backup failed"
fi
done
If you need multiple copies of MySQL database kept, use
https://gist.github.com/serverok/5a247a5b8485a6a29764f12118a7f727
Make it executable
chmod 755 /usr/serverok/plesk-mysql-backup
Set it to run as cronjob
1 1 * * * /usr/serverok/plesk-mysql-backup > /var/log/sok-mysqldb-backup.log 2>&1