从阿里的数据库RDB库mysqldump下来的文件里看到
SET @@GLOBAL.GTID_PURGED='ddd7ffa8-e648-11e7-bdc7-00163e04b878:1-72683802';

这样的东西，然后在自建的数据库（宝塔）中导入，报出了如下的错误
ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

备份的时候也有提示：
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.

当然你要导入备份文件的话，把报错那几行内容注掉可以正常导入的。

然后就好奇网上查了一下，看到这文章不错，这里记录一下：

https://blog.csdn.net/woailyoo0000/article/details/88981380

版权属于：Joyber

本文链接：https://blog.qqvbc.com/default/343.html

转载时须注明出处及本声明

标签: none

添加新评论