Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
How can I disable binary logging on MySQL 8.0?
I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in the my.cnf and restarted the database.
But with MySQL 8.0 I have tried various settings, but everytime I log onto the database, and run:
SELECT @@global.log_bin;
and it keeps returning 1
I have tried:
log_bin = 0
log_bin = OFF
#log_bin = 1
Is it possible to disable to the binary logs?
From the MySQL 8.0 Reference manual, section 5.4.4:
The following discussion describes some of the server options and variables that affect the operation of binary logging. For a complete list, see Section 17.1.6.4, “Binary Logging Options and Variables”.
Binary logging is enabled by default (the log_bin system variable is set to ON). The exception is if you use mysqld to initialize the data directory manually by invoking it with the --initialize or --initialize-insecure option, when binary logging is disabled by default, but can be enabled by specifying the --log-bin option.
To disable binary logging, you can specify the --skip-log-bin or --disable-log-bin option at startup. If either of these options is specified and --log-bin is also specified, the option specified later takes precedence.
[mysqld]section? – Rick James Jan 3 at 18:14log_bin=filename. So I changed it to (one of) the above and restarted the database. Then tried the next one etc. – IGGt Jan 4 at 9:00log_bin_basenameis where the name goes (since early in 5.6). Andlog_binhas always been ON/OFF. – Rick James Jan 4 at 22:03