Recently upgraded to MySQL 5.7
and I am in the process of setting up binary log.
I have enabled the binary log but I am not able to set the log_bin_basename
and binary log path. It showing it is a global read only variable. I need to separate binary logs from data directory. How to edit the log_bin_basename
?. After editing in configuration file, the server not starting. Thanks in advance.
1 Answer
After, discussion with my colleagues, I found that, the log_bin_basename
is read only variable and it took the value from the log-bin
definition. So I added another variable log-bin
, without modifying the default log_bin
variable. Now the binary log enabled and basename pointed to the separate directory.
# BINARY LOGGING
#log_bin # This is default
log-bin = /logs/binlog/mysql-bin
log_bin_basename = /logs/binlog/mysql-bin
expire_logs_days = 5
sync-binlog = 1
log_bin_basename
can be set only inmy.cnf
, followed by a reset.