-
Notifications
You must be signed in to change notification settings - Fork 3
bkuhl edited this page Feb 13, 2012
·
10 revisions
What is Smart MySQL Backup?
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.
How can I get it setup and running?
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.
How can I get an email report when my backups run?
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