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?
Asked by IGGt
(2276 rep)
Jan 3, 2019, 04:49 PM
Last activity: Mar 14, 2025, 03:56 PM
Last activity: Mar 14, 2025, 03:56 PM