Phpmyadmin displays the MySQL DATA table "in use". The solution is still invalid after the fix.

In the PHP + MySQL background, some program pages do not display content. An error is prompted and must be fixed. Open phpmyadmin and select the database. Three tables are displayed as "in use ". After selecting the check box, "repair table" will be performed. An error prompt will be displayed, indicating that the table cannot be repaired. Then, from the "analysis table" and "optimization table", all failed. Failure Information Article 1: can

In the PHP + MySQL background, some program pages do not display content. An error is prompted and must be fixed. Open phpmyadmin and select the database. Three tables are displayed as "in use ". After selecting the check box, "repair table" will be performed. An error prompt will be displayed, indicating that the table cannot be repaired. Then, from the "analysis table" and "optimization table", all failed. Failure Information Article 1: can

In the PHP + MySQL background, some program pages do not display content. An error is prompted and must be fixed.

Open phpmyadmin and select the database. Three tables are displayed as "in use ". After selecting the check box, "repair table" will be performed. An error prompt will be displayed, indicating that the table cannot be repaired.

Then, from the "analysis table" and "optimization table", all failed. Failure Information Article 1: can't create new temp file

Google solution: Fix myisamchk-r-f *****. MYI forcibly. the problem persists.

Step 1: stop MYSQL and run the cmd command: net stop mysql.
Step 2: 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 that damaged the table, and rename it (xxx. MYD ).
Step 4: Execute the repair command: myisamchk-r D:/MYSQLdata/database name *. MYI (remember: mysql service stops here). Run the CMD command to enter the bin directory of mysql.
Step 5: start the MYSQL service. net start mysql.
Step 6: run the command: mysqlcheck-o-r database name-u root-p (change it to your MYSQL Administrator name as appropriate). After running the command, enter the password.

Continuing to check whether there are write permissions does not solve the problem.

Finally, we only need to consider whether the disk space is insufficient for writing? Check the drive letter capacity. The problem is automatically solved after the disk is cleared.