MYSQL修复数据表(国外英语资料).doc

MYSQL修复数据表(国外英语资料) Mysql error: Table XXX is marked as error and should be repaired Mysql error: Table XXX is marked as error and should be repaired I really appreciate the Internet, and the people who selflessly serve their knowledge! One day in the office, the friends QQ icon is intense and shiny, one look, it is the BBS problem, the specific error is as follows: The Table . \ Tablename \ posts is marked as being repaired and should be repaired Note that BBS posts are marked with problems and need to be fixed. I remember also appear similar problem before, but as long as click repair on the Phpmyadmin button is automatically restored, but this is absolutely nothing. So hurry up to surf the Internet to find the reason. Eventually the problem will be solved. The solution is as follows: Find the bin/myisamchk tool for the mysql installation directory and type in the command line: Myisamchk - c-r.. / data/tablename/posts. MYI Then the myisamchk tool will help you restore the index of the data table. It doesnt seem that you need to restart mysql. Problem analysis: 1. Error causes, some netizens said frequent query and update dede_archives table caused by the index error, because I dont have a static page generation, but a dynamic page, therefore more agree with this statement. And claim as the damage of the MYSQL database and for some reason, such as: the database server sudden power outages, provide service in a database table with a table of some sort of operation is likely to lead to the original file The MYSQL database table was corrupted and unable to read the data. In any case, there are some unmeasurable problems that cause the damage to the table. The problem number is 145 Problem solving. When you try to fix a broken table, there are three types of fixes. If you get an error message indicates a temporary file cannot be established, delete information, points out the file and try again - this is usually the last legacy of repair operation. The three fixes are s