The Problem I recently worked on a customer engagement where the customer needed to archive a high amount of rows from different tables into another server (in this example for simplicity I am just archiving the results into a file).  As explained in this other blog post, Want to archive tables? Use Percona Toolkit’s pt-archiver, [&]

https://www.percona.com/blog/complex-archival-with-percona-toolkits-pt-archiver/