MYSQLHOTCOPY

[pingLeeQuan]

I used teh above command to copy my database test1 to testBKP... I did not stop the server when i did that.

Now when i go to mysql GUI and try to open that testBKP database, i tells me tha the database is corrupted.

how can i fix this problem of corrupted DB and how to make a good back up of the database.

thanks for your resopond in advance

--quam

 

[AHinMaine]

Just for a sanity check, does a mysqldump work? --
Andy

http://www.nachoz.com

 

[pingLeeQuan]

Thanks for replying... Yes, mysqldump works and it dumps the whole database in a file.

To add another issue to mysqlhotcopy,

I wanted to see if i can create a copy of the database by restoring the dumped file into another new database by doing

mysqldump testDB < DupmedFile


and it tells eme that it cannot find testDB.

Does it restore the dumped file only to the database that it was dumped from?

thanks again

--quan

 

[AHinMaine]

Instead of using the dump command to restore the file, do it from the mysql prompt.

mysql -uuser -ppassword testDB
mysql> source /path/DumpedFile

--
Andy

http://www.nachoz.com