I would use the Windows 'AT' command (make sure the Scheduler service is running) to call a .CMD script with a mysqldump query.
Here's one we use ... the filename is dbbak.cmd: mysqldump --all --add-drop-table --add-locks --complete-insert --compress -- extended-insert --flush-logs --force --opt --verbose --databases customers>n:\dbbakup\customers.sql The AT command looks like: at 01:00 /every:M,W,F cmd.exe /c "c:\winnt\dbbak.cmd" ----- Original Message ----- From: "Nixarlidis Aris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 8:28 AM Subject: Backup automation.. Hi, I am looking for a way to automate the way i take backups. I run mysql on w2k server and I seek for a way to take backups of the database at certain times automaticaly. Is out there any suggestion? thanks.. --------------------------------------------------------------------- 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
