jokerneedjokes 发表于 2020-9-2 00:31

gtid备份恢复

本帖最后由 jokerneedjokes 于 2020-9-2 00:53 编辑

在做gtid 备份恢复的时候,出现了一点问题,CSDN上面也没有一样的错误可以参考,请教大佬{:1_893:}
@Joker data]# mysqlbinlog
--skip-gtids
--include-gtids='c38e036a-e7b0-11ea-bb86-000c2958d755:5-10'
--exclude-gtids='c38e036a-e7b0-11ea-bb86-000c2958d755:7' /data/mysql/data/mysql-bin.000003 >/root/backup/bin.sql

ERROR: Malformed Gtid_set specification 'c38e036a-e7b0-11ea-bb86-000c2958d755:5-10--exclude-gtids=c38e036a-e7b0-11ea-bb86-000c2958d755:7'.
ERROR: Could not configure --include-gtids 'c38e036a-e7b0-11ea-bb86-000c2958d755:5-10--exclude-gtids=c38e036a-e7b0-11ea-bb86-000c2958d755:7'
mysqlbinlog
--skip-gtids
--include-gtids='c38e036a-e7b0-11ea-bb86-000c2958d755:5-10'
--exclude-gtids='c38e036a-e7b0-11ea-bb86-000c2958d755:7' /data/mysql/data/mysql-bin.000003 >/tmp/joker.sql
就可以执行了 wtf:@
为什么换到临时目录下就可以执行命令了????????????
页: [1]
查看完整版本: gtid备份恢复