MySQL won't start after power failure

Databases
1

Hi,
our mysql database server wont start after an unsuspected system shutdown. I can start the database with innodb_force_recovery = 4 and then i get the following lines on the .err file.

InnoDB: for more information.
121115 21:49:39 InnoDB: Error: page 1196090 log sequence number
366303858209
InnoDB: is in the future! Current system log sequence number 363674086422.
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.5/en/forcing-innodb-recovery.html
InnoDB: for more information.
121115 21:49:39 InnoDB: Error: page 1196059 log sequence number
367805782117
InnoDB: is in the future! Current system log sequence number 363674086422.
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.5/en/forcing-innodb-recovery.html
InnoDB: for more information.

2

https://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

Do you have backups of the data in case the database is beyond repair?

3

You could try doing a mysqldump / restore to a new database.

5

Could restore from backup or try innodb_force_recovery=6 (SRV_FORCE_NO_LOG_REDO).

To speed up mysql shutdown times for InnoDB tables, SET GLOBAL innodb_max_dirty_pages_pct = 0; prior to shutdown.

6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.