# grep log-bin my.cnf
log-bin = /data/3306/mysql-bin
mysql>show variables like 'log_bin';
参数 | 描述 |
-d | 指定库的binlog |
-r | 相当于重定向到指定文件 |
--start-position--stop-position | 按照指定位置精确解析binlog日志(精确),如不接--stop-positiion则一直到binlog日志结尾 |
--start-datetime--stop-datetime | 按照指定时间解析binlog日志(模糊,不准确),如不接--stop-datetime则一直到binlog日志结尾 |
#mysqlbinlog -d ceshi mysql-bin.000003 -r my.sql
#mysqlbinlog mysql-bin.000003 --start-position=100 --stop-position=200 -r my.sql
mysql>show global variables like "binlog%";
+-----------------------------------------+-----------+
| Variable_name | Value |
+-----------------------------------------+-----------+
| binlog_cache_size | 1048576 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | STATEMENT | #系统默认为STATEMENT模式
| binlog_stmt_cache_size | 32768 |
+-----------------------------------------+-----------+
4 rows in set (0.00 sec)
#vim my.cnf
[mysqld]
binlog_format='ROW' #放在mysqld模块下面
user = mysql
port = 3306
socket = /data/3306/mysql.sock
欢迎光临 168大数据 (http://www.bi168.cn/) | Powered by Discuz! X3.2 |