phpMyAdmin error 1932 - table doesn't exist in engine

Viewed 32685

windows 7 - xampp

I have a database with 14 tables. I worked this days with all of them without problems untill this morning.

All tables are ok except table posts. When I click on it's name (left menu in phpMyAdmin) I got a message:

#1932... posts doesnt exist in engine

On stackoverflow there are six posts with simmilar title, but there is no solution for me.

For example this is about a system table phpmyadmin.pma and on ubuntu. I'm on windows and table posts is a user table.

Any help?

2 Answers

This worked for me when I was not able to repair the table

ALTER TABLE Tablename DISCARD TABLESPACE; ALTER TABLE Tablename IMPORT TABLESPACE;

Related