为什么Dumpling 导出tidb数据进度都为0

tidb版本: 5.0.3
需求:
想给tidb做个mysql下游,论坛有没有对应的操作文档,
自己翻了下 想用 Dumpling 备份成sql后,导入mysql,在用binlog进行同步,这个步骤对不对,烦请指点。
刚做就碰到问题
Dumpling 导出数据20分钟了,啥东西都没有。。论坛有什么解决的办法吗。。。。

Starting component dumpling: /root/.tiup/components/dumpling/v5.0.3/dumpling -u root -p ***** -P 4000 --host 172.19.16.135 --filetype sql -t 8 -o /CCCC/backtidb/
Release version: v5.0.3
Git commit hash: 95099237b7beb80f66efaac9f3e02bd01e68bcc2
Git branch: heads/refs/tags/v5.0.3
Build timestamp: 2021-06-28 10:04:36Z
Go version: go version go1.13 linux/amd64

[2021/07/08 18:12:56.501 +08:00] [INFO] [versions.go:55] [“Welcome to dumpling”] [“Release Version”=v5.0.3] [“Git Commit Hash”=95099237b7beb80f66efaac9f3e02bd01e68bcc2] [“Git Branch”=heads/refs/tags/v5.0.3] [“Build timestamp”=“2021-06-28 10:04:36”] [“Go Version”=“go version go1.13 linux/amd64”]
[2021/07/08 18:12:56.509 +08:00] [INFO] [config.go:600] [“detect server type”] [type=TiDB]
[2021/07/08 18:12:56.509 +08:00] [INFO] [config.go:619] [“detect server version”] [version=5.0.3]
[2021/07/08 18:12:56.524 +08:00] [INFO] [client.go:193] ["[pd] create pd client with endpoints"] [pd-address="[172.19.16.80:2379,172.19.16.148:2379,172.19.16.135:2379]"]
[2021/07/08 18:12:56.526 +08:00] [INFO] [base_client.go:296] ["[pd] update member urls"] [old-urls="[http://172.19.16.80:2379,http://172.19.16.148:2379,http://172.19.16.135:2379]"] [new-urls="[http://172.19.16.135:2379,http://172.19.16.148:2379,http://172.19.16.80:2379]"]
[2021/07/08 18:12:56.526 +08:00] [INFO] [base_client.go:308] ["[pd] switch leader"] [new-leader=http://172.19.16.135:2379] [old-leader=]
[2021/07/08 18:12:56.526 +08:00] [INFO] [base_client.go:112] ["[pd] init cluster id"] [cluster-id=6964287679291523214]
[2021/07/08 18:12:56.527 +08:00] [INFO] [dump.go:1105] [“generate dumpling gc safePoint id”] [id=dumpling_1625739176527213720]
[2021/07/08 18:12:57.661 +08:00] [INFO] [dump.go:83] [“begin to run Dump”] [conf="{“s3”:{“endpoint”:"",“region”:"",“storage-class”:"",“sse”:"",“sse-kms-key-id”:"",“acl”:"",“access-key”:"",“secret-access-key”:"",“provider”:"",“force-path-style”:true,“use-accelerate-endpoint”:false},“gcs”:{“endpoint”:"",“storage-class”:"",“predefined-acl”:"",“credentials-file”:""},“AllowCleartextPasswords”:false,“SortByPk”:true,“NoViews”:true,“NoHeader”:false,“NoSchemas”:false,“NoData”:false,“CompleteInsert”:false,“TransactionalConsistency”:true,“EscapeBackslash”:true,“DumpEmptyDatabase”:true,“PosAfterConnect”:false,“CompressType”:0,“Host”:“172.19.16.135”,“Port”:4000,“Threads”:8,“User”:“root”,“Security”:{“CAPath”:"",“CertPath”:"",“KeyPath”:""},“LogLevel”:“info”,“LogFile”:"",“LogFormat”:“text”,“OutputDirPath”:"/fzcd/backtidb/",“StatusAddr”:":8281",“Snapshot”:“426177770688872450”,“Consistency”:“snapshot”,“CsvNullValue”:"\\N",“SQL”:"",“CsvSeparator”:",",“CsvDelimiter”:"\"",“Databases”:[],“Where”:"",“FileType”:“sql”,“ServerInfo”:{“HasTiKV”:true,“ServerType”:3,“ServerVersion”:“5.0.3”},“Rows”:0,“ReadTimeout”:900000000000,“TiDBMemQuotaQuery”:0,“FileSize”:0,“StatementSize”:1000000,“SessionParams”:{“tidb_snapshot”:“426177770688872450”},“Tables”:null}"]
[2021/07/08 18:15:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:17:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:19:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:21:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:23:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:25:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:27:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:29:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:31:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:33:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:35:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]
[2021/07/08 18:37:09.314 +08:00] [INFO] [status.go:38] [progress] [tables=“0/7671 (0.0%)”] [“finished rows”=0] [“estimate total rows”=0] [“finished size”=0B] [“average speed(MiB/s)”=0]

1 个赞

从你贴的日志上看,没有任何错误啊

执行的命令也ok,那tidb 里头确实有数据么?

可以参考这个:
https://docs.pingcap.com/zh/tidb/v5.1/dumpling-overview#使用---filter-选项筛选数据

追加表或者库的条件看看

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。