check table & repair table

2023. 9. 14. 14:16MySQL/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