At 17:43 24/02/2003 +0000, Simon Tyler wrote: Hi,
Hi,
I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem.
The situation is that we include MySQL with our product and manage the starting\stopping of the service ourselves (don't ask why). We currenlly use 3.23.43 and are looking to upgrade to 3.23.55.
We don't ship the full MySQL install dues to size but just ship those parts we need. Using 3.23.43 this is fine and we are able to run mysqld-nt as a service under our own service name with no problems.
With 3.23.55 this does not work. It seems that the executable requires itself to be installed as the "MySQL" service. If I do this then all is fine and good. However we don't need to install the service as we have it installed ourselves under a different name and we don't wish to do this as it may interfer with a customer who potentially has a different version of MySQL installed on the same machine. The startup options we use are:
mysqld-nt -default-file=<file> -basedir=<dir> -datadir=<dir> --port=<non-std port> -bind-address=127.0.0.1 -socket=
The cnf file is generally empty.
With these options the service starts but querying it's status fails and the port\ip that it is listening on are incorrect - the defaults are used.
Any ideas?
You can use either the version 3.23.XX or 4.0.X with a custom service name different than the default MySQL. There are 2 options:
mysqld-nt --install myservice
in the above case you need to use the same my.ini file used by the default installation, however you need to write the custom set under a section with the same name of the service instead of mysqld eg:
[myservice] port=3307 ...
if you are running several servers on the same machine you need to set different ports and not to mix the databases location which is the datadir set.
The second case is to use a different service name with a custom configuration file:
mysqld --install myservice --defaults-file=c:\anydir\my.ini
In the above case you use the section default server: mysqld and apply the same rules if you are running several servers.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ Săo Paulo - Brazil
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
