: 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=...
--innodb_data_home_dir=... --set-variable=innodb_buffer_pool_size=30M
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
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 on port
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,
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.
without
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 on the
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 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 'localhost' won't
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)
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, what is the procedure to start and run more
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
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:
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
13 matches
Mail list logo
