2

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?

5
  • try mysqlcheck <DATABASE>. For more informations see a2hosting.com/kb/developer-corner/mysql/…
    – Jens
    Jan 11, 2019 at 13:30
  • partially restored tables will definitely be in a inconsistent state. Rerun the restore and let it complete
    – RiggsFolly
    Jan 11, 2019 at 13:37
  • 1
    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, 2019 at 13:43
  • How fast does the error come back? Immediately? Or minutes later?
    – Rick James
    Jan 11, 2019 at 21:46

1 Answer 1

1

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 and acknowledge you have read our privacy policy.

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