PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Table content not displaying
Web-en

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn’t closed the table properly – InnoDB tables

ybierling , , , , , , , , , , , , , , , , , , , , ,

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.

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Table content not displaying
Table content not displaying

In PHPMyAdmin, visit the Export menu, and there simply select Go to export the tables

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Database full export
Database full export

Select a place where to save the file

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Database export file destination
Database export file destination

In the tables structure, select all the tables, and select the Drop operation

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Drop tables operation
Drop tables 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.

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Drop tables confirmation, foreign keys check disabled
Drop tables confirmation, foreign keys check disabled

Once the database is empty, open the Import menu, and there, browse for the file previously exported, and click Go

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Importation back of the database conent
Importation back of the database conent

Tables are imported and recreated, including all content, which should be confirmed by the interface

Import confirmation
Import confirmation

And tables content is now displayed again !

PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn't closed the table properly - InnoDB tables : Tables content displayed again
Tables content displayed again

Related articles across the web