MySQL Database Backup Recommendation

[Ban Bot]

I am looking for a Windows program to simplify MySQL backups.

My wife has a cooking website/blog (Drupal) with a MySQL database > 200MB. It has gotten to the size phpMyAdmin is quite sufficient and I am sadly not very good with the command line.

A quick google prompted me to look at MySQLBackupFTP.com http://mysqlbackupftp.com/ From the looks of it the program does what I want: You can set a schedule on your Windows PC and it will auto-connect and then download the MySQL file.

Do others have experience with this program? Better recommendations? Site Vault is another that looked promising.

Bonus Question: I use Filezilla to back up the flat files. Finding an auto-mated tool like the above, but for all her files in her HTTP folder, would be excellent. A simple Windows tool to backup both the MySQL database AND files would be perfect. Thank you for your time

 

[flexy]

Why not schedule a "normal" backup of the entire site from Cpanel on your hosting? This backup would contain everything, files, MySQL DB etc. To be honest I don't see a reason why you would need an extra program for that.

Also..from cpanel/phpadmin..you can upload/download the entire DB also of course.

 

[Bardock]

Amazon S3 is what I use at work, can be fully automated in cpanel (set up a cron job).

Or if you don't want to pay just pick a time during the week to download a backup from myphpadmin manually.

 

[Scarpozzi]

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

You can easily backup from the command line and have the whole database snapped into a file...within a very short time. Once you go through the pain of setting it up, it'll be done and you won't have to touch it. Basically, create a bash script or batch file to run the command...then use cron or scheduled tasks to run it. In the script, execute mysqldump, compress the file, and copy or mail it somewhere safe... Restores through this process are very simple as well.

 

[Zxian]

Another nice trick you can do with mysqldump is to commit the resulting backup file in git. That way you get versioned backups so you can quickly and easily restore from any point in history.

!/bin/bash

mysqldump -u user -ppassword --all-databases > mysql/alldb.sql

DATE=`date +%Y-%m-%d`

git add mysql/*

git commit -m "$DATE"

git push origin master

 

[Bardock]

^thank you for this

 

[darlasxm54]

It's a really good free disk image/backup program.