Script for auto backing up a mysql db, gzip it and upload to Amazon S3

mysql_db_backup.sh

#!/bin/bash

DBNAME=mydb
USER="david"
PASSWORD='mypassword123'
DATE=`date +"%Y%m%d"`
SQLFILE=$DBNAME-${DATE}.sql
BUCKETNAME=my-aws-bucket-name
cd
echo "Starting with the following data:"
echo $DBNAME
echo $USER
echo $PASSWORD
mysqldump --force --opt --user=$USER  --password=$PASSWORD --databases $DBNAME > $SQLFILE
gzip $SQLFILE
s3cmd put $DBNAME-${DATE}.sql.gz s3://$BUCKETNAME/$DBNAME-${DATE}.sql.gz
rm $SQLFILE.gz
echo "Finished it"