Shell script to back up a MySQL database and push it to Amazon S3

backupdb.sh

# change these
bucket="s3://bucketname"
backupdir="/var/www/vhosts/domain.com/backup"
dbuser="dbuser"
dbpass="dbpass"
dbname="db"

cd ~pmpro/backup/
mysqldump -u$dbuser -p$dbpass $dbname > $dbname_`date +'%Y-%m-%d'`.sql
gzip $dbname_`date +'%Y-%m-%d'`.sql

s3cmd put $dbname_`date +'%Y-%m-%d'`.sql.gz "$bucket/$dbname_`date +'%Y-%m-%d'`.sql.gz"

mv $dbname_`date +'%Y-%m-%d'`.sql.gz $backupdir/old