backup entire mysql to s3

backup.sh

#!/bin/bash

# you'll need configured s3cmd and stored password for mysql in ~/.my.cnf

DIR=`pwd`
# cd $DIR

info() {
echo -e "\e[1;34m"$1"\e[0m"
}

info "Dumping MYSQL data"
TIME=`date +"%Y-%m-%d.%H-%M-%S"`
BACKUP_DIR=$DIR"/backup/"$TIME
mkdir -p "$BACKUP_DIR"
mysql -s -N -e 'show databases' | sed "1 d" | while read dbname; do mysqldump --complete-insert --add-drop-table "$dbname" | gzip > $BACKUP_DIR/"$dbname".sql.gz; done
info "Sending to S3"
s3cmd sync $BACKUP_DIR s3://backup/mysql/ > /tmp/backup-s3.log
info "Removing files"
rm -rf $BACKUP_DIR
info "Done!"