MySQL之mysqlbinlog二进制日志读取案例

• MySQL之mysqlbinlog二进制日志读取案例

(1) 默认查看日志

mysqlbinlog mysql-binlog.000101 

(2) 指定数据库

mysqlbinlog -d crm mysql-binlog.000101
mysqlbinlog -database crm mysql-binlog.000101

(3) 禁止恢复过程中产生日志

mysqlbinlog -D mysql-binlog.000101 > mysql-binlog.txt

mysqlbinlog --disable-log-bin mysql-binlog.000101 > mysql-binlog.txt

(4) 在输出时控制内容的编码显示格式

mysqlbinlog --base64-output=auto mysql-binlog.000101 > mysql-inlog.txt

mysqlbinlog --base64-output=decode-rows -v -v mysql-binlog.000101 >mysql-binlog.txt  

• # 可以在数据库里查询

show binlog events in 'mysql-binlog.000101' from 5555 limit 2,1;

(5) 从远程获取二进制日志

mysqlbinlog -R -h 192.168.31.151 -p mysql-binlog.000101