昨天一位 VPS 客戶說(shuō)他的 WordPress 博客沒(méi)了，網(wǎng)站可以打開(kāi)，但是文章都沒(méi)了，懷疑被黑。我們登陸客戶 VPS 后沒(méi)發(fā)現(xiàn)被黑跡象，然后進(jìn)入 MySQL 數(shù)據(jù)庫(kù)發(fā)現(xiàn) Table ‘./wordpress/wp_posts’ is marked as crashed and should be repaired 錯(cuò)誤，因?yàn)?wp_posts 表被損壞了，所以 WordPress 的文章都顯示不出來(lái)：
# mysql -u root -p
Enter password:
mysql> use wordpress;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from wp_posts;
ERROR 145 (HY000): Table './wordpress/wp_posts' is marked as crashed and should be repaired
mysql> Bye
修復(fù) MySQL 數(shù)據(jù)庫(kù)數(shù)據(jù)表問(wèn)題可以由 mysqlcheck 來(lái)解決，先用 mysqlcheck 查看一下：
# mysqlcheck -u root -p wordpress
Enter password:
然后添加 –auto-repair 參數(shù)自動(dòng)修復(fù)，最好修復(fù)前備份一下數(shù)據(jù)庫(kù)：
# mysqldump -u root -p wordpress > wordpress.sql
Enter password:
# mysqlcheck -u root -p wordpress --auto-repair
Enter password:
wordpress.wp_commentmeta
error : Table upgrade required. Please do "REPAIR TABLE `wp_commentmeta`" or dump/reload to fix it!
wordpress.wp_comments
error : Table upgrade required. Please do "REPAIR TABLE `wp_comments`" or dump/reload to fix it!
wordpress.wp_links
error : Table upgrade required. Please do "REPAIR TABLE `wp_links`" or dump/reload to fix it!
wordpress.wp_options
error : Table upgrade required. Please do "REPAIR TABLE `wp_options`" or dump/reload to fix it!
wordpress.wp_postmeta
error : Table upgrade required. Please do "REPAIR TABLE `wp_postmeta`" or dump/reload to fix it!
wordpress.wp_posts
error : Table upgrade required. Please do "REPAIR TABLE `wp_posts`" or dump/reload to fix it!
wordpress.wp_term_relationships OK
wordpress.wp_term_taxonomy
error : Table upgrade required. Please do "REPAIR TABLE `wp_term_taxonomy`" or dump/reload to fix it!
wordpress.wp_terms
error : Table upgrade required. Please do "REPAIR TABLE `wp_terms`" or dump/reload to fix it!
wordpress.wp_usermeta
error : Table upgrade required. Please do "REPAIR TABLE `wp_usermeta`" or dump/reload to fix it!
wordpress.wp_users
error : Table upgrade required. Please do "REPAIR TABLE `wp_users`" or dump/reload to fix it!
Repairing tables
wordpress.wp_commentmeta OK
wordpress.wp_comments OK
wordpress.wp_links OK
wordpress.wp_options OK
wordpress.wp_postmeta OK
wordpress.wp_posts OK
wordpress.wp_term_taxonomy OK
wordpress.wp_terms OK
wordpress.wp_usermeta OK
wordpress.wp_users OK