UBB.Developers Forums Community Development Programming MySQL and Server Configuration Database backup and copy

I am looking to do a backup of the ubbthreads database and ftp a copy of it to another server for offsite storage.

I would like it to dump the database to a file in a directory that I configure in the script that would be named "databasename-date.sql" it would then gzip the file and then it would ftp it (with specific account settings) to a folder on a different server for safe keeping. It would also be nice if it had a rotation feature where it would only keep the last X number of back up files and delete the older ones. This would be nice to put into a cron job and just have it run everynight at 4am or something.

Anyone know of anyway to do this or something that can do this?

Thank you!