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

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


Popular posts from this blog

How to get Active Transactions and Locks from MySQL

Example of a PAC file