Not the answer you need?
Register and ask your own question!

pt-archiver seems to not do anything when using the --bulk-insert option

pjwerneckpjwerneck EntrantCurrent User Role Beginner
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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.