Hello everyone,
while running the “pt-archiver” tool to archive some data, we are experiencing some truncation on a TEXT column on target table, when we add the flag “–bulk-insert”. This is resulting in wrong data being archived. If we remove the “–bulk-insert” flag, there is no truncation but the process takes a lot more time, which makes the archival process not suitable for our needs.
Is this a limitation with the tool or LOAD FILE used by the tool, or something else? Also, is there a workaround for this?
Thanks.