MySQL Forums
Forum List  »  InnoDB

Re: innodb log sequence error
Posted by: Marko Mäkelä
Date: December 15, 2006 09:16AM

The only safe fix is to make an SQL dump of all data, hope that it is correct,
create the database from the scratch, and reimport the data. The ib_logfiles must always be in sync with the ibdata and *.ibd files. Otherwise, crash recovery will fail or corrupt the data files. Crash recovery is automatically done when InnoDB starts.

In order to create the database from the scratch, you will have to delete all ib_logfile*, ibdata*, *.ibd, and *.frm of all InnoDB tables. You can preserve other types of tables. InnoDB will automatically create the data and log files at startup when they are missing.

Best regards,

Marko Mäkelä
Innobase Oy/Oracle Corp.

Options: ReplyQuote


Subject
Views
Written By
Posted
30302
December 07, 2006 11:59AM
15098
December 07, 2006 01:31PM
13844
December 12, 2006 12:34PM
15010
December 15, 2006 01:40AM
17370
December 20, 2006 05:45AM
Re: innodb log sequence error
18546
December 15, 2006 09:16AM
10416
January 21, 2009 02:04PM


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.