Use the mysql dump utility

C:\mysql\bin\mysqldump --quick --user username_here --password=password_here databasename_here > C:\backups\databasename_here.sql

You can get clever by putting the above in a .bat file and scheduling it. Also check out google: http://www.google.com/search?hl=en&lr=&q=mysqldump+auto+backups



-----Original Message-----
From: Matthew [mailto:mysqldba-ezmlmshield-x55290946.[Email address protected]
Sent: Friday, August 05, 2005 15:57 PM
To: LazyDBA Discussion
Subject: Automated backup

I have mysql on a Windows server. Is there a way to automate the
exporting of the sql files for each table in my database? I'm using MyDB
Studio if that helps any. Thanks.



Matt


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com



MySQL LazyDBA home page