Hey, i just managed to put together a working (and slim) MySQL ftp backup script so ill share it here
you need to have this on the computer where the backups is going to run from:
apt-get install mysql-client ncftp
EDIT: I'm using this crontab:
0 */6 * * * screen -AmdS mysql_backup /home/mangos/mysqlbackup
You can edit "/6" to the interval you want as example "/2" would make backups each 2nd hour while i do each 6th hour
for more information read: http://en.wikipedia.org/wiki/Cron
NOTE: There will always be 1 local copy of the databases, (latest) all other are only accessible on the FTP server and the database inside the gzip archives is not stored with .sql file extention, they are just plain text, but contains all SQL information (mostly a point to windows users)
NOTE2: The backups are stored in the ftp users "home" directory, so make a new user with only write access and select his home directory (for security reasons since the password is stored in plain text)
Feel free to send me a PM if you need help with the setup of this system
- LilleCarl<3