Mysql automated backups

gistfile1.txt

#!/bin/bash
#
# mysqlbak - mysql backup for xxx.yyy.zzz.qqq
#
# Created by Brant Faircloth on 2009-04-06.
# Copyright (c) 2009 Brant Faircloth. All rights reserved.
#
# Run by cron w/ 
# 0	0	*	*	*	/path/to/script/mysqlbak.sh
#

BDATE=`/bin/date +%m-%d-%Y-%H_%M`
BNAME=$BDATE.$HOSTNAME.sql.gz
BLOC=/dir/to/save/backups
USER=backuser

# change to the working directory
cd $BLOC
# run the backup, saving files to $BLOC
/usr/bin/mysqldump --user $USER --password=password --compact --all-databases | /bin/gzip > $BLOC/$BNAME
# remove any files older than 14 days (2 weeks)
/usr/bin/find $BLOC/* -mtime +14 -type f -name "*.sql.gz" -exec rm {} \;