-
Notifications
You must be signed in to change notification settings - Fork 3
bkuhl edited this page Feb 15, 2012
·
10 revisions
Smart MySQL Backup is a simple shell script controlled by a configuration file. When the script runs it will perform backups as it is configured and output a result of what took place.
Simply configure a few settings in mysql-backup.conf
and add a cron:
15 3 * * * /path/to/mysql-backup.sh
This will run daily at 3:15 AM server time.
It's a good idea to setup daily emails so you know if your backups failed. Use the following command to get the output delivered to your inbox:
15 3 * * * /path/to/mysql-backup.sh 2>&1 | /usr/bin/mail -s "Backup Report" myEmail@gmail.com