Thanks Marvin.  That is exactly what I needed.

~d


On 5/11/07, Marvin Eads <[EMAIL PROTECTED]> wrote:

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/




--
~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 via email to