copying data base file (*.frm)

[expired user #6608]'s profile image [expired user #6608] posted 12 years ago in Import/Export Permalink
Hi,

In a 1st step I have installed a wrong version of easyphp.With this version I started a wordpress config and I have created a database.
In a 2nd step I have replaced this wrong version without having exported the created DB.

I try to copy data base files (*.frm) in the sql/data's folder -> In Heidi SQL I see the DB but it is empty (no table) !
Do you know if there is a way to get back the previously created tables?

Best regards,
Ivan

ansgar's profile image ansgar posted 12 years ago Permalink
For MyISAM tables there are more than these .frm files. You need one .myd file for the data and one .myi file for indexes per table, so you have 3 files for one table.

Also, MySQL strongly recommends not to mess with these files! If you copy or move them, you should at first shutdown the server (mysqld.exe).

Please login to leave a reply, or register at first.