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:/BackupDBS/DB3.sql You can modify it in order to minimize the lines in the file. You decide. Step 2. Set a scheduled task Open Control Panel and Open Scheduled Task. Follow the Wizard. Choose the backup.bat file as the program set the hour (9:00 pm), diary, and choose another options. After that let Windows manage your database backups. Enjoy, Roberto Ramírez -----Mensaje original----- De: lorenzo.kh [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 08 de Abril de 2002 12:15 a.m. Para: [EMAIL PROTECTED] Asunto: 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
