Mysqlbinlog view binlog times wrong unknown variable ' Default-character-set=utf8 '

In the afternoon when troubleshooting MySQL master-slave synchronization problem, want to find some clues from the main library binlog, the bare binlog file is unable to look directly, mysqlbinlog This tool is used to view the contents of Binlog file (using the way Man Mysqlbinlog view), But using Mysqlbinlog to convert binlog files into human-readable content is an error:

[Email protected] log]$ mysqlbinlog mysql-bin.000004 mysqlbinlog:unknown variable ' Default-character-set=utf8 '

The reason is that the Mysqlbinlog tool does not recognize the DEFAULT-CHARACTER-SET=UTF8 directive in the configuration in Binlog.

Two ways to solve this problem

One is to modify Default-character-set=utf8 to Character-set-server = UTF8 in MySQL configuration/etc/my.cnf, but this requires restarting the MySQL service, if your MySQL service is busy, That would be a big price.

Second, open with Mysqlbinlog--no-defaults mysql-bin.000004 command.

Well, this article is too low in gold, good memory than bad writing, or record it ....

Mysqlbinlog view binlog times wrong unknown variable ' Default-character-set=utf8 '