Backup and Restore of MySQL database

Hello Everybody

I have made a small software using MySQL as backend and ASP is middleware and HTML as frontend.

Now the software is completed and working quite fine, only missning feature is backup/restore. I want to give the user the option of having backup/restore, and that backup option should backup the required tables from database in some other location (ie on the same server as MySQL). Similarly there should be restore where user can restore his tables only in case of catastrophe.

My question is what is the best way to do it?? first is MySQL has any option to for this kind of backup and can use the MySQL feature through ASP? second if first is not possible what is best way to do it, i.e. whether I make text files, or install another MySQL server and copy the data to that (I dont want this option) etc etc??

Please help

Hello, Is anybody there??

you will need to loop though the tables and fields, and store the information in a sql format, then you will need to create a parser that will take that file and execute a the sql queries restoring the databaes.

Or you could try reading the mySQL documentation.

BACKUP_TABLE, and mysqldump, may be of particular interest.

Hadley