The LOAD DATA
INFILE
statement was not always replicated correctly
to a slave running MySQL 5.5.0 or earlier from a master running
MySQL 4.0 or earlier. When using statement-based replication,
the LOAD DATA
INFILE
statement CONCURRENT
option
was not replicated. This issue was fixed in MySQL 5.5.0. This
issue does not have any impact on CONCURRENT
option handling when using row-based replication in MySQL 5.1 or
later. (Bug#34628)
In MySQL 5.5.6 and later,
LOAD DATA
INFILE
is considered unsafe (see
Section 17.1.2.3, “Safe and Unsafe Statements for Row-Based Logging and Replication”). It causes a
warning when using statement-based logging format, and is logged
using row-based format when using mixed-format logging.