MySQL backups

Has anyone been able to set up something to automatically grab a mysql db backup remotely? I have an issue that a customer deleted a DB a month or so ago, and JH doesn't have backups going back that far. So I need to be able to connect to the mysql DB servers and backup each DB for our websites. I'm hoping to be able to do this automatically. I can use either Windows or Mac OS X to do it, just not sure how.
 
You might want to checkout sqlyog , I also take daily backups via a cron job elsewhere. I'm not sure if you can do it with Jodohost but can't see why you couldn't
 
Has anyone been able to set up something to automatically grab a mysql db backup remotely? I have an issue that a customer deleted a DB a month or so ago, and JH doesn't have backups going back that far. So I need to be able to connect to the mysql DB servers and backup each DB for our websites. I'm hoping to be able to do this automatically. I can use either Windows or Mac OS X to do it, just not sure how.

I run the backup via cron job and then use a batch file on my work computer to ftp in to where the backup is stored and download the backup to a local computer. You could also upload straight to storage services like dropbox etc that provide api's for uploading.

Just do a search for mysqldump on the net, that should get you going in the right direction
 
Even without API you could save it to the local dropbox folder on your desktop where it then auto uploads to dropbox, a nifty feature and easy to use :)
 
FYI, I have been using the MySQLBackupFTP program, and it works great. Very fast, and can do scheduled runs to backup and compress the DB's to my local drives.
 
Back
Top