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

错误如下：

[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