MySQL backups

Discussion in 'Database Support' started by kujo2123, Aug 28, 2013.

  1. kujo2123

    kujo2123 Perch

    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.
  2. Stephen

    Stephen US Operations Staff Member

    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/
  3. cdog

    cdog Perch

    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
  4. Stephen

    Stephen US Operations Staff Member

    yes it can be done :) I actually do it on a couple!
  5. cdog

    cdog Perch

    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
  6. Stephen

    Stephen US Operations Staff Member

    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 :)
  7. kujo2123

    kujo2123 Perch

    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.

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services