A MYSQL error locks the view and appears in the system as a table “in use”. However, since it is not a real table, the system interprets it as a corrupt table and does not allow operating with it.
-Go to the database:
– Search for .frm files that MYSQL saves in each table and rename it or delete it:
find . -name "*.frm" -type f|less
– Create temp folder:
– Move files there:
for each in `find . -name "*.frm" -type f`; do mv $each frmbk/; done
– If still error, try flush tables.
mysql> FLUSH TABLES;
That’s all folks, see you later!