bbak / myxbackup

simple, cron-triggered backup script for MySQL Databases using Percona xtrabackup

myxbackup

simple, cron-triggered backup script for MySQL Databases using Percona xtrabackup

This is a simple Bash-Script trying to automate MySQL backups, using Persona's excellent xtrabackup.

It's intended to be run through CRON adding a crontab entry like this:

[email protected]
00 23 * * * root /path/to/script.sh -b /path/to/backups -d 4 -k 2 -u 4096 > /dev/null

This will create a full backup on day 4 (Option -d, 1 = Monday) of every week keeping 2 (Option -k) full weeks of backups in subdirectories of the path provided by option -b.

On all other days a incremental backup is done, if a corresponding full backup exists.

When passing option -u the scipt tries to set the open files limit (ulimit -n), which may be required, if you have many databases/tables - at least with Debian wheezy.

Old backups are automatically purged.

In case something goes wrong, an email is sent to the Adress provided in the crontab.

Since I don't want to pass around MySQL login & password in the shell, this script (in fact it's innobackupex) relies on a .my.cnf in the home directory of the user executing the script, keeping the login-credentials. It should look like this:

[client]
user="yourusername"
password="yourpassword"

Note: Recent MySQL Versions may be set up to use Socket Authentication. If the user used to execute this script is set up this way, you obviously don't need the .my.cnf.

This Script doesn't assist you in restoring backups. Read the innobackupex docs.

If you need more advanced backup solutions, try:

• Zmanda Recovery Manager
• XtraBackup Manager, or
• myqbackup

(thanx Alexey)