db_backup2ftp

#!/bin/bash
RIGHTNOW=$(date +"%Y-%m-%d-%H%M");
OLD_BACKUP=$(date --date="4 days ago"  +"%Y-%m-%d");

FTP_HOST=''
FTP_USER=''
FTP_PASSWORD=''

DB_NAME=''
DB_USERNAME=''
DB_PASSWORD=''

BACKUP_DIR=''
FTP_DIR=''

# Remove old backups
rm -rf $BACKUP_DIR/$DB_NAME-$OLD_BACKUP*

# Export DB
mysqldump --user=$DB_USERNAME --password=$DB_PASSWORD $DB_NAME > $BACKUP_DIR/$DB_NAME-$RIGHTNOW.sql

# compress sql file
gzip -6 $BACKUP_DIR/$DB_NAME-$RIGHTNOW.sql

# Upload to ftp and remove old backup from ftp
ftp -n -v $FTP_HOST << EOT
ascii
user $FTP_USER $FTP_PASSWORD
prompt
cd $FTP_DIR
mdelete $DB_NAME-$OLD_BACKUP*
put $BACKUP_DIR/$DB_NAME-$RIGHTNOW.sql.gz ./$DB_NAME-$RIGHTNOW.sql.gz 
bye
EOT