Backup all MySQL databases, copy latest backup to S3

backup-db.sh

#!/bin/sh

DB_USER="root"
DB_PW="root"
DATE=`date +%d%m%y%H%M`
S3_BUCKET="s3://my-bucket"

# export database
mysqldump -u $DB_USER -p${DB_PW} --all-databases | gzip > /opt/backups/db_${DATE}.bak.gz
cp /opt/backups/db_${DATE}.bak.gz /opt/backups/db-latest.bak.gz

# delete backups older than 5 days
find /opt/backups/db* -mtime +5 -exec rm {} \;

# sync to amazon
aws s3 cp /opt/backups/db-latest.bak.gz ${DB_PW}