最近有一台主機資料表損壞,在phpmyadmin找不到修復資料表,在命令模式中下mysql> REPAIR TABLE table_name 也沒反應,整個就是晴天霹靂,後來google了一些資料 發現由 可由mysqlcheck 來解决
# mysqlcheck -u root -p DBNAME --auto-repair
Enter password:
aaaa_house.apac_house_detail
warning : Table is marked as crashed
warning : 1 client is using or hasn't closed the table properly
error : Record at pos: 1200644676 is not remove-marked
error : record delete-link-chain corrupted
error : Corrupt
aaaa_house.apac_house_lvr OK
aaaa_house.area OK
aaaa_house.city OK
aaaa_house.road OK