SET SQL_LOG_BIN

Enable or disable binary logging for the current session. This statement allows administrators to perform operations without replicating them to replicas.

Syntax

SET [SESSION] sql_log_bin = {0|1}

Description

Sets the sql_log_bin system variable, which disables or enables binary logging for the current connection, if the client has the SUPER privilege. The statement is refused with an error if the client does not have that privilege.

Note that setting sql_log_bin=1 has no effect if log_bin variable, which enables global binary logging, is not set.

Current

You cannot set sql_log_bin as a global variable.

< 5.6 / 5.5

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}