Hello,

I am curious, how difficult is it to set up a Cron Job that backs up particular MySQL Databases and then FTP over to another server which gets a tape backup daily?

I have 1 server that I need to export a couple MySQL databases daily at a set time (which I know Cron can do nicely as I use it to execute some php scripts) to a Windows based server that does the tape backup?

Though I have another linux box (this one) which I could also have the first server send its backup to and then have this one write to a CD or something.

Any advice, help etc is greatly appreciated, I am getting tired of manual backups

Cheers,

To script an ftp upload see man lftp. It should be fairly simple to write an lftp command script to 'put' the file to the Windows FTP server and then run it using lftp -f. If you google I'm sure you'll find some examples.