MySQL Table 복구 - Got error 127 from storage engine

by ADMINPLAY posted Jun 17, 2009
?

단축키

Prev이전 문서

Next다음 문서

ESC닫기

크게 작게 위로 아래로 댓글로 가기 인쇄

1. 에러 메세지

ERROR 1030 (HY000): Got error 127 from storage engine

2. 복구 절차

  1. Analyze Table `Table Name`
  2. Repair Table `Table Name`
  3. 3. 예제보기

    mysql> SELECT COUNT(A.IDX) AS 'CNT' FROM PRO_QNA_T A WHERE A.TYPE > 0;
    ERROR 1030 (HY000): Got error 127 from storage engine
    mysql> 
    mysql> 
    mysql> Analyze PRO_QNA_T;
    ERROR 1064 (42000): You have an error in your SQL syntax; 
    check the manual that corresponds to your MySQL server version
    for the right syntax to use near 'PRO_QNA_T' at line 1 mysql> Analyze Table PRO_QNA_T; +--------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------+---------+----------+----------+ | ihelpers.PRO_QNA_T | analyze | status | OK | +--------------------+---------+----------+----------+ 1 row in set (0.01 sec) mysql> Repair Table PRO_QNA_T; +--------------------+--------+----------+--------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+--------+----------+--------------------------------------------+ | ihelpers.PRO_QNA_T | repair | info | Key 1 - Found wrong stored record at 24884 | | ihelpers.PRO_QNA_T | repair | warning | Number of rows changed from 2187 to 2186 | | ihelpers.PRO_QNA_T | repair | status | OK | +--------------------+--------+----------+--------------------------------------------+ 3 rows in set (0.17 sec) mysql> Analyze Table PRO_QNA_T; +--------------------+---------+----------+-----------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+---------+----------+-----------------------------+ | ihelpers.PRO_QNA_T | analyze | status | Table is already up to date | +--------------------+---------+----------+-----------------------------+ 1 row in set (0.00 sec) mysql> SELECT COUNT(A.IDX) AS 'CNT' FROM PRO_QNA_T A WHERE A.TYPE > 0; +------+ | CNT | +------+ | 2186 | +------+ 1 row in set (0.01 sec) mysql>