I'm running pt-archiver like this:
pt-archiver --source ... --dest .. --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 fine. However, when I add the
--bulk-insert option to use LOAD DATA, everything seems fine and I can see queries running on the database, but no data is changed. It's like the tool is not committing a transaction or something like that.
I'm using MySQL 5.6 on Amazon RDS and Percona Toolkit 2.2.12.