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.