MySQL Forums
Forum List  »  Data Recovery

Re: Restore MySQL Data from Windows System Failure
Posted by: Matt Pellegrino
Date: October 04, 2009 10:58PM

Hello,

Unfortunately you will need at least the .frm file as well to preform and sort of restore of your database. Even with InnoDB recovery tools:

http://code.google.com/p/innodb-tools/wiki/InnodbRecoverySteps

You would need the transaction log files (ib* files) as well as the .frm in order for it to generate the header file and grab the table schema.


Matt Pellegrino
Support Engineer
mpellegrino @ hosting.com
www.Hosting.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore MySQL Data from Windows System Failure
3577
October 04, 2009 10:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.