New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

mysql导入时报错ERROR 3546 #2

Open

apple1563 opened this issue Aug 2, 2023 · 0 comments

Owner

apple1563 commented Aug 2, 2023

如果GTID开启，在导入时可能会报如下错误：

ERROR 3546 (HY000) at line 24: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED

解决方法：在导出时指定--set-gtid-purged=off 或者 comment。或者再导入前，删除DUMP文件中SET GTID_PURGED语句。

使用mysql恢复数据库命令 mysql8数据库恢复
https://blog.51cto.com/u_16099356/6367427

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment