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

After an operation on the MySQL database with PHPMyAdmin, for example complicated search queries that didn’t bring any result and crashed, it might happen that the database isn’t accessible anymore. At this point, when trying to open a table, no content is displayed.

The first step is to check the mysql_error.log file – in XAMPP, it is accessible via the control panel, in MySQL > Logs > mysql_error.log

Error might look as the following :

Table abcd is marked as crashed and should be repaired

1 client is using or hasn't closed the table properly

At this point, the solution depends on the database engine.

For MyISAM tables, see below. For InnoDB, see this specific article.

With MyISAM tables, go to the table structures of the specified database.

There, select the tables to repair by checking the corresponding boxes, and simply select the Repair option.

After getting the operation success message, the tables should be accessible again.

Related articles across the web

• PHP Multi MySQLDump (New)
• Open Source Licenses Comparison [Guide]
• 5 Ways to Be Found by Local Consumers
• Features vs. Benefits: What’s the Difference & Why It Matters
• Stuff The Internet Says On Scalability For March 3rd, 2017
• 5 Security Tools for Remote Startups on a Shoestring Budget