Php+mysql background, part of the program page does not display content, Error prompts error, need to repair.
Open phpMyAdmin Select Database view, and sure enough, 3 tables are displayed as "in use." Check the "Repair table", the error can not be repaired.
Then from the "Analysis table", "Optimization table" began, failed. Failure message First: Can ' t create new temp file
Google Solution: Force repair Myisamchk-r-F * * * * * * * *. Myi, the problem remains.
The first step: Stop mysql service, cmd command: net stop MySQL.
The second step: insurance, the entire database folder back up.
Step three: Open the folder where the database is located, and locate the automatically generated file (XXXX) of the system that corrupted the table. TMD), renamed (XXX. MYD).
Step Fourth: Perform the repair command: myisamchk-r d:/mysqldata/database name *. Myi (remember: Here the MySQL service is stopped) requires cmd command to enter the MySQL bin directory
Fifth step: Start MySQL service, net start MySQL.
Sixth step: Then execute the command: Mysqlcheck-o-r database name-U root-p (appropriate to your MySQL administrator name), after running prompts to enter a password.
Continuing to check for write access does not solve the problem.
Finally, only consider disk space is not enough to write? Check the capacity of the letter, sure enough. The problem is resolved automatically after Disk Cleanup.