LP #1170454: pt-table-sync line-ending problems with --print

**Reported in Launchpad by Mrten last update 05-06-2013 08:29:12

I've been using pt-table-sync to get tables for a new server synced. The procedure I've been using is that I use pt-table-sync --print to get queries to fix the differences in a file, then run that file, on the slave, with mysql < [file]. I know that it isn't perfect but I have ample opportunity to run pt-table-checksum again and again.

This works perfectly but for one snag: line-endings. CRLF's in varchars get truncated to LF's...

So, I'd suggest language in the manual to this effect:

"Be careful running the queries that are generated with --print, you may run into problems with line-endings for varchars".

Or, if you like, accept attached patch into pt-table-sync.