Question About Cronjob
 

I have a cronjob set to backup my databases on my server. Is there a way to do a cronjob to cause the backups to be copied to my local?

It really depends on what you have on your local machine. I am assuming you have windows. Here is some software that might help you.

http://restkultur.ch/personal/wolf/scripts/db_backup

Now what you could do (if you have a static IP). You could have your host allow you to access the DB from across the network and see if that would script would help, OR you could run that script on your server and it has an ftp function and it will ftp the files to a server offsite.

Me personally I have a Suse linux box here at the house and I Rsync my entire server locally just so I have a backup but since I dont do much with Windows I don't know what they have.

If you can find an Rsync for windows you could use the script above to back it up to your server then rsync it to your windows pc.

Rsync only copies changes.

HTH
Andy

This is how I do it

http://www.cgi-interactive-uk.com/mysql_dump.html