Backup MySQL to s3 using Tim Kay's AWS CLI tool

gistfile1.txt

#You need Tim Kay's AWS Swiss Army Knife: https://github.com/timkay/aws
echo "deleting gzips"
rm *.gz
echo "archiving isly_wordpress"
mysqldump --add-drop-table -u USERNAME -pPASSWORD isly_wordpress | gzip > isly_wordpress.sql.gz
echo "archiving calligraphy_wordpress"
mysqldump --add-drop-table -u USERNAME -pPASSWORD calligraphy_wordpress | gzip > calligraphy_wordpress.sql.gz
echo "archiving fashion_wordpress"
mysqldump --add-drop-table -u USERNAME -pPASSWORD fashion_wordpress | gzip > fashion_wordpress.sql.gz
echo "exporting gzips to s3"
echo "beginning backup..." >> log
date >> log
for f in *.sql.gz
do
echo "sending $f..." >> log
  aws put --progress bucket.name.com/ $f
done
echo "Backup complete" >> log
date >> log
echo "" >> log
mail [email protected] < log

This usually needs to be run with sudo. It's something like "sudo sh s3backup", where s3backup is the name of the file where you saved this text.