mysql backup script

mysql_backup.sh

#!/bin/bash

# Path to directory where backups should be stored.
DIR="path/to/mysql_backup"

mysqldump -A |gzip -c - > ${DIR}/`date +%Y-%m-%d`.sql.gz
if [ "`date +%d`" == "01" ]
then
	cp ${DIR}/`date +%Y-%m-%d`.sql.gz ${DIR}/month_`date +%Y-%m`.sql.gz
	touch ${DIR}/month_*.sql.gz
fi
find ${DIR}/2[0-9][0-9][0-9]*.sql.gz -mtime +32 -exec rm {} +
find ${DIR}/month_*.sql.gz -mtime +180 -exec rm {} +