解决mysql二进制日志恢复数据报错:@@GLOBAL.GTID_MODE = OFF.
发布时间:2020-08-02 03:24:25
来源:51CTO
阅读:21699
作者:莲池管俊涛
解决mysql利用二进制日志恢复数据报错:ERROR 1781 (HY000) at line 16: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
工作中,运用二进制日志,帮开发的同事恢复数据时,出现了报错告警:[root@localhost tmp]# mysqlbinlog --no-defaults mysql-bin.000614|mysql -uroot -p
Enter password:
ERROR 1781 (HY000) at line 16: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
[root@localhost tmp]# mysqlbinlog --no-defaults mysql-bin.000614|mysql -uroot -p
Enter password:
[root@localhost tmp]# echo $?
0
服务器相关环境参数:
服务器系统:CentOS Linux release 7.3.1611 (Core)
MySQL版本:
mysql