Currently I'm trying to recover a database with InnoDB tables which is down because of abnormal termination of server (the electricity has just gone :-().
I have all the files that are in my server, but when I try to start it with "service mysqld start" it hangs for 30 secs then says:
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
From mysql log:
100317 21:53:25 mysqld started
100317 21:53:25 InnoDB: Error: page 1 log sequence number 0 69585642
InnoDB: is in the future! Current system log sequence number 0 15520.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: for more information.
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 2.
InnoDB: You may have to recover from a backup.
100317 21:53:25 InnoDB: Page dump in ascii and hex (16384 bytes):
I've tried to set innodb_force_recovery variable to values 1, 4, 6 the maximum result was, I've seen the structure.
What can I do in this situation? Please help.
Edited 2 time(s). Last edit at 03/17/2010 12:02PM by Harutyun Martirosyan.