pt-table-sync line-ending problems with --print
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.