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 -pxxx --opt databasename >c:\Archive\%1\arch.sql arj m arch arch.sql rem END BACKUP then you call this batch file from scheduled task in control pannel with syntax "c:\back0 Mon" and set scheduled task to run every monday at 9:00 pm which will then create a backup of this database in dir c:\Arhive\Mon\arch.sql first line do mysqldump of database "databasename" into archive on local filesystem c:\Arhive\arch.sql second line (if you have utiliti ARJ) do a move of arch.sql into arj arhive with name arch.arj with this aproach you can setup backup with scheduled tasks for every day in a week or even once a month etc.... I do backup in this way on several PCs in my firm so I have arhive for every day for past 7 days on at least 3 different locations nice day primoz ----- Original Message ----- From: "lorenzo.kh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 8:14 AM Subject: regular backup database in mysql > I am using MySql version 4.0.0-alpha in Windows 2000. > Everytime when I want to backup the database,i do it in MS-DOS. > Using this command: > >mysqldump --opt mydatabasename > mybackup.sql > Now,lets say i never shut down my pc and the MySql is running all the time. > How can i do a regular backup (ie.every evening 9.00 pm) automatically? > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
