콘텐츠로 이동

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

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

  1. CHECK 구문을 사용해 테이블 상태 확인 sql 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 구문을 사용해 복구 ```sql REPAIR TABLE schema_name.table_name;

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