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:
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]
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.
What is this?
We use the IFWIS Blog to keep our staff, cooperators and the public updated on what we are working on, what's new and share tips about using our software and website.
The content of the IFWIS Blog is often highly technical, but we try our best to keep our posts accessible and jargon-free. When this is not possible, we'll link to other resources online to provide background. Thanks for reading and please follow our blog for updates.
- IFWIS RSS Feed
- Daily Email Digest (All Public Content)
- Or follow just one of the many topic-specific tag feeds or pages below.