Re: getting .myd and .myi files into mysql

[Roland Bouman]

I never did this, so i can't be sure this helps.

But...my MySQL directoy tree looks like this:

drive:\%installdir%\data\%databasename%\

so, one distinct directory per database.
And also, for each pair of .MYD and .MYI files, I have one .FRM file.

I think that .MYD is data, MYI is index, and FRM would be format, that is, structure.
So, try to find out if you're missing those. If you cannot get those, move your MyD and MyI files to a separate location, create the tables in exactly the format of the source system (dont forget things as engine=...row_format=...character set, collation, see the create table statement in the manual), and then copy the MYI adn MYD files back.

Pls let me know if it worked out. I'm quite curious...