Configuration: 2 Linux machines running MySQL 3.23.32. One is configured as
a Master, the other as a slave. Replication from the Master to the Slave has
been confirmed for INSERT's and UPDATE's.
Problem: Loading of data onto the master using the command line tool
'mysqlimport' succeeds in loading data onto the target table on the Master
but data is never replicated to the Slave as it should be. I have not
checked to see if this also applies to the LOAD DATA INFILE command but
suspect it would yield the same behavior.
Workaround: Write a script which utilizes INSERT's and UPDATE's instead of
LOAD DATA INFILE to replace mysqlimport.
Enjoy!
LP.