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.

Before MariaDB 5.5 and before MySQL 5.6 one could also set sql_log_bin as a global variable. This was disabled as this was too dangerous as it could damage replication.

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