Re: MySQL crashes when making dump of innodb table
Posted by:
Aftab Khan
Date: November 20, 2012 06:08AM
>I have broken INNODB table (11Gb). I have tried to DUMP that table with all of innodb_force_recovery options. MySQL crashes on some record.
Try to dump table's data in batches, as this would help you find bad record(s) that you may skip when dumping table's data. How big is the table?
You can also try percona data recovery tool for Innodb:
http://www.percona.com/software/mysql-innodb-data-recovery-tools
Subject
Views
Written By
Posted
2823
November 18, 2012 08:28AM
Re: MySQL crashes when making dump of innodb table
1174
November 20, 2012 06:08AM
1030
November 20, 2012 07:31AM
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.