awsMySQLDump.sh

mysqldump -u sqluser -ppassword database | gzip > /root/sqlbackups/databasename_`date '+%m-%d-%Y'`.sql.gz
# Crontab Settings to manage this export
# Yes, not sophisticated at all
##############
# crontab -e #
##############
# 30 2 * * * /root/awsmysqldump.sh 2>&1>> /root/awsmysqldump.log
# 00 3 * * * s3cmd put /root/sqlbackups/* s3://mybackupsbucket/serverfolder/sqlbackups/ > /dev/null
# 30 3 * * * rm -rf /root/sqlbackups/*