Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: dumpling无法导出快照数据问题
|
username: xxxxxxxx
tidb 4.0.13 version
dumpling version information
Release version:
Git commit hash: 0175843056a6068dd2f64afca6277d890934b63c
Git branch: master
Build timestamp: 2020-06-08 02:26:25Z
Go version: go version go1.13.4 linux/amd64
Test case
(1) Delete the record with id = 6737072 around 14:10
(2) Use dumpling to export the snapshot of id = 6737072 at 14:00:00
(3) Operation command
./dumpling -u root -p pass -h 127.0.0.1 -P 4001 --consistency “snapshot” --snapshot “2022-11-04 14:00:00” -T tidbtest.t -F 64m --filetype sql -r 10000 -t 2 -o out
(4) Backup result, found that the snapshot data was not backed up
(5) Query the snapshot at 14:00:00 in the database and found that it can be queried
PS: If you use mydumper, it works
./mydumper -u root -p pass -h 127.0.0.1 -P 4001 -t 2 -F 32 --skip-tz-utc -o out -B tidbtest -T t -z ‘2022-11-04 14:00:00’ – This backup shows the data with id = 6737072
Above, I don’t know if it’s because I’m using the wrong command or for some other reason.
|
username: