mysql日志管理工具_MySQL日志管理工具 mysqlbinlog

[root@db02 data]# ls mysql_bin.0*

mysql_bin.000001 mysql_bin.000002

使用cat查看都是乱码的，要使用mysqlbinlog

[root@db02 data]# cat mysql_bin.000001

\þbinŔ̚tx5.6.36-logŔ̚8

󿃑n¯±̚ @std!!!testBEGINC)¯±̚.턁teststunد±̚ 2 Fÿþþþǒ꯱̚?Y

-* ²̚ @std!!!testBEGIN¯ ²̚.µFteststu󾻙 ²̚(ہFÿþ䃮 ²̚񱑐 p²̚H @std!!!testBEGINH𴨰²̚.rFteststuսݴp²̚(Fÿp²̚¹c0¦ºxp²̚ @std!!!testBEGIN䈍̚./FteststuM¤ް²̚(WFÿþ鈪9p²̚veؚ󝳍ZH @std!!!testBEGINc

,²̚.ꂆteststun0®S²̚(Fÿþ꟎²̚3k{\˗²̚H @std!!!testBEGIN§Z[²̚.©Fteststu²̚(τFÿþp6*²̚򃫴h

[root@db02 data]# mysqlbinlog mysql_bin.000001

[root@db02 data]# mysqlbinlog mysql_bin.000001

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;

/*!40019 SET @@session.max_insert_delayed_threads=0*/;

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;

DELIMITER /*!*/;

# at 4

#180411 12:53:25 server id 1 end_log_pos 120 CRC32 0x6ed142e0 Start: binlog v 4, server v 5.6.36-log created 180411 12:53:25 at startup

ROLLBACK/*!*/;

....................

-d  只显示对test数据库的操作日志

[root@db02 data]# mysqlbinlog -d test mysql_bin.000001

-o选项 忽略前3个操作

[root@db02 data]# mysqlbinlog mysql_bin.000002 -o 3