My MySQL database server crashed but I managed to recover copies of the
I have followed instructions, including some from this site, that say to do a clean install and overwrite the new
.frm files with the old ones.
I have also tried forcing InnoDB recovery with
innodb_force_recovery=6 but no success yet. I am guessing that my
ibdata1 file is corrupt. The most recent backup I have is like a month old and no good for my purposes.
Anymore ideas on how I could recover my database(s)?
Here's the important part of my error log:
130322 11:41:15 [Note] Plugin 'FEDERATED' is disabled. 130322 11:41:15 InnoDB: The InnoDB memory heap is disabled 130322 11:41:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130322 11:41:15 InnoDB: Compressed tables use zlib 1.2.3 130322 11:41:15 InnoDB: Initializing buffer pool, size = 44.0M 130322 11:41:15 InnoDB: Completed initialization of buffer pool 130322 11:41:15 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 22 MB InnoDB: Database physically writes the file full: wait... 130322 11:41:15 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 22 MB InnoDB: Database physically writes the file full: wait... 130322 11:41:16 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130322 11:41:17 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130322 11:41:17 InnoDB: Error: page 7 log sequence number 2452699171 InnoDB: is in the future! Current system log sequence number 2452696588. 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.
The "page x log sequence number" part repeats through out the log file for different pages.