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:
$ (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. So what is your favorite way for disabling binary logging when restoring a MySQL dump?
If you like to leave a comment, but don't like to use Disqus, please send an email instead. Comments by email might end up as a FAQ here under.