Monday, 31 August 2015

Run a query in MYSQL disable writing it to the binary log

The sql-log-bin session variable to turn off

mysql>SET sql_log_bin = 0;

all queries on your current session will not be sent to the binary log.This is only for the currently running session you are in.

If you want to revert binary logging back on, run:

mysql>SET sql_log_bin = 1;

No comments:

Post a Comment