なんかテーブルが壊れたので修復してみた is marked as crashed and should be repaired

2014-06-20
技術関係
dbmsmysql

Table ‘tablename’ is marked as crashed and should be repaired [

一先ずチェックしてみる
CHECK TABLE tablename;

Table Op Msg_type Msg_text
tablename check warning Table is marked as crashed
tablename check warning 6 clients are using or haven’t closed the table properly
tablename check error Checksum for key:  4 doesn’t match checksum for records
tablename check error Corrupt

修復してみるとなんか治った
repair table tablename;

再度チェックしてみると治った
CHECK TABLE tablename;

Table Op Msg_type Msg_text
tablename check status OK
タイトルとURLをコピーしました