Nov 8, 2018

How to fix: mysqldump: Got error: 1146: Table doesn't exist when using LOCK TABLES


mysql> drop table database_name.table_name;

(optional: verify the table does have problem before you drop it)

mysqlcheck -u mysql_username -p database_name

database_name.table_name
Error: Table 'database_name.table_name' doesn't exist
status: Operation failed