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.

  • You might be better off asking on the Percona site. They're really great - and you're likely to get answers from the actual developers of the tools. – Vérace Apr 10 '15 at 22:06
  • @Vérace I'm posting the question there too. – Pedro Werneck Apr 11 '15 at 0:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.