Join this forum (https://bizdustry.com/?referrer=8176)

You just need to participate in the discussion going there,you will earn money for each post you made.

Once you reach 1000Biznote which can be earn within 2hours even today the money will be release immidiately to your account Note (1000Biznote = N500)

Try today and drop me your account number when you reach 1000Biznote and your account will be funded instantly,
My username there is : tray59
dont wait try now life is all about money.

Free to join.but please use my referral Link above the one I send you here to join so I can get my ref bonus.

I have withdraw alot of money there you can check my profile in that forum my username : tray59

alot of Nigerians are there.

You are not logged in. Would you like to login or register?



3/24/2022 9:37 am  #1


Corrupted innodb table crashing mysql instance how to recover table?

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

Error Log :

 [ERROR] Build InnoDB index translation table for Table ./test/xyz failed

[ERROR] Table ./test/xyz has no primary key in InnoDB data dictionary, but has one in MySQL! If you created the table with a MySQL version < 3.23.54 and did not define a primary key, but defined a unique key with all non-NULL columns, then MySQL internally treats that key as the primary key. You can fix this error by dump + DROP + CREATE + reimport of the table.


[Warning] Table ../test/xyz key_used_on_scan is 0 even though there is no primary key inside InnoDB.


[ERROR] Innodb could not find key n 0 with name PRIMARY from dict cache for table test.xyz


  • Any suggestion on how to recreate table will be highly appreciated .


 

Last edited by Albert12 (3/24/2022 9:42 am)

 

3/24/2022 10:23 am  #2


Re: Corrupted innodb table crashing mysql instance how to recover table?

Restore the corrupted or corrupted MYSQL database with its backup, in this way you can correct all types of errors. Or there are many other manual methods and repair tips available that can help you fix MYSQL errors.

 

3/24/2022 10:24 am  #3


Re: Corrupted innodb table crashing mysql instance how to recover table?

In my opinion, this is not a spam message, a message with links is still not spam. The link I gave in my previous post contains a lot of blogs about MYSQL-related issues and is very useful.

 

Board footera

 

Powered by Boardhost. Create a Free Forum

Join this forum (https://bizdustry.com/?referrer=8176)

You just need to participate in the discussion going there,you will earn money for each post you made, pls use the ref link above