Creating a daily backup MySQL database in Windows

You may using Windows as your database server, but don’t know how to backup it, and some of you may use tools. You can actually do it by running this command

“C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump.exe” –host=localhost -uroot -ppassword –opt mydatabase > “C:\helmy\backup\%date:~10,4%_%date:~4,2%_%date:~7,2%_backup.sql”

It will create a file 2008_04_04_backup.sql

If you want to schedule it, put it on a backup_db.bat and ask Windows Task Scheduler to run it

---

Possibly related posts: (automatically generated)

• TUTORIAL: How to install PHP and MySQL on IIS
• Ask TUAW: Joystick as mouse, remote access, PC friendly zip files, and more
• 7 Things You Should Know About Upgrading to Windows 7

~ by pakcikkantin on April 4, 2008.