184.108.40.206 Replication and LOAD DATA
LOAD DATA is considered unsafe for statement-based logging (see Section 220.127.116.11, “Determination of Safe and Unsafe Statements in Binary Logging”). When
binlog_format=MIXED is set, the statement is logged in row-based format. When
binlog_format=STATEMENT is set, note that
LOAD DATA does not generate a warning, unlike other unsafe statements.
When mysqlbinlog reads log events for
LOAD DATA statements logged in statement-based format, a generated local file is created in a temporary directory. These temporary files are not automatically removed by mysqlbinlog or any other MySQL program. If you do use
LOAD DATA statements with statement-based binary logging, you should delete the temporary files yourself after you no longer need the statement log. For more information, see Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”.