Shulou(Shulou.com)06/01 Report--

、

[xxx@dbhost log] $mysqlbinlog mysql-bin.000004

Mysqlbinlog: unknown variable 'default-character-set=utf8'

The reason is that the tool mysqlbinlog does not recognize the default-character-set=utf8 directive in the configuration in binlog.

There are two ways to solve this problem

One is to change default-character-set=utf8 to character-set-server = utf8 in the MySQL configuration / etc/my.cnf, but this requires restarting the MySQL service, which can be costly if your MySQL service is busy.

The second is to open it with the command mysqlbinlog-- no-defaults mysql-bin.000004.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.