How To Enable Binary Log in MariaDB 10
in This Tutorial you will Learn ” How To Enable Binary Log in MariaDB 10″
MariaDB Server is one of the most popular open source relational databases.
The binary log contains a record of all changes to the databases, both data and structure.
Code – https://quicknotepadtutorial.blogspot.com/2022/02/how-to-enable-binary-log-in-mariadb-10.html
cat /etc/system-release ; mysql -V
Verify Binary Log – show variables like ‘%bin%’;
show binary logs;
Enable Binary Log – Mariadb – nano /etc/my.cnf.d/server.cnf
log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row
socket=mysql.sock
systemctl daemon-reload ; systemctl restart mariadb
Comments are closed.