dumpling无法导出快照数据问题

可以实际的去看一下导入的文件,是否有数据。导入的日志可能有点误导

[2022/11/04 15:48:51.850 +08:00] [INFO] [writer.go:254] [“no data written in table chunk”] [database=test] [table=t] [chunkIdx=0]

[2022/11/04 15:48:51.850 +08:00] [INFO] [collector.go:239] [“backup success summary”] [total-ranges=4] [ranges-succeed=4] [ranges-failed=0] [total-take=8.660476ms] [total-kv-size=57B] [average-speed=6.582kB/s] [total-rows=1]

[2022/11/04 15:48:51.850 +08:00] [INFO] [main.go:80] [“dump data successfully, dumpling will exit now”]

[tidb@vm172-16-201-64 tidb_script]$ cd …/backup/test/

[tidb@vm172-16-201-64 test]$ ll

total 16

-rw-rw-r-- 1 tidb tidb 147 Nov 4 15:48 metadata

-rw-rw-r-- 1 tidb tidb 95 Nov 4 15:48 test-schema-create.sql

-rw-rw-r-- 1 tidb tidb 57 Nov 4 15:48 test.t.0000000010000.sql

-rw-rw-r-- 1 tidb tidb 136 Nov 4 15:48 test.t-schema.sql

[tidb@vm172-16-201-64 test]$ more test.t.0000000010000.sql

/!40101 SET NAMES binary/;

INSERT INTO t VALUES

(1);

[tidb@vm172-16-201-64 test]$

1 个赞