when using mysql workbench I perform any operation on the table "my_table" I get an error:

Error Code: 2013 Lost connection to MySQL server during query

Previously I stopped the execution of a restore dump and the log showed the message:

"the table may be in an inconsistent state"

How can I solve this problem?

  • try mysqlcheck <DATABASE>. For more informations see a2hosting.com/kb/developer-corner/mysql/… – Jens Jan 11 '19 at 13:30
  • partially restored tables will definitely be in a inconsistent state. Rerun the restore and let it complete – RiggsFolly Jan 11 '19 at 13:37
  • I'm voting to close this question as off-topic because. The solution is obvious, if you kill a restore, at least one table will be left in an inconsistent state. – RiggsFolly Jan 11 '19 at 13:43
  • How fast does the error come back? Immediately? Or minutes later? – Rick James Jan 11 '19 at 21:46

If you kill a restore mid flow, then it is very likely you will leave a table in an inconsistent state.

The first thing you should try is to rerun the restore and allow it to complete.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.