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

Comments

Popular posts from this blog

How to get Active Transactions and Locks from MySQL

Example of a PAC file