Skip to main content

MariaDB

Binlog

https://smarttechways.com/2021/05/27/enable-disable-the-binary-log-in-mysql/

Check bin log is enabled (ON) or disabled (OFF) mysql> show variables like 'log_bin';

Show the list of binary file created. mysql> SHOW BINARY LOGS;

Enable the Binary Log in MySQL

--For enable, edit the my.ini file and enter following parameter log-bin="RAC1-bin"

Disable the Binary log in MySQL

-- For disable the binary log, Edit the my.ini file #log-bin="RAC1-bin" --Comment the log-bin parameter skip-log-bin -- enter this in my.ini file and save and restart the mysql