Recover tables from data files

[Joshua Beall]

Hi All,

I've got a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all the MySQL data files from the data directory. How can I restore the data from the MYD and FRM files, or whatever other files I should be looking at in the data directory?

I've been doing some searching on this and it sounds like for MyISAM I should just be able to copy database subdirectory from the old MySQL data directory to the new MySQL data directory. However, that's not working for me. A database with the name f the database I'm trying to recover shows up in the list of databases in phpMyAdmin, but there are no tables in the database. Ironically, if I run SHOW TABLES, it shows me all the tables--however, any operation on those tables (e.g., SELECT * FROM {table}" returns a "no such table" error.

One of the tools I ran across in my search is DBACentral by MicroOLAP. It's got component that's supposed to restore data from FRM/MYD files, but when I tried to run it, it didn't list any tables that it could recover from my FRM/MYD files.

Any insights would be greatly appreciated... thanks!

-Josh