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;
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