本文章來給大家介紹我們?cè)谛迯?fù)表時(shí)提示Error: Table /'./db_name/table_name/' is marked as crashed and last (automatic?) repair failed的解決辦法.

修復(fù)數(shù)據(jù)表,MYSQL數(shù)據(jù)表出現(xiàn)問題,提示:

Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed  //Vevb.com

修復(fù)數(shù)據(jù)表操作:

1、service mysqld stop;

2、cd /var/lib/mysql/db_name/

3、myisamchk -r tablename.MYI(修復(fù)單張數(shù)據(jù)表)

myisamchk -r *.MYI (修復(fù)所有數(shù)據(jù)表)

注意:操作第三步前一定要把mysql服務(wù)停掉.

4. mysqlcheck -o -r 數(shù)據(jù)庫名稱 -p