MySQL Forums
Forum List  »  Data Recovery

Re: InnoDB recovery
Posted by: Marko Mäkelä
Date: August 02, 2007 03:13AM

Rudolf,

You could proceed as follows:

1) dump the internal InnoDB data dictionary using innodb_table_monitor:
http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
http://dev.mysql.com/doc/refman/5.1/en/innodb-monitor.html

2) ensure that the frm files correspond to the InnoDB data dictionary

3) for each table, do SELECT * FROM table

InnoDB will probably crash for some tables in step 3) because of missing or unwritten pages. Just restart and proceed to next table.

The InnoDB redo log is essential for correct operation. There can be large numbers of dirty pages in the InnoDB buffer pool (RAM) that have not been written to disk. In crash recovery (when mysqld is restarted), these dirty pages will be reconstructed from the redo log (ib_logfiles).

Best regards,

Marko Mäkelä
Innobase Oy/Oracle Corp.

Options: ReplyQuote


Subject
Views
Written By
Posted
11794
July 24, 2007 01:53AM
Re: InnoDB recovery
7319
August 02, 2007 03:13AM


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.