Cron SH file to save your SQL and export the backup to an FTP. Script can remove files older than X (7 here) days on localhost. All files and folder must be chmod 777 for convinience. Including this.

cron_save_sql_ftp.sh

#!/bin/bash

echo "SQL Backup in Progress"

#Date
NOWDATE=`date '+%H%M-%m-%d-%Y'`

# your MySQL server's name
SERVER=domain.com



# directory to backup to
BACKDIR=/data/backups



# date format that is appended to filename
DATE=`date +'%m-%d-%Y'`

# FTP server settings; should be self-explanatory
FTPHOST="ftp.domain2.com"

FTPUSER="ftp_log"

FTPPASS="ftp_pass"


# directory to backup to. if it doesn't exist, file will be uploaded to 

# first logged-in directory

FTPDIR="/backups"

#----------------------MySQL Settings--------------------#

# your MySQL server's location (IP address is best)
HOST=localhost

# MySQL username
USER=mysql_username

# MySQL password
PASS=mysql_password

# List all of the MySQL databases that you want to backup in here, each separated by a space
DBS="db1 db2 db3"

#-------------------Deletion Settings-------------------#

# how many days of backups do you want to keep?
DAYS=3

mysqldump -u$USER -p$PASS --databases $DBS > $BACKDIR/bc-$NOWDATE.sql

echo "Initiating FTP connection..."

cd $BACKDIR


ATTACH=`echo -n "put bc-${NOWDATE}.sql"`

ftp -nv <<EOF

open $FTPHOST

user $FTPUSER $FTPPASS

cd $FTPDIR

$ATTACH

quit

EOF

echo -e  "FTP transfer complete! \n"


find $BACKDIR -name "*.sql" -mtime $DAYS -exec rm {} \;

echo "SQL Backup done !"