{"id":6944,"date":"2017-09-02T00:15:19","date_gmt":"2017-09-01T16:15:19","guid":{"rendered":"http:\/\/rmohan.com\/?p=6944"},"modified":"2017-09-02T00:15:19","modified_gmt":"2017-09-01T16:15:19","slug":"mysqlcheck","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6944","title":{"rendered":"mysqlcheck"},"content":{"rendered":"

[root@clusterserver1 software]# mysqlcheck mysql -uroot -p
\nEnter password:
\nmysql.columns_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump\/reload to fix it!
\nmysql.db OK
\nmysql.event
\nerror : Table upgrade required. Please do “REPAIR TABLE `event`” or dump\/reload to fix it!
\nmysql.func OK
\nmysql.general_log
\nerror : Table upgrade required. Please do “REPAIR TABLE `general_log`” or dump\/reload to fix it!
\nmysql.help_category OK
\nmysql.help_keyword OK
\nmysql.help_relation OK
\nmysql.help_topic OK
\nmysql.host OK
\nmysql.ndb_binlog_index OK
\nmysql.plugin OK
\nmysql.proc
\nerror : Table upgrade required. Please do “REPAIR TABLE `proc`” or dump\/reload to fix it!
\nmysql.procs_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `procs_priv`” or dump\/reload to fix it!
\nmysql.proxies_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `proxies_priv`” or dump\/reload to fix it!
\nmysql.servers OK
\nmysql.slow_log
\nerror : Table upgrade required. Please do “REPAIR TABLE `slow_log`” or dump\/reload to fix it!
\nmysql.tables_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `tables_priv`” or dump\/reload to fix it!
\nmysql.time_zone OK
\nmysql.time_zone_leap_second OK
\nmysql.time_zone_name OK
\nmysql.time_zone_transition OK
\nmysql.time_zone_transition_type OK
\nmysql.user OK
\n[root@clusterserver1 software]# mysqlcheck mysql -uroot -p
\nEnter password:
\nmysql.columns_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump\/reload to fix it!
\nmysql.db OK
\nmysql.event
\nerror : Table upgrade required. Please do “REPAIR TABLE `event`” or dump\/reload to fix it!
\nmysql.func OK
\nmysql.general_log
\nerror : Table upgrade required. Please do “REPAIR TABLE `general_log`” or dump\/reload to fix it!
\nmysql.help_category OK
\nmysql.help_keyword OK
\nmysql.help_relation OK
\nmysql.help_topic OK
\nmysql.host OK
\nmysql.ndb_binlog_index OK
\nmysql.plugin OK
\nmysql.proc
\nerror : Table upgrade required. Please do “REPAIR TABLE `proc`” or dump\/reload to fix it!
\nmysql.procs_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `procs_priv`” or dump\/reload to fix it!
\nmysql.proxies_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `proxies_priv`” or dump\/reload to fix it!
\nmysql.servers OK
\nmysql.slow_log
\nerror : Table upgrade required. Please do “REPAIR TABLE `slow_log`” or dump\/reload to fix it!
\nmysql.tables_priv
\nerror : Table upgrade required. Please do “REPAIR TABLE `tables_priv`” or dump\/reload to fix it!
\nmysql.time_zone OK
\nmysql.time_zone_leap_second OK
\nmysql.time_zone_name OK
\nmysql.time_zone_transition OK
\nmysql.time_zone_transition_type OK
\nmysql.user OK
\n[root@clusterserver1 software]#
\n[root@clusterserver1 software]#
\n[root@clusterserver1 software]# mysql -u root -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 8
\nServer version: 5.7.19 MySQL Community Server (GPL)<\/p>\n

Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n

mysql> REPAIR TABLE `columns_priv`;
\nERROR 1046 (3D000): No database selected
\nmysql> REPAIR TABLE `columns_priv`
\n-> ;
\nERROR 1046 (3D000): No database selected
\nmysql> quit
\nBye
\n[root@clusterserver1 software]# mysql -u root -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 9
\nServer version: 5.7.19 MySQL Community Server (GPL)<\/p>\n

Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n

mysql> use mysql;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n

Database changed
\nmysql> REPAIR TABLE `columns_priv`;
\n+——————–+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————–+——–+———-+————————————————————————————-+
\n| mysql.columns_priv | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.columns_priv | repair | status | OK |
\n+——————–+——–+———-+————————————————————————————-+
\n2 rows in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `db`;
\n+———-+——–+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+———-+——–+———-+———-+
\n| mysql.db | repair | status | OK |
\n+———-+——–+———-+———-+
\n1 row in set (0.01 sec)<\/p>\n

mysql> REPAIR TABLE `proc`;
\n+————+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+————+——–+———-+————————————————————————————-+
\n| mysql.proc | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.proc | repair | Warning | Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘modified’ at row 1 |
\n| mysql.proc | repair | Error | Invalid default value for ‘modified’ |
\n| mysql.proc | repair | status | Operation failed |
\n+————+——–+———-+————————————————————————————-+
\n4 rows in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `procs_priv`;
\n+——————+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————+——–+———-+————————————————————————————-+
\n| mysql.procs_priv | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.procs_priv | repair | status | OK |
\n+——————+——–+———-+————————————————————————————-+
\n2 rows in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `proxies_priv`;
\n+——————–+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————–+——–+———-+————————————————————————————-+
\n| mysql.proxies_priv | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.proxies_priv | repair | status | OK |
\n+——————–+——–+———-+————————————————————————————-+
\n2 rows in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `slow_log`;
\n+—————-+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+—————-+——–+———-+————————————————————————————-+
\n| mysql.slow_log | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.slow_log | repair | status | OK |
\n+—————-+——–+———-+————————————————————————————-+
\n2 rows in set (0.01 sec)<\/p>\n

mysql> REPAIR TABLE `tables_priv`;
\n+——————-+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————-+——–+———-+————————————————————————————-+
\n| mysql.tables_priv | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.tables_priv | repair | status | OK |
\n+——————-+——–+———-+————————————————————————————-+
\n2 rows in set (0.01 sec)<\/p>\n

mysql> REPAIR TABLE `columns_priv`;
\n+——————–+——–+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————–+——–+———-+———-+
\n| mysql.columns_priv | repair | status | OK |
\n+——————–+——–+———-+———-+
\n1 row in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `event`;
\n+————-+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+————-+——–+———-+————————————————————————————-+
\n| mysql.event | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.event | repair | Warning | Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘modified’ at row 1 |
\n| mysql.event | repair | Error | Invalid default value for ‘modified’ |
\n| mysql.event | repair | status | Operation failed |
\n+————-+——–+———-+————————————————————————————-+
\n4 rows in set (0.00 sec)<\/p>\n

mysql> REPAIR TABLE `general_log`;
\n+——————-+——–+———-+————————————————————————————-+
\n| Table | Op | Msg_type | Msg_text |
\n+——————-+——–+———-+————————————————————————————-+
\n| mysql.general_log | repair | Note | TIME\/TIMESTAMP\/DATETIME columns of old format have been upgraded to the new format. |
\n| mysql.general_log | repair | status | OK |
\n+——————-+——–+———-+————————————————————————————-+
\n2 rows in set (0.00 sec)<\/p>\n

mysql> quit
\nBye
\n[root@clusterserver1 software]# mysqlcheck mysql -uroot -p
\nEnter password:
\nmysql.columns_priv OK
\nmysql.db OK
\nmysql.event
\nerror : Table upgrade required. Please do “REPAIR TABLE `event`” or dump\/reload to fix it!
\nmysql.func OK
\nmysql.general_log OK
\nmysql.help_category OK
\nmysql.help_keyword OK
\nmysql.help_relation OK
\nmysql.help_topic OK
\nmysql.host OK
\nmysql.ndb_binlog_index OK
\nmysql.plugin OK
\nmysql.proc
\nerror : Table upgrade required. Please do “REPAIR TABLE `proc`” or dump\/reload to fix it!
\nmysql.procs_priv OK
\nmysql.proxies_priv OK
\nmysql.servers OK
\nmysql.slow_log OK
\nmysql.tables_priv OK
\nmysql.time_zone OK
\nmysql.time_zone_leap_second OK
\nmysql.time_zone_name OK
\nmysql.time_zone_transition OK
\nmysql.time_zone_transition_type OK
\nmysql.user OK<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

[root@clusterserver1 software]# mysqlcheck mysql -uroot -p Enter password: mysql.columns_priv error : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump\/reload to fix it! mysql.db OK mysql.event error : Table upgrade required. Please do “REPAIR TABLE `event`” or dump\/reload to fix it! mysql.func OK mysql.general_log error : Table upgrade required. Please do “REPAIR TABLE `general_log`” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6944"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6944"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6944\/revisions"}],"predecessor-version":[{"id":6945,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6944\/revisions\/6945"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}