From: Date: June 27 2009 9:18pm
Subject: Restoring Databases After Computer Crash
List-Archive: http://lists.mysql.com/win32/19022
Message-Id: <4A467090.5040207@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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