From: walter harms
Date: January 28 2013 12:01pm
Subject: log sequence number InnoDB: is in the future!?
List-Archive: http://lists.mysql.com/mysql/228877
Message-Id: <5106688C.1040900@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
hi list,
i am using mysql 5.1.53.
after a crash i have the follwing error in my log:
130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
InnoDB: is in the future! Current system log sequence number 0 2494349480.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: for more information.
according to the doc's at http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
I need to restore the database from scratch (short version). What i do not understand is what
exactly is broken ? Whole DBM ? One Instance ? (mysqlcheck says all tables are ok).
Not all tables are INNODB. Is is possible to restore only immodb tables ? (Having fun with forgein keys)
Or is there a better way to handle this ?
re,
wh