binlog
基本认识
Mysql的二进制日志文件
查看日志文件命令
mysqlbinlog --no-defaults /usr/
查看mysql是否开启binlog,为OFF为未开启
mysql> show variables like '%log_bin%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin | OFF | | log_bin_trust_function_creators | OFF | | sql_log_bin | ON | +---------------------------------+-------+
修改mysql配置文件
/etc/my.cnf
log-bin = mysql-bin
修改完之后重启mysql
service mysqlid restart
再次查看
mysql> show variables like '%log_bin%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin | ON | | log_bin_trust_function_creators | OFF | | sql_log_bin | ON | +---------------------------------+-------+
这是binlog开启成功
此时binlog产生的文件将保存在/var/lib/mysql目录下
查看binlog日志文件 由于该文件以二级制存储,所以无法直接查看
mysqlbinlog --no-defaults /var/lib/mysql/mysql-bin.000001