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
44427
August 30, 2005 08:57PM
21284
August 17, 2006 08:58PM
19818
August 31, 2006 11:00AM
18001
February 20, 2007 03:37AM
17590
March 09, 2007 02:59PM
15838
S R
May 30, 2007 12:46PM
24933
October 18, 2007 06:13AM
Re: Recovery with only ibdata1 file
15290
May 30, 2007 06:03PM
17368
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.