2023. 9. 14. 14:16ㆍMySQL/etc
mysql> check table mysql.proxies_priv;
+--------------------+-------+----------+-------------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+-------------------------------------------------------------------------------------------+
| mysql.proxies_priv | check | error | Table upgrade required. Please do "REPAIR TABLE `proxies_priv`" or dump/reload to fix it! |
+--------------------+-------+----------+-------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> repair table mysql.proxies_priv;
+--------------------+--------+----------+-------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------+--------+----------+-------------------------------------------------------------------------------------+
| mysql.proxies_priv | repair | Note | TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format. |
| mysql.proxies_priv | repair | status | OK |
+--------------------+--------+----------+-------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> check table mysql.proxies_priv;
+--------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+----------+
| mysql.proxies_priv | check | status | OK |
+--------------------+-------+----------+----------+
1 row in set (0.00 sec)
'MySQL > etc' 카테고리의 다른 글
proxies_priv entry (0) | 2023.11.06 |
---|---|
[ERROR] Unknown/unsupported storage engine: BLACKHOLE (0) | 2023.11.06 |
ERROR 1201 (0) | 2023.09.01 |
[iptables] 2003, error connecting to master 'replicator@' (0) | 2023.08.24 |
스토리지 엔진 (0) | 2022.10.21 |