problems on mysql & hebrew - running a service / running from a command line

Hello.
When I run the service : MySql, which points to same execution file,
(I have changed the key on registry :
\\HKLM\SYSTEM\ControlSet001\Services\MySql.
The key : ImagePath.
The value :
"C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt.exe" --character-set-server=utf8
.... Is there other way and not to change directly on service ?)

I got an error :
Could not start the MySql service ...
Error 1053 : The service did not respond to the start ... timely fashion.

When I run the same line :
"C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt.exe" --character-set-server=utf8"
On command line (cmd).
It runs properly with no errors.

When I change the above to Hebrew :
C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt.exe" --character-set-server=hebrew,
the program stops unexpectedly.

What am I doing wrong ? (
problem 1: On service declaration & registry,
problem 2: When changing on command line to Hebrew.

Thanks :)

Mr. X. wrote:
> Hello.
> When I run the service : MySql, which points to same execution file,
> (I have changed the key on registry :
> \\HKLM\SYSTEM\ControlSet001\Services\MySql.
> The key : ImagePath.
> The value :
> "C:\Program Files\MySQL\MySQL Server
> 5.0\bin\mysqld-nt.exe" --character-set-server=utf8
> ... Is there other way and not to change directly on service ?)
....
> What am I doing wrong ? (
> problem 1:

This really isn't a Java question.

--
Lew

Mr. X. wrote:

You have crossposted to five newsgroups. A lot of people will have
newsreaders set to ignore such widely crossposted messages. Your
question is about MySQL not about Java. I recommend you pick one
newsgroup only - say comp.databases.mysql I've set followups there (bye).


> Hello.
> When I run the service : MySql, which points to same execution file,
> (I have changed the key on registry :
> \\HKLM\SYSTEM\ControlSet001\Services\MySql.
> The key : ImagePath.
> The value :
> "C:\Program Files\MySQL\MySQL Server
> 5.0\bin\mysqld-nt.exe" --character-set-server=utf8
> ... Is there other way and not to change directly on service ?)
>
> I got an error :
> Could not start the MySql service ...
> Error 1053 : The service did not respond to the start ... timely fashion.

>
> When I run the same line :
> "C:\Program Files\MySQL\MySQL Server
> 5.0\bin\mysqld-nt.exe" --character-set-server=utf8"
> On command line (cmd).
> It runs properly with no errors.
>
> When I change the above to Hebrew :
> C:\Program Files\MySQL\MySQL Server
> 5.0\bin\mysqld-nt.exe" --character-set-server=hebrew,
> the program stops unexpectedly.
>
> What am I doing wrong ? (
> problem 1: On service declaration & registry,

I guess the name of the program to be executed should not include
parameters. There's probably somewhere else you should add those. I
don't think you should be fiddling with Registry settings directly. I'm
sure MySQL includes some configuration tools that you should use instead.

> problem 2: When changing on command line to Hebrew.
>

"Both mysqld and configure verify that the character set/collation
combination is valid. If not, each program displays an error message and
terminates." -- MySQL reference manual.

1) I doubt "Hebrew" is a valid character set name. You might want
something like ISO 8859-8.

2) I don't see why you want to change it from "utf8" - which supports
Hebrew characters.

--
RGB

Yes,
I suppose utf8 is better,
but when I run the mysqld-nt.exe on windows' services I got the error,
and on command line I don't got the error (on utf8, of course),
as I have mentioned.

How can I use the mysqld-nt on windows' service ?

Thanks :)

Well,
Right - I won't crosspost to several newsgroups,
(but it seems that I don't have got answers for my questions, for days ....
look at my question at 2/5).

O.K.
I guested too that MySql has a configuration tool,
but where is it ?

Thanks :)

On Mon, 5 May 2008 09:04:31 +0300, Mr. X. wrote:
> Well,
> Right - I won't crosspost to several newsgroups,
> (but it seems that I don't have got answers for my questions, for days ....
> look at my question at 2/5).
>
> O.K.
> I guested too that MySql has a configuration tool,
> but where is it ?

You mean OTHER than MySQL Adminstrator?

http://www.mysql.com/products/administrator/

--
3. My noble half-brother whose throne I usurped will be killed, not kept
anonymously imprisoned in a forgotten cell of my dungeon.
--Peter Anspach's list of things to do as an Evil Overlord

Seems to be good.

1. I have just run MySQLAdministrator.exe.
First time it asked me for password.
I put the user + password correctly (port 3306 - where is the port ?).
but I have got the error : "could not find settings. Either the server
service or the
configuration file could not be found ..."
2. I didn't see a way changing the default character-set (I can only view
it)/
3. I suppose something like I have first said (main question !!!)
"C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt.exe" --character-set-server=utf8"
.... Well, I cannot start the service that way, and I don't know what exactly
I should put on registry, but on command line there is no problem.
(I can run from command line, but I preffer running from service).

4. Is there any tutorial for MySQLAdministrator.exe ?

Thanks :)