报错：
ERROR 3546 (HY000): @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED
解决方法：
将当前库的GTID_EXECUTED值置空
reset master;
# 执行完成后再导入sql脚本注意：本文归作者所有，未经作者允许，不得转载
记一次 MySQL 数据备份/迁移报错的解决方案
相关文章推荐
- 1.3万亿条数据查询如何做到毫秒级响应？
- CentOS 8安装mysql 8时报Error: Failed to download metadata for repo 'epel-modular': Cannot prepare internal mirrorlist: Sta更新yum源解决问题
- Centos7 完全卸载MySQL8.0
- centos7下安装mysql8.0.17问题整理
- Centos7安装mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar
- centos下安装mysql
- drop、truncate和delete的区别
- Java插入mysql数据时报错exceptions.PacketTooBigException: Packet for query is too large
- JDBC6.x版本与MySQL相差13个小时，CST时区导致
- libcrypto.so.10(libcrypto.so.10)(64bit) is needed by mysql-community-libs-8.0.17-1.el6.x86_64
- linux版mysql常用命令
- Lock wait timeout exceeded; try restarting transaction
- ModuleNotFoundError: No module named 'DBUtils'
- mybatis mysql获取当前数据库所有表与表字段信息
- mybatis查询到count（*）返回值
- mysql 5.7.23压缩版安装
- mysql 8.0 only_full_group_by设置相关报错
- mysql 8.0.34升级8.4.2升级完成后连接不上 Plugin 'mysql_native_password' is not loaded
- mysql binlog日志自动清理及手动删除
- mysql DateTime格式按日期group by分组查询
全部评论: 0 条
我有话说:
