Ajay Kadyan Ajay Kadyan - 13 days ago 6
MySQL Question

Binary log error in mysql

When I am trying to check binary log:

SHOW BINARY LOGS;


I get this error:


ERROR 1381 (HY000): You are not using binary logging.


How to resolve this? Can anybody help?

Answer

Set the log-bin variable in your MySQL configuration file, then restart MySQL.

An example my.cnf (on Linux/unix) or my.ini (on Windows) would look like:

[client]
...

[mysqld]
...
log-bin=mysql-bin
---

Once restarted, MySQL automatically creates a new binary log (does so upon every restart). You may also wish to look at the following variables:

server-id        = 1
expire_logs_days = 4
sync_binlog      = 1

Read details on the MySQL documentation. If you're after replication setup (a primary reason for using binary logs), check out Replication configuration checklist.

Comments