t;
>Subject: Re: Multiples instances of MySQL
>
>Hi!
>
>You could try the following: make Windows batch files where you give all
options to mysqld-max.exe on the command line:
>
>instance1.bat:
>
>mysqld-max --port=3306 --socket=... --datadir=... --basedir=...
> Sent: 31 December 2001 16:34
> To: Emmanuel van der Meulen
> Cc: MySQL General List
> Subject: RE: Multiples instances of MySQL
>
>
> On Mon, 2001-12-31 at 14:01, Emmanuel van der Meulen wrote:
> > Hello Martin,
> >
> > [snip]
> > > Ok. Try to
On Mon, 2001-12-31 at 14:01, Emmanuel van der Meulen wrote:
> Hello Martin,
>
> [snip]
> > Ok. Try to explicitly set the host on the command line:
> >
> > eg: mysqladmin -h 127.0.0.1 -P 2000 .
> >
> >
> > Note that you should use the ip address of your host or its network
> > name. Using '
Hello Martin,
[snip]
> Ok. Try to explicitly set the host on the command line:
>
> eg: mysqladmin -h 127.0.0.1 -P 2000 .
>
>
> Note that you should use the ip address of your host or its network
> name. Using 'localhost' won't do what you want.
I include commands of two instances which I
On Mon, 2001-12-31 at 10:50, Emmanuel van der Meulen wrote:
>
> As suggested, I used -S instead of -P, but still the first instance shuts
> down.
>
> I'm running on Win2K Pro. Is there a different way for Windows?
>
> Please advise any further pointers?
>
Ok. Try to explicitly set the host
Hello Sammy & Martin,
Thank you for your notes and assistance.
** Martin;
> Try using the -S option to select the instance via the Unix domain
> socket rather than the port number (assuming this is a Unix
> installation).
** Sammy;
> use --socket instead of -P would solve your problem.
>
> with
use --socket instead of -P would solve your problem.
without -h, socket file is used for connection. since you've not specified the socket
file, the default socket file path is used (in some case, /tmp/mysql.sock). that's why
you're always shutting down the first one.
Happy new year.
On Mon,
On Mon, 2001-12-31 at 10:08, Emmanuel van der Meulen wrote:
> Hello all,
>
> I'm in a spot, I'm managing to successfully run several instances of MySQL,
> say on port=3306 and port=3308.
>
> When I use shutdown, the instance which started first shuts down.
>
> To shutdown the instance started o
Hello all,
I'm in a spot, I'm managing to successfully run several instances of MySQL,
say on port=3306 and port=3308.
When I use shutdown, the instance which started first shuts down.
To shutdown the instance started on port 3306, I use;
mysqladmin -P 3306 -u root -p2000 shutdown
And to shutd
Hello Heikki,
Note, this is a duplicate posting - erroneously posted against 'General
database questions'.
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as
Hi!
You could try the following: make Windows batch files where you give all
options to mysqld-max.exe on the command line:
instance1.bat:
mysqld-max --port=3306 --socket=... --datadir=... --basedir=...
--innodb_data_home_dir=... --set-variable=innodb_buffer_pool_size=30M ...
instance2.bat:
m
Hello Tony,
Thank you for your note and assistance.
However, I'm stuck on a particular point;
I use Win2k Pro; struggling with 3rd option below, 'server-specific
options', for multiple instances; MySQL does not see the \mysql\data\my.cnf
options file, for some reason it only sees c:\winnt\my.i
See manual section 4.1.4.
- Original Message -
From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 9:47 AM
Subject: Multiples instances of MySQL
> Hello all,
>
> Could someone please advise, wha
Hello all,
Could someone please advise, what is the procedure to start and run more
than one instance of MySQL?
Kind regards
Emmanuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
14 matches
Mail list logo
