Re: mySQL in Hebrew/my.cnf
Noamn [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I asked about a week ago how to get mySQL to index correctly in Hebrew, and the best answer that I received was to define a my.cnf file as follows [mysqld] set-variable = default-character-set = hebrew I created the file /etc/my.cnf using the root account, stopped the mysql daemon then restarted. The daemon failed immediately. I tried this a few more times, then reluctantly came to the conclusion that there is something wrong with the /etc/my.cnf file, so I deleted it and successfully started the daemon. Is there something special which I need to define regarding the file's permissions? check in the /usr/local/share/mysql directory that you got the Hebrew charset definition file - hebrew.conf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL in Hebrew/my.cnf
I asked about a week ago how to get mySQL to index correctly in Hebrew, and the best answer that I received was to define a my.cnf file as follows [mysqld] set-variable = default-character-set = hebrew I created the file /etc/my.cnf using the root account, stopped the mysql daemon then restarted. The daemon failed immediately. I tried this a few more times, then reluctantly came to the conclusion that there is something wrong with the /etc/my.cnf file, so I deleted it and successfully started the daemon. Is there something special which I need to define regarding the file's permissions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: mySQL in Hebrew/my.cnf
You should check the error log about why the server didn't start. It should be called yourhostname.err in your data directory. I think the problem is that you put spaces around the second equal sign. The first equal sign set-variable = ... can be surrounded by spaces but the second one ... default-character-set=hebrew should not have any spaces. [mysqld] set-variable = default-character-set=hebrew You can also try invoking this option on the command line when starting the server like this: /usr/local/mysql/bin/mysqld_safe --default-character-set=hebrew with 3.23.xx I think the command is: /usr/local/mysql/bin/safe_mysqld --default-character-set=hebrew Again, no spaces around the equal sign. But putting it in my.cnf is probably the preferred method. Hope this helps, Jeremy