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?

migrated from stackoverflow.com Jan 11 at 13:47

This question came from our site for professional and enthusiast programmers.


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.