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

[david yeung]

This error occurs when I use the follow command.
[root@localhost ~]# mysqlbinlog --help
mysqlbinlog: unknown variable 'default-character-set=utf8'



But when I modify my /etc/my.cnf to comment the default-character-set=utf8 in the
section [client],everything goes okay.


Then my show variables like '%character%' shows the following result:


mysql> show variables like '%character%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

The default charset is not the utf8 but changes to latin1.I have to set the default character set with the command set names utf8 manually.
This is not my expected.
Anyone can give me some advice?

I'm a mysql DBA in china.
To know more details about me can visit:http://yueliangdao0608.cublog.cn



Edited 1 time(s). Last edit at 12/28/2007 11:34PM by david yeung.