SET SQL_LOG_BIN

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

You can set sql_log_bin as a global variable. This is considered dangerous, though, as it can damage replication.

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