MySQL 5.7 Release Notes
LOAD DATA is considered unsafe
for statement-based logging (see
Section 16.2.1.3, “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”.