错误如下:
[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)
版权声明:本文为ShiMengRan107原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。