Replication and LOAD DATA INFILE

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, “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.

Copyright © 2010-2022 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout