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.sq

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 (ie