Backup mysqldump -u root -p --opt db_name > backup.sql Restore mysql -u root -p db_name < backup.sql
Dump that into a batch file and use scheduler. Me ----- Original Message ---- From: Dave Shuck <[EMAIL PROTECTED]> To: Dallas/Fort Worth ColdFusion User Group Mailing List <[email protected]> Sent: Friday, May 11, 2007 10:43:12 AM Subject: [DFW CFUG] Auto-backup of MySql databases on Windows Does anyone have any tips for doing auto backups of MySql 5 on Windows? All the tools I know of are Linux shell scripts. -- ~Dave Shuck [EMAIL PROTECTED] http://daveshuck.instantspot.com _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
