MySQL Forums
Forum List  »  InnoDB

Reset Log Sequence Number
Posted by: Stefan Hueneburg
Date: October 19, 2005 09:32AM


Is it possible to reset the db log sequence number for a fresh start?

I accidentally deleted the innodb logfiles during reconfiguration of the database storage. The Datafiles are not touched and should be ok.

After starting with the new logfiles i'm getting error messages like:

InnoDB: is in the future! Current system log sequence number 0 8424.
InnoDB: Your database may be corrupt.
051019 17:29:13 InnoDB: Error: page 1189291 log sequence number 15 3702051443

What is the best way to handle this situation, there is no backup of the logfiles because it's a new db which is not in production yet.

However i'd rather not import all the data (60gb) again, so any help is appreciated.


Options: ReplyQuote

Written By
Reset Log Sequence Number
October 19, 2005 09:32AM
October 19, 2005 11:24AM
October 25, 2005 07:20AM
October 25, 2005 11:37AM
January 26, 2009 10:00AM

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.