Missing .FRM and .MYI

[issam.alameh@gmail.com]

Hello,

I had a harddisk crash and i was able to recover large files that would
be most likly the MYD files,

Is there a way to figure out any of

1. how many fields per record for each file.
2. What most likely to be the record fields.
3. Recover .frm and .myi


thanks for every help

Issam

[Bill Karwin]

Re: Missing .FRM and .MYI

issam.alameh@gm ail.com wrote:[color=blue]
> 3. Recover .frm and .myi[/color]

I don't know anything about the internal structure of MYD files. But
the only idea that occurs to me is to create the table again from the
original schema, which should recreate the FRM file. Then copy the MYD
file you recovered into the data directory, and see if you can just read
it. Probably first you should run myisamchk --recover.

The MYI file is just for index data, and I believe that it might be
re-generated by MySQL during a myisamchk.

See this page for more information, including the user comments:

http://dev.mysql.com/doc/mysql/en/repair-table.html

And then begin a practice of making regular database backups. ;-)

Regards,
Bill K.