MySQL Forums
Forum List  »  InnoDB

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

Hi,

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.

regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Reset Log Sequence Number
19089
October 19, 2005 09:32AM
10766
October 19, 2005 11:24AM
9316
October 25, 2005 07:20AM
8413
October 25, 2005 11:37AM
5888
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.