Re: Need a SIMPLE and COMPLETE Backup Tool

[Barry Galbraith]

I use a gui tool called SQLYog from here http://code.google.com/p/sqlyog/downloads/list to do one off backups, and it can be used to restore as well.

But for a scheduled backup I use a batch file similar to what PB has described, run as a Scheduled Task in Windows. My batch generates the file name with the backup date embedded so you can keep multiple backups

> do not show how to restore a database.

c:\>mysql -uroot -p < backup_file.sql

The mysql commandline client can work in batch mode to load a file, as well as interactive mode.

Good luck,
Barry.