MySQL: Disable Binlog when importing
Disabling binary logging when restoring a MySQL dump via Planet MySQL by Geert Vanderkelen on 2009-07-19:
There is a cool option for mysqlbinlog for disabling the binary log
when doing recovery using binary logs, namely --disable-log-bin. How,
one would think it is also avialable for something like mysqldump or
even the mysql CLI? Nope.
There are various ways for doing this, here is one:
shell> (echo "SET SESSION SQL_LOG_BIN=0;"; cat dump.sql) > dump_nobinlog.sql
Obviously, bit pain for really big files, and when dumping to multiple files.