copying data base file (*.frm)

User, date Message
Written by lecosaque
8 months ago
Category: Import/Export
1 posts since Wed, 03 Oct 12
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

Written by ansgar
8 months ago
3951 posts since Fri, 07 Apr 06
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.