《Mysql應(yīng)用Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)問題解決方法》要點(diǎn):
本文介紹了Mysql應(yīng)用Mysql中Table ‘XXX’ is marked as crashed and last (automatic?)問題解決方法,希望對(duì)您有用。如果有疑問,可以聯(lián)系我們。
網(wǎng)站的 MYSQL 數(shù)據(jù)庫出現(xiàn)錯(cuò)誤如下提示:
代碼如下:
Table ‘.\dede_archives' is marked as crashed and last (automatic?)
該問題即為相關(guān)表受到損壞,一般情況下,可以用 phpmyadmin 對(duì)該表進(jìn)行修復(fù).
如果是獨(dú)立的服務(wù)器,也可使用命令行方式進(jìn)行修復(fù).修復(fù)前將mysql服務(wù)停止:
代碼如下:
/etc/init.d/mysqld stop
然后執(zhí)行如下命令(參考)修復(fù)該表:
代碼如下:
myisamchk -r /usr/local/mysql/var/dede/dede_archives.MYI
注意數(shù)據(jù)庫表所在路徑. win 主機(jī)下可類比執(zhí)行.
轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址:
http://www.fzlkiss.com/jiaocheng/6348.html