Jump to content
MDDHosting Forums

Best way to do offsite, automated, MySQL backups


stocktrader
 Share

Recommended Posts

What is the best way to set up automated offsite backups of a MySQL database with MDD. I would like to do a automated daily download of my 100MB database to my home computer. I do this with my MDD web files using an FTP sync program, which allows me to only have to download any files that are changed or new. Ideally, a database sync program would be great since it will save on bandwidth but I don't know if those exist.

 

I don't know a lot about MySQL backups other than you have to be careful about doing backups because the database may become corrupt if they are being written to during the snapshot process. I assume I would have to download some type of

 

The backups wouldn't have to be real-time or anything. A 1-day lag would be fine but I would prefer something better than weekly or monthly.

Link to comment
Share on other sites

There isn't any real easy way to do with cPanel/WHM itself but there are some PHP scripts out there that can do a mysqldump and then gzip that file and FTP it wherever you would like :)

 

I'll see if I can dig up the site that gave the script I used to use for this.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...