Back up MySQL databases

gistfile1.sh

#! /bin/bash

RETENTION=14
BACKUP_DIRECTORY='/var/backups/mysql'

NICE='/usr/bin/nice -n 20'
MYSQLDUMP='/usr/bin/mysqldump'
BZIP='/bin/bzip2'
RM='/bin/rm'

PASSWORD=`cat /etc/mysql.passwd` # Make sure it's `chmod go-wrx`!
CWD=`/bin/pwd`
UMASK=`umask`

umask u=r,go-wrx
cd $BACKUP_DIRECTORY

SQLDUMP=`date +%Y%m%d`.sql
$NICE $MYSQLDUMP -u root --password='$PASSWORD' --all-databases > ./$SQLDUMP
$NICE $BZIP ${SQLDUMP}

FALLOFF="`date --date="$RETENTION days ago" +%Y%m%d`.sql"
[ -f $FALLOFF ] && $NICE $RM -f $FALLOFF

cd $CWD
umask $UMASK