mysql5.7.31 开启binlog

Centos7 mysql5.7.31 开启binlog

1、vim /etc/my.cnf Mysql主配置文件中添加如下内容

#开启binlog
log-bin=mysql-bin
expire_logs_days=7
server-id=1
binlog_format=MIXED

2、重新启动msyql

systemctl restart mysql