侧边栏壁纸
博主头像
高大北博主等级

所有的再见中,我最喜欢明天见

  • 累计撰写 208 篇文章
  • 累计创建 151 个标签
  • 累计收到 20 条评论
标签搜索

目 录CONTENT

文章目录

mySQL 定时备份错误 3167 - The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the document

高大北
2022-04-26 / 1 评论 / 15 点赞 / 385 阅读 / 223 字 / 正在检测是否收录...

错误如下:

[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)

————————————————
原文链接:https://blog.csdn.net/ShiMengRan107/article/details/103991960

15

评论区