PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn’t closed the table properly – InnoDB tables
When tables are not getting displayed anymore, and the trick for MyISAM tables isn’t working (repair the tables from the tables structure screen), repairing InnoDB tables can be done via another trick – exporting, deleting and importing them back.
In PHPMyAdmin, visit the Export menu, and there simply select Go to export the tables
Select a place where to save the file
In the tables structure, select all the tables, and select the Drop operation
A confirmation will be requested – it is important there to uncheck the Enable foreign key checks option, otherwise tables with constraints won’t be deleted.
Once the database is empty, open the Import menu, and there, browse for the file previously exported, and click Go
Tables are imported and recreated, including all content, which should be confirmed by the interface
And tables content is now displayed again !