MySQL Daily Backup

the cheat way to daily MySQL backups…

All solutions should not always be hard.

And that is the very reason I am so impressived with my simple straight to the bone method for accomplishing daily MySQL backups.
Please make a note this is really for small scale systems and maybe of a lesser importance. No incremental backups. Just a plain daily backup.

So here it is:

1. Create a new BAT file
2. Type the following command (make sure mysqldump.exe’s folder is in your environment path) in your BAT file:
   

   mysqldump.exe -hlocalhost -uroot -p123 mydb >c:\backup.sql

3. Create a Schedule Task in Windows and execute your BAT file – as in step 1.

Voila!!!! you have a daily backup of your MySQL database.