INFILE is considered unsafe for statement-based
logging (see Section 220.127.116.11, “Determination of Safe and Unsafe Statements in Binary Logging”).
set, the statement is logged in row-based format. When
binlog_format=STATEMENT is set,
INFILE does not generate a warning, unlike other
When mysqlbinlog reads log events for
INFILE 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
INFILE 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.8, “mysqlbinlog — Utility for Processing Binary Log Files”.