Hello, When I have try to use mysqlbinlog i got this error message : mysql-write / # mysqlbinlog mysqlbinlog: unknown variable 'character_set=latin1' This error come from : [client] character_set = latin1 default-character-set = latin1 They are no need to put this two latin1, until mysqladmin and mysqbinlog don't work anymore. Regards. Reproducible: Always Steps to Reproduce: 1. 2. 3.
which mysql do you have installed?
Hello, Yes sorry, the latest stable mysql version 4.1.12-r2 I gonna to upgrade to 4.1.13-r1 Regards.
to comment #2 nope, upgrading will not help (http://dev.mysql.com/doc/mysql/en/option-files.html). please remove all "character_set" like settings from "[client]" section of your my.cnf file. to comment #2 and all the others. Those option where added in my.cnf to make easyer the life of programs that link against mysql library (one for all PHP). my.cnf file may have more section, the manual mention: [client] [mysql] [myisamchk] [myisampack] [mysqladmin] [mysqlbinlog] [mysqlcc] [mysqlcheck] [mysqld_safe] [mysqldump] [mysqlhotcopy] [mysqlimport] [mysqlshow] [mysqld] [mysql.server] [mysqld-4.0] [mysqld-4.1] ... The programs that references to the my.cnf file read the "general" section and then their specific one. For example "mysqlbinlog" will read first the "[client]" section then the "[mysqlbinlog]" one, if they exist. what we need is a "[mysqlclient]" or "[libmysqlclient]" section but it's not mentioned anywhere. A solution that modify only the my.cnf file and not all the external programs is strongly preferred.
My PHP applications don't give anymore strange "collation" errors. Also without specifing the "character_set" in [client] section. All programs which: - have a corresponding subsection in my.cnf - support some kind of characther specification now have their section explicited to stay as compatible as possible. new my.cnf is in CVS -> closing this
