[Mysql] 'db' 테이블의 부정확한 키 존재. 수정하시오! 복구
xamp
(SELECT DISTINCT `User`, `Host` FROM `mysql`.`user` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`db` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`tables_priv` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`columns_priv` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`procs_priv` ) ORDER BY `User` ASC, `Host` ASC
#1034 - 'db' 테이블의 부정확한 키 존재. 수정하시오!
'db' 테이블의 부정확한 키 존재. 수정하시오! <--- 해당 테이블 복구 필요
[복구방법]
mysql -uroot -p*******
use mysql
MariaDB [mysql]> check table db
-> ;
+----------+-------+----------+------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------+-------+----------+------------------------------------------------+
| mysql.db | check | warning | Table is marked as crashed |
| mysql.db | check | error | Wrong base information on indexpage at page: 1 |
| mysql.db | check | error | Corrupt |
+----------+-------+----------+------------------------------------------------+
3 rows in set (0.011 sec)
MariaDB [mysql]> repair table db
-> ;
+----------+--------+----------+----------+f stage done
| Table | Op | Msg_type | Msg_text |
+----------+--------+----------+----------+
| mysql.db | repair | status | OK |
+----------+--------+----------+----------+
1 row in set (0.045 sec)
MariaDB [mysql]>