wimp

Simple mySQL Backups on Windows

Quick and easy backups from mySQL on windows courtesy of http://realm3.com/articles/how_to_schedule_regular_mysql_backups_in_windows

The article has everything you need, just archiving the main points here for posterity:

Create mysql-backup.bat:

@echo off
echo Running dump...
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" -u[username] -p[password] --result-file="D:\mySQLbackup\content-backup.%DATE:~0,3%.sql" [database]
echo Done!

Add a scheduled task to run nightly, script above creates one file for each day of the week.

Email your backup administrator to add D:\mySQLbackup to their tapes.