MySQL database table '. Phome_ecms_news ' is marked as crashed and last (automatic?) Workaround

Last night, the site's msql suddenly a bit of a problem, the index of the article is broken, looking for a long time to finish

Baidu search, said to repair the damaged table with phpMyAdmin, according to do, the problem is not resolved,

Helpless district official Find the answer, finally solved, the harm of my cold did not wear clothes for half an hour!

If your server is a stand-alone host, it is strongly recommended that you repair it using the command-line method:
Stop the MySQL service before fixing it.
If it is a win host, open the command line and go to MySQL's Bin directory.
Perform Myisamchk-r d:mysqldatadiscuz*. Myi
where d:mysqldatadiscuz the path to your database.
If it is a Unix-like host, use the MYISAMCHK-R database directory * directly. Myi.

When I use the second method, the table is being used in phpMyAdmin and the phpMyAdmin repair operation cannot repair the table. That's the third way, friend server with the win server host, so open the command line, first stop MySQL service: net stop MySQL, and then into the MySQL bin directory, input: Myisamchk-r d:mysqldatadiscuz*. Myi, if you can confirm which table, you can also put the previous * number directly to the specific table name, general repair no problem. After the carriage return is determined, the repair process is in a table of one table, one row after another.