CODEWITHSUNDEEP
mysqlmysqlbinlogbinlog
MarvinD
MarvinD

Reputation: 1

cannot enable bin-logs for mysql

I have an old 5.7 mysql database that crashed last week. But i was able to start it again.

Now we have an issue where certain settings are disabled but were or are still enabled in my.cnf.

The setting are log-bin and errors logs.

No logs were logged or bin-logs were generated since last week when mysql crashed.

Enabling this on my.cnf does not have any difference. Restarted mysql multi times and still does not enable bin-log.

Show variables like "bin-log";

Is off.

On the config file i have the following

log-error=/var/datadir/mysqld.log
server_id               = 1
log-bin                 = /var/datadir/mysql-bin.log
binlog_format           = row

But both error-log and bin-log are not working.

Any idea what could be causing this?

Tried to recreate the my.cnf config from another mysql server and just change the ip address. And still bin log is not enabled

Upvotes: 0

Views: 49

Answers (1)

chan fander
chan fander

Reputation: 1

The mysqld has a search path to load the my.cnf in a certain order, please make sure you know this point.

Upvotes: 0

Related Questions