Re: regular backup database in mysql

hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. "back0.bat" in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot -

RE: regular backup database in mysql

EZ... Step 1. Create a BATCH FILE. backup.bat D:\YourPath\Mysql\Bin\mysqldump --opt DB1 > C:/BackupDBS/DB1.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB2 > C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB3 > C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB4 > C:/BackupDB