1、开启mysql的bin-log日志
找到mysql的配置文件/etc/my.cnf,在里面加入下面语句
[mysqld]
slow_query_log_file=/usr/local/mysql/log/slow.log #开启Mysql的慢查询日志
log-bin=/usr/local/mysql/log/mysql-bin #开启Mysql的二进制日志
log-error=/usr/local/mysql/log/err.log #开启Mysql的错误日志
general_log_file=/usr/local/mysql/log/general.log
2、查看Mysql的二进制日志文件
2.1 查看二进制文件是否开启成功
show variables like 'log_bin%';
+---------------------------------+--------------------------------------
| Variable_name | Value |
+---------------------------------+--------------------------------------+
| log_bin | ON |
| log_bin_basename | /usr/local/mysql/log/mysql-bin |
2.2查看最后的log-bin文件信息
show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000003 | 120 | | | |
+------------------+----------+--------------+------------------+-------------------+
3、关于二进制日志的一些操作
3.1 开启一个新的二进制日志,从当前时刻,记录对数据库的更新操作
flush logs;
3.2 清空所有的bin-log日志
reset master;
3.3 查看最后一个log-bin文件
show master status;
mysqlbinlog --no-defaults mysql-0001.bin