LOAD DATA is considered unsafe for statement-based logging (seeSection 5.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). Whenbinlog_format=MIXED is set, the statement is logged in row-based format. Whenbinlog_format=STATEMENT is set, note thatLOAD DATA does not generate a warning, unlike other unsafe statements.
Whenmysqlbinlog reads log events forLOAD DATA statements logged in statement-based format, a generated local file is created in a temporary directory. These temporary files are not automatically removed bymysqlbinlog or any other MySQL program. If you do useLOAD 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, seemysqlbinlog — Utility for Processing Binary Log Files.