Phpmyadmin shows that the MySQL DATA table is "in use" and the solution is still invalid. phpmyadminmysql

Phpmyadmin shows that the MySQL DATA table is "in use" and the solution is still invalid. phpmyadminmysql

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.

The mysql table is displayed as "in use" in phpmyadmin and cannot be repaired. mysql service may stop unexpectedly.

What is the frequency of unexpected stop when err logs are not retained? By the way, leave a Q

I used phpmyadmin to add data to mysql. Why is there no data in mySql data?

You are a windows server. Open your mysql folder and find my. INI file. Open this file in a text editor and search for datadir. My Data is datadir = "D:/MySQL/Data/", that is, my Data file has d: /mysql/data. Check the datadir path you set here.