Il 26/03/2013 14:14, Claudio ML ha scritto:

Hello all,

I have a strange behaviour with mysql on a 32bit OpenSuSE. The problem is: in my.cfg i have the following:

[mysqld] port = 3306 socket = /var/run/mysql/mysql.sock # Change following line if you want to store your database elsewhere datadir = /var/lib/mysql key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M default-character-set= latin1

When i start Mysql it fails with the following log:

130326 21:55:28 InnoDB: Waiting for the background threads to start 130326 21:55:29 InnoDB: 5.5.30 started; log sequence number 4115714 130326 21:55:29 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=latin1' 130326 21:55:29 [ERROR] Aborting

With the same configuration, on OpenSuSE 12.3 64bit it works correctly. If i try to remove the entry 'default-character-set=latin1' it starts perfectly, but i need it...

What is the problem? Is a bug?

Cordially,

Claudio Prono.

Sorry, i have already solved it changing the following lines: #default-character-set= latin1 character_set_client=latin1 character_set_server=latin1 Strange, it changes to character_set_client e character_set_server, dunno why...anyways now works correctly. Cordially, Claudio Prono. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org