How to solve the problem that phpmyadmin displays the MySQL data table as 'in use' and it is still invalid after repair

The following tutorial column from phpmyadmin will tell you how to solve the problem that phpmyadmin displays the MySQL data table "in use" and it is still invalid after repair. I hope it will be helpful to friends in need!

PHP MySQL background, some program pages do not display content, and the error message is incorrect and needs to be repaired.

Open phpmyadmin and select the database to view. Sure enough, 3 tables are displayed as "in use". After checking "Repair Table", an error message appears and cannot be repaired.

So I started from "Analysis Table" and "Optimization Table", but they all failed. The first failure message: can't create new temp file

Google solution: force repair myisamchk -r -f ****.MYI, the problem remains.

Step one: Stop the MYSQL service, cmd command: net stop mysql.
Step 2: Be safe and back up the entire database folder.
Step 3: Open the folder where the database is located, find the file (xxxx.TMD) automatically generated by the system of the damaged table, and rename it (xxx.MYD).
Step 4: Execute the repair command: myisamchk -r D:/MYSQLdata/database name*.MYI (remember: the mysql service is stopped here). You need to enter the CMD command to enter the bin directory of mysql.
Step 5: Start the MYSQL service, net start mysql.
Step 6: Execute the command again: mysqlcheck -o -r database name -u root -p (change it to your MYSQL administrator name appropriately), and you will be prompted to enter the password after running.

Continuing to check whether there is write permission, the same cannot solve the problem.

Finally, the only thing to consider is whether the disk space is not enough for writing? Checked the drive letter capacity, sure enough. The problem is automatically solved after disk cleanup.

The above is the detailed content of How to solve the problem that phpmyadmin displays the MySQL data table as 'in use' and it is still invalid after repair. For more information, please follow other related articles on the PHP Chinese website!