MySQL Forums
Forum List  »  Data Recovery

Recovering InnoDB database from ibdata1 ib_logfile0 ib_logfile1 and frm files
Posted by: Harutyun Martirosyan
Date: March 17, 2010 12:07PM

Hi.

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: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Recovering InnoDB database from ibdata1 ib_logfile0 ib_logfile1 and frm files
10527
March 17, 2010 12:07PM


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.