locked
Corrupted innodb table crashing mysql instance how to recover table? RRS feed

  • Question

  • Hello,

    Running a simple query against corrupted innodb table is crashing mysql instance .

    table test.xyz got corrupt during crash and truncate table command was in progressing when mysql crash , now
    running a simple select * query is also crashing db .
    mysql> use test;
    Database changed
    mysql> select * from xyz;
    ERROR 2013 (HY000): Lost connection to MySQL server during query
    mysql>
    mysql>
    mysql> select * from xzy;
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ERROR:
    Can't connect to the server
    Wednesday, September 24, 2014 5:12 PM

Answers

  • Well, this is a Microsoft SQL Server forum, and such things don't happen with SQL Server.


    Bodo Michael Danitz - MCT, MCITP - free consultant - performance specialist - www.sql-server.de

    Wednesday, September 24, 2014 6:59 PM
  • Try to start mysql with innodb_force_recovery = 6

    Or to try to restore by means of the tool:
    MySql Recovery Toolbox and find out how you can use the corrupt MySQL recovery tool for damaged database restoration and easily repair known issues or already known problems, occurred in MySql files. This MySql repair utility offers many benefits like:

    Supports all MySql file versions and parses even very large documents on older PC computers;
    Supports primary and external keys, tables, views, indexes and other objects;
    Allows previewing recovered data in freeware mode so you can get results without purchasing MySql Recovery Toolbox

    For more information: http://www.mysqlrecoverytoolbox.com/

    As you can look for the answer here: http://www.filerepairforum.com/forum/databases/databases-aa/mysql/197-corrupted-innodb-table-crashing-mysql-instance-how-to-recover-table
    • Marked as answer by RonaldMas3 Sunday, September 28, 2014 8:04 AM
    Sunday, September 28, 2014 8:00 AM

All replies

  • Hello,

    Running a simple query against corrupted innodb table is crashing mysql instance .

    table test.xyz got corrupt during crash and truncate table command was in progressing when mysql crash , now
    running a simple select * query is also crashing db .
    mysql> use test;
    Database changed
    mysql> select * from xyz;
    ERROR 2013 (HY000): Lost connection to MySQL server during query
    mysql>
    mysql>
    mysql> select * from xzy;
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ERROR:
    Can't connect to the server
    Wednesday, September 24, 2014 5:10 PM
  • Well, this is a Microsoft SQL Server forum, and such things don't happen with SQL Server.


    Bodo Michael Danitz - MCT, MCITP - free consultant - performance specialist - www.sql-server.de

    Wednesday, September 24, 2014 6:59 PM