pt-archiver --source [src dsn] --dest [dst dsn] --where "last_updated BETWEEN '2015-01-26 00:00:00' AND '2015-02-01 23:59:59'" --ignore --no-check-columns --no-ascend --limit=10 --progress=10
And everything seems to be working as expected. However, when I add the --bulk-insert option to use LOAD DATA, everything seems fine and I can see queries running on both databases, but no data gets changed after the first chunk of 10 rows is committed. It’s like the tool is not committing a transaction or something like that.
I doubt the tool would have such a bug, so I’m assuming I’m missing something. Any ideas?