Today, because the server is automatically shut down, the error "fail1Table" appears when I open the website again. \ xxx "is marked as crashed and shoshould be retried red. After analysis, I found two ways to solve this problem on the Internet, for more information, see.
Solution 1
I installed phpmyadmin myself to bring a modification function and find out what went wrong. You can see that the prompt "in use" is usually displayed, so this table has a problem, I can fix the problem with phpmysqdmin, as shown in red.
Prompt for successful modification
This means that the repair is successful. Check whether the table is ready.
Solution 2
To the bin/myisamchk tool in the mysql installation directory,
Enter:
The Code is as follows: |
Copy code |
Myisamchk-c-r ../data/dedecmsv4/dede_archives.MYI
|
Then the myisamchk tool will help you restore the index of the data table.
Mysql does not need to be restarted
Note: site Original article reprint must indicate the source http://www.bKjia. c0m/database/database.html