• 世界75亿人,这么小的概率,能认识你,是我一生的幸运,不妨加个QQ接触一下:52249909

数据库导出Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions【显哥出品,必为精品】

MySQL lixian 5年前 (2022-03-03) 12887次浏览 1个评论

数据库导出报错

Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, 
even those that changed suppressed parts of the database. If you don't want to restore GTIDs, 
pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.

说明

mysqldump  Ver 10.13 Distrib 5.6.34, for Linux (x86_64)
关于GTID是5.6以后,加入了全局事务 ID (GTID) 来强化数据库的主备一致性,故障恢复,以及容错能力。
官方给的:A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (master).
所以可能是因为在一个数据库里面唯一,但是当导入其他的库就有可能重复。所有会有一个提醒。

可以通过添加--set-gtid-purged=off 或者–gtid-mode=OFF这两个参数设置。
个人认为是在导入库中重新生产GTID,而不用原来的。

lx656.top , 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:数据库导出Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions【显哥出品,必为精品】
喜欢 (1)

您必须 登录 才能发表评论!

(1)个小伙伴在吐槽
  1. Cool. I spent a long time looking for relevant content and found that your article gave me new ideas, which is very helpful for my research. I think my thesis can be completed more smoothly. Thank you.
    Sign Up2023-03-12 15:18