MySQL Forums
Forum List  »  Data Recovery

Re: Recovery with only ibdata1 file
Posted by: John David Duncan
Date: May 30, 2007 06:03PM

Hi Kirk, there's a solution in your case: Reissue the "CREATE TABLE" statement on some other MySQL server. This will generate a correct .frm file for you.

For Sean, though, the problem is quite a bit worse. In any transactional database, the log file is a crucial component, and it's usually not possible to recover the data to a consistent point without the log file.

Options: ReplyQuote


Subject
Views
Written By
Posted
44161
August 30, 2005 08:57PM
21164
August 17, 2006 08:58PM
19668
August 31, 2006 11:00AM
17891
February 20, 2007 03:37AM
17441
March 09, 2007 02:59PM
15744
S R
May 30, 2007 12:46PM
24548
October 18, 2007 06:13AM
Re: Recovery with only ibdata1 file
15105
May 30, 2007 06:03PM
17162
September 27, 2007 01:26AM


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.