Hugh is correct...

Identical to Hugh...only the thing which I have chnaged is..dump file name...this would be unique here..
Your batch file should looks like this...(you should include complete paths here...say for mysqldump.exe & for backup file)


set myBackupFile=myDBDump_%Date:~-4,4%%Date:~-10,2%%Date:~-7,2%
C:\mysql\bin\mysqldump --quick --user username_here --password=password_here databasename_here > C:\backups\%myBackupFile%.sql

For mysqldump check out here

http://dev.mysql.com/doc/mysql/en/mysqldump.html
----- Original Message -----
From: Hugh du Toit
To: LazyDBA Discussion
Sent: Tuesday, August 09, 2005 7:45 PM
Subject: RE: Automated backup




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




---------------------------------------------------------------------
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