db_backup.sh

#!/bin/sh

DBNAME=<database>
DBUSER=<dbuser>
DBPASS=<good-strong-password?>
DBHOST=localhost
DESTDIR=/path/to/backup/dir
NAME=<site-name>
RETENTION=2
let MMIN=($RETENTION*60*24)-30
DATE=`date +%Y-%m-%d-%H-%M`

if [ ! -d $DESTDIR ]
then
  /bin/mkdir -p $DESTDIR
fi

/usr/bin/find $DESTDIR -type f -name '*.sql.gz' -mmin +$MMIN | xargs /bin/rm -rf
/usr/bin/mysqldump -h $DBHOST -u$DBUSER -p$DBPASS $DBNAME | gzip - > $DESTDIR/$NAME-$DATE.sql.gz