How to do regular backup in MYSQL

2002-04-04 Thread KOK HENG CHAI
Hi, 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

Re: How to do regular backup in MYSQL

2002-04-04 Thread Ciprian Trofin
Jack Daniel's Law of Motion: 'You can't fall off the floor'! Try using Task Scheduler. KHC I am using MySql version 4.0.0-alpha in Windows 2000. KHC Everytime when I want to backup the database,i do it in MS-DOS. KHC Using this command: mysqldump --opt mydatabasename mybackup.sql KHC