Recently, our FC4 system crashed, but we were able to create a complete tar backup while in recovery mode. We then installed FC5 on a new system. Everything is working except for the mysql databases.
Here is what we did:
- After installing mysql on FC5, started mysqld. It worked fine.
- Tarred up /var/lib/mysqld to save the db
- deleted everything in /var/lib/mysqld
- untarred the /var/lib/mysqld files from the crashed system
Now when I try to start the db, the log shows the following:
060701 12:34:00 mysqld started
060701 12:34:00 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: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 0 page number 50661, page 0 in doublewrite buf.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
Cannot determine thread, fp=0xbf9a3528, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html
and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
The manual page at http://www.mysql.com/doc/en/Crashing.html
information that should help you find out what is causing the crash.
060701 12:34:01 mysqld ended
Any thoughts on what I can do to receover my databases?
Thanks for your help.