Hi,
I crash my mysql/innodb server.
I keep the ibdata1 file (21 GB) but I don't have ib_logfile0 and ib_logfile1.
I also have all FRM folders for each databases.
I'am using mysql 4.1 on windows 2003.
I can't start mysql, the error log file say :
071229 15:52:24 InnoDB: Error: page 7 log sequence number 0 14108
InnoDB: is in the future! Current system log sequence number 0 8214.
InnoDB: Your database may be corrupt.
071229 15:52:24 InnoDB: Error: page 0 log sequence number 0 15733
InnoDB: is in the future! Current system log sequence number 0 8214.
InnoDB: Your database may be corrupt.
...
InnoDB: Error: trying to access page number 2017333426 in space 0,
InnoDB: space name .\ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10
071229 15:52:24InnoDB: Assertion failure in thread 2788 in file .\fil\fil0fil.c line 3922
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to
http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB:
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
InnoDB: about forcing recovery.
071229 15:52:24 [ERROR] C:\MySQL\MySQL Server 4.1\bin\mysqld-nt: Got signal 11. Aborting!
071229 15:52:24 [ERROR] Aborting
071229 15:52:24 [Note] C:\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete
I can start mysql with this variable set in my.ini :
set-variable=innodb_force_recovery=6
But I can't dump databases, it allways says :
"ERROR 1034 (HY000): Incorrect key file for table 'comptes'; try to repair it"
What can I do ?
Thanks a lot.
Serge Chelli