mysql table check repair
Ʈȯ : CentOS 5.x / Mysql5.0.77
> use DB; (DB)
> show tables; ( ̺ Ȯ)
> lock tables ̺ read; (ϱ ش ̺ lock ɾ б⸸ ϵ )
> repair table ̺; (ش ̺ մϴ. mysql ߰ Ͽ show full processlist;
ԷϿ ¸ Ȯ ֽϴ. repair ؼ Ʒκ Ͻñ ٶϴ.)
> unlock tables; ( Ǿ ̺ մϴ.)
> check table ̺; ( Ǿ Ȯմϴ. Msg_test ° OK̸ ó Դϴ.)
[repair ]
repair [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED]
[ɼǼ]
QUICK : ε tree մϴ.
EXTENDED : پ Ͽ ε ϴ. myisamchk --safe-recover ɾ ϴ.
repair table ʽϴ.
- '̺.frm' (Ϲ δ Ǯ root Ǯ մϴ.)
- '̺.MYI' (errcode:###)
-
- Record
- table handlerκ ###
repair OK ƴ myisamchk -o Ͽ ؾ մϴ.
ó : http://smilemoon.kr/90116319492