Restoring Databases After Computer Crash

[Chris Montgomery]

Howdy,

I had MySQL 5.0.18 running on a Windows XP Pro box. This computer 
crashed and I am now using a temporary Win XP Home box. I had several 
MySQL databases on the old computer before it crashed, but 
unfortunately, didn't have .sql dumps of the databases before it 
crashed. I do, however, have the old hard drive that I pulled out of the 
old machine and have installed it on the new temporary machine.

I reinstalled MySQL (version 5.1.35) on the temporary Win XP Home 
machine. My hope was to be able to recover the database files from the 
old hard drive. I copied the mysql files from the "data" folder on the 
old hard drive to the new mysql installation's data folder then fired up 
my database client program (I'm using SQLYog). I discovered that it 
created all of the databases that I had from the old installation before 
my computer crash but that only the databases with *.myd file extensions 
actually showed the tables under their associated database. The 
databases that had just *.frm files did not show the tables.

Does anyone know if it's possible to recover the tables under that 
databases that don't have associated *.myd files?

Thanks!

-- 
Best regards,

Chris Montgomery