Using LOAD TABLE FROM MASTER where the master
is running MySQL 4.1 and the slave is running MySQL 5.0 may
corrupt the table data, and is not supported. (Bug#16261)
The LOAD DATA INFILE statement's
CONCURRENT option is not replicated; that is,
LOAD DATA CONCURRENT INFILE is replicated as
LOAD DATA INFILE, and LOAD DATA
CONCURRENT LOCAL INFILE is replicated as LOAD
DATA LOCAL INFILE. (Bug#34628)
The following applies only if either the master or the
slave is running MySQL version 5.0.3 or older: If on
the master a LOAD DATA INFILE is interrupted
(integrity constraint violation, killed connection, and so on),
the slave skips the LOAD DATA INFILE
entirely. This means that if this command permanently inserted
or updated table records before being interrupted, these
modifications are not replicated to the slave.

User Comments
Add your own comment.