Mysql 복구
까먹지말자/Mysql 2012/05/02 10:13에러 메세지
Error 1016 : Can't open file: '테이블.MYI'. (errno: 145)
복구 방법
명령어 : mysqlcheck -u계정명 -p --auto-repair -B DB명
Enter password : 비밀번호
mysql> repair table 테이블명;
+---------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+----------+
| 테이블명 | repair | status | OK |
+---------------------+--------+----------+----------+
1 row in set (34.24 sec)
+---------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+----------+
| 테이블명 | repair | status | OK |
+---------------------+--------+----------+----------+
1 row in set (34.24 sec)
