MySQL backups

[kujo2123]

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.

 

[Stephen]

it can be done, you may need to use our firewall pass through but websql can easily take an export, and this can do it in an automated way:
http://mysqlbackupftp.com/

 

[cdog]

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

 

[Stephen]

yes it can be done I actually do it on a couple!

 

[cdog]

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

 

[Stephen]

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

 

[kujo2123]

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.