Can I use the same mysqld-nt.exe file to start multiple MySQLservices on Windows by specifying different port/database parameters?

#1 (**permalink**) 04-03-2008, 03:49 PM

I'm trying to use the same mysqld-nt.exe file in the same /bin folder
to start multiple MySQL services on Windows.

* I use mysqld-nt.exe --install to install services
* I use different service names
* I use different --defaults-file parameter (where I setup different
port and database location)

When I run one service the second one always terminates itself.

Thanks,
Anton

#2 (**permalink**) 04-03-2008, 03:49 PM

On Fri, 28 Mar 2008 04:43:56 -0700 (PDT), Meglio
<x.meglio@gmail.com> wrote:

>I'm trying to use the same mysqld-nt.exe file in the same /bin folder
>to start multiple MySQL services on Windows.
>
>* I use mysqld-nt.exe --install to install services
>* I use different service names
>* I use different --defaults-file parameter (where I setup different
>port and database location)
>
>When I run one service the second one always terminates itself.
>
>Thanks,
>Anton

Look in the error log.
Did you change the socket name and/or port number in
the defaults file?
Sockets and ports can't be shared by different
instances of MySQL.
--
( Kees
)
c[_] I used up all my sick days, so I'm calling in dead. (#420)

#3 (**permalink**) 04-03-2008, 03:50 PM

On Mar 28, 10:40 pm, Kees Nuyt <k.n...@nospam.demon.nl> wrote:
> On Fri, 28 Mar 2008 04:43:56 -0700 (PDT), Meglio
>
> <x.meg...@gmail.com> wrote:
> >I'm trying to use the same mysqld-nt.exe file in the same /bin folder
> >to start multiple MySQL services on Windows.
>
> >* I use mysqld-nt.exe --install to install services
> >* I use different service names
> >* I use different --defaults-file parameter (where I setup different
> >port and database location)
>
> >When I run one service the second one always terminates itself.
>
> >Thanks,
> >Anton
>
> Look in the error log.
> Did you change the socket name and/or port number in
> the defaults file?
> Sockets and ports can't be shared by different
> instances of MySQL.
> --
> ( Kees
> )
> c[_] I used up all my sick days, so I'm calling in dead. (#420)

The port and the path to the database are different. What is the
socket?

#4 (**permalink**) 04-03-2008, 03:50 PM

On Mar 28, 10:40 pm, Kees Nuyt <k.n...@nospam.demon.nl> wrote:
> On Fri, 28 Mar 2008 04:43:56 -0700 (PDT), Meglio
>
> <x.meg...@gmail.com> wrote:
> >I'm trying to use the same mysqld-nt.exe file in the same /bin folder
> >to start multiple MySQL services on Windows.
>
> >* I use mysqld-nt.exe --install to install services
> >* I use different service names
> >* I use different --defaults-file parameter (where I setup different
> >port and database location)
>
> >When I run one service the second one always terminates itself.
>
> >Thanks,
> >Anton
>
> Look in the error log.
> Did you change the socket name and/or port number in
> the defaults file?
> Sockets and ports can't be shared by different
> instances of MySQL.
> --
> ( Kees
> )
> c[_] I used up all my sick days, so I'm calling in dead. (#420)

I use different port number values and different path to the database
in my .ini files. What are sockets?

#5 (**permalink**) 04-03-2008, 03:50 PM

On Mar 28, 10:40 pm, Kees Nuyt <k.n...@nospam.demon.nl> wrote:
> On Fri, 28 Mar 2008 04:43:56 -0700 (PDT), Meglio
>
> <x.meg...@gmail.com> wrote:
> >I'm trying to use the same mysqld-nt.exe file in the same /bin folder
> >to start multiple MySQL services on Windows.
>
> >* I use mysqld-nt.exe --install to install services
> >* I use different service names
> >* I use different --defaults-file parameter (where I setup different
> >port and database location)
>
> >When I run one service the second one always terminates itself.
>
> >Thanks,
> >Anton
>
> Look in the error log.
> Did you change the socket name and/or port number in
> the defaults file?
> Sockets and ports can't be shared by different
> instances of MySQL.
> --
> ( Kees
> )
> c[_] I used up all my sick days, so I'm calling in dead. (#420)

Thanks, I just found the problem and I'm running the same .exe file as
2 services with different options.

#6 (**permalink**) 04-03-2008, 03:50 PM

Meglio wrote:
> On Mar 28, 10:40 pm, Kees Nuyt <k.n...@nospam.demon.nl> wrote:
>> On Fri, 28 Mar 2008 04:43:56 -0700 (PDT), Meglio
>>
>> <x.meg...@gmail.com> wrote:
>>> I'm trying to use the same mysqld-nt.exe file in the same /bin folder
>>> to start multiple MySQL services on Windows.
>>> * I use mysqld-nt.exe --install to install services
>>> * I use different service names
>>> * I use different --defaults-file parameter (where I setup different
>>> port and database location)
>>> When I run one service the second one always terminates itself.
>>> Thanks,
>>> Anton
>> Look in the error log.
>> Did you change the socket name and/or port number in
>> the defaults file?
>> Sockets and ports can't be shared by different
>> instances of MySQL.
>> --
>> ( Kees
>> )
>> c[_] I used up all my sick days, so I'm calling in dead. (#420)
>
> Thanks, I just found the problem and I'm running the same .exe file as
> 2 services with different options.
>

That shouldn't be a problem, as long as you have different config files.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode