Mysql error Table & #39;./erchina_news/v9_search & #39; is_MySQL

Mysql reports Tableamp; #39;. erchina_newsv9_searchamp; #39; ismarkedascrashedandshouldberew.red bitsCN.com

Straight to question

This problem is reported because the table boot is broken. you only need to fix the problem.

Method 1:

Find the bin/myisamchk tool in the mysql installation directory, and enter:

Myisamchk-c-r ../data/erchina_news/v9_search.MYI

Then the myisamchk tool will help you restore the index of the data table. Restart mysql

Method 2:

If you have installed the navicat database management software, you can find the corresponding table and right-click Maintenance> repair table ..

Restart mysql

BitsCN.com