FAQ

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.

Example output:

Loading config file (/path/to/mysql-backup.conf)
Created backup directory (/path/to/backups/latest/2012-02-11)
Backing up MySQL databases...
    - database1...
    - database2...
    - database3...
    - database4...
Performing backup rotation...
Backups rotation complete
MySQL backup is complete
--------------
/usr/local/mysql/bin/mysql  Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using readline 5.0

Connection id:		579247
Current database:	
Current user:		root@My.server
SSL:     			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.0.26
Protocol version:	10
Connection:		    192.168.255.xx via TCP/IP
Server characterset:	utf8
Db     characterset:	utf8
Client characterset:	utf8
Conn.  characterset:	utf8
TCP port:		3306
Uptime:			37 days 15 hours 8 min 41 sec

Threads: 10  Questions: 225667986  Slow queries: 147  Opens: 326131  Flush tables: 1  Open tables: 64  Queries per second avg: 69.408
--------------

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