MySQL backup script

mysql_backup.sh

#!/bin/bash
USER=""
PASSWORD=""
OUTPUT="$HOME/backup"
DATABASES=("skeletal_implementers" "phpmyadmin" "skeletal_implementers_abstract_only")
MYSQL_DUMP="/opt/bitnami/mysql/bin/mysqldump"
REMOTE_DIR="ftp://websupport1.citytech.cuny.edu/backup/"
REMOTE_USER=""
REMOTE_PWD=""
 
for db in ${DATABASES[*]}; do
	FILE=$OUTPUT/`date +%Y%m%d`.$db.sql
	echo "Dumping database: $db to: $FILE"
	$MYSQL_DUMP --force --opt --user=$USER --password=$PASSWORD --databases $db > $FILE
	gzip --force $FILE
	curl -T $FILE.gz $REMOTE_DIR --user $REMOTE_USER:$REMOTE_PWD
done

cd "$OUTPUT"
find *.gz -mtime +21 -delete > /dev/null 2>&1