How to recover a DataBase from MYD, MYI and FRM files 1

[cadbilbao]

Hello.

I've just received a backup of a MySQL database and it contains several MYD, MYI and FRM files: table_name1.myd, table_name1.myi, table_name2.frm, ...

I've just created the database and I would like to recovert the tables.

How must I perform it? Thank you very much.

 

[sleipnir214]

You don't have to convert anything.

Just copy the files into that database's dirctory on the filesystem, then make sure that the user and group as which MySQL runs has complete control over the files.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cadbilbao]

Thank you very much for the answer. Must I stop mysql daemon???

 

[sleipnir214]

I don't think it's necessary, but I generally do under these circumstances.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!