콘텐츠로 이동

ERROR 1194 (HY000): Table 'table_name' is marked as crashed and should be repaired

테이블 오브젝트에 접근할 수 없음

  1. CHECK 구문을 사용해 테이블 상태 확인

    CHECK TABLE schema_name.table_name;
    +------------+-------+----------+---------------------------------------------+
    | Table      | Op    | Msg_type | Msg_text                                    |
    +------------+-------+----------+---------------------------------------------+
    | table_name | check | error    | Wrong bytesec: 0-0-0 at linkstart: 50002080 |
    +------------+-------+----------+---------------------------------------------+
    1 rows in set (4.95 sec)
    

  2. REPAIR 구문을 사용해 복구

    REPAIR TABLE schema_name.table_name;
    
    CHECK TABLE schema_name.table_name;
    +------------+-------+----------+----------+
    | Table      | Op    | Msg_type | Msg_text |
    +------------+-------+----------+----------+
    | table_name | check | status   | OK       |
    +------------+-------+----------+----------+