A table appears in use and does not allow access to this
A table appears in use and does not allow access to this
I hope it serves you:
Explanation of the URL:
After investigating a little it turns out that in principle it is not a table but a view. In rare cases a mysql error blocks the view and appears in the system as a "in use" table. However, since it is not a real table, the system interprets it as a corrupt table and does not allow it to operate with it.
The main problem is that it prevents us from doing a mysql_dump or a backup that does not go table to table. Especially hard if you do not have a relatively recent backup. The simplest solution that I have found and that works without deleting the database or restarting the mysql service is to delete or rename the mysql files directly. To do this we must access the server by ssh and find the .frm fichoros that mysql saves from each table. This depends on each system but in the case of a Centos with Plesk installation we find them in / var / lib / mysql.
These files follow the nomenclature /var/lib/mysql//.frm. We must look for the file of the table in question and rename it or delete it. In my case I rename it by adding the .bck extension in case it were necessary to recover it (which was not the case).
Once done, it must have disappeared when doing SHOW TABLES. In case they keep appearing it may be due to an internal cache issue of mysql. Try using a FLUSH TABLES in case that solves it.