Scheduling back-ups

[furst]

I'd like to schedule my server to make a backup of the mysql db and send it to my other server every 12 hours. How can I do this? I have ssh access, but I thought this was done through crontabs. I also want the destination server to hold 2 backups, overwriting the oldest one each time so that I have 2 backups for the 24 hours period.

[Colin F]

There's no function to do this in vBulletin, you'd need a third party script.
I know mysqldumper (http://www.mysqldumper.de/en/index.php)can make automatic backups and send them to a different server, but I don't think there's a way for it to overwrite existing backups.

[simsim]

cPanel automatic MySQL backups:
http://www.theadminzone.com/forums/showthread.php?t=17548

[furst]

cPanel automatic MySQL backups:
http://www.theadminzone.com/forums/showthread.php?t=17548


So I can just input the commands into crontabs that I use when backing up through shh?