admin管理员组文章数量:1638806
错误如下:
[Batch Job] Batch Job 121_test_bak start
--------------- 2020-01-15 16:31:39 ---------------
[BAK] Backup schema information_schema start
[BAK] Getting tables
[BAK] Getting views
[BAK] Getting functions
[BAK] Getting events
[BAK] Getting data info
[ERR] 3167 - The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'
[ERR] Failed on server service run begin options!
[BAK] Finished - Unsuccessfully
原因:
从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,此时需要打开 show_compatibility_56
解决办法:
mysql> show variables like '%show_compatibility_56%'; # 查看show_compatibility_56%的开关
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | OFF |
+-----------------------+-------+
1 row in set (0.01 sec)
mysql> set global show_compatibility_56=on; # 打开show_compatibility_56的开关
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%show_compatibility_56%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | ON |
+-----------------------+-------+
1 row in set (0.01 sec)
本文标签: 错误informationschemamysqldisabledDocument
版权声明:本文标题:mySQL 错误 3167 - The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the document 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1729279853a1193930.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论