Stardust

Error MYSQL ‘Table’ Doesn’t Exist in Engine

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:

cd /var/lib/mysql/name_of_db

– 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:

mkdir frmbk

– 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!

1 thought on “Error MYSQL ‘Table’ Doesn’t Exist in Engine

Leave a Reply

Your email address will not be published. Required fields are marked *