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?
Best Answer
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.