mysql - Copying too big table from a database to another via mysqldump silently drops rows -

i have command:

mysqldump -uuser1 -ppass1 --single-transaction --quick --hex-blob --triggers database1 table | mysql -uuser2 -ppass2 database2 

the table (which post table forum's database) has around 1.5m rows , has been growing on years.

this has worked, until recently. now, rows exceeding number systematically lost. strangest thing happens silently without error message.

another strange thing when transferring exact same table exact same database different database on server, i.e.

mysqldump -uuser1 -ppass1 --single-transaction --quick --hex-blob --triggers database1 table | mysql -hhost2 -uuser2 -ppass2 database2 

this still works!

there's no disk space issue on server or that. have tried manually inserting new rows same table , there no issues.

i'm guessing there might sort of buffering or memory issue related piping whole output mysqldump mysql command in 1 pipe or something?

is there simple solution, perhaps tweaking parameters of mysqldump or mysql, doesn't involve complicate stuff such breaking transfer chunks of n rows? (or simple way that)?