469,631 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Blowing my mind how to setup multiple mysql servers on one windows box..

Having some major issues... Racking my brain. Also it is worthy to
note as of 3 weeks ago i have 0 experience with MySQL.

So anyway.. HOW DO YOU DO IT?? hehe - I can get multiple services
installed and started, but everytime i try to make any edits to them
and stop/restart they wont restart. here is my exact .ini file.

===================================

# options for mysql service 1
[testdb1]
port = 3306
datadir= C:/Program Files/MysqlInstance1/Bin/data
innodb_data_home_dir= C:/Program Files/MysqlInstance1/Bin/data
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir=C:/Program Files/MysqlInstance1/Bin/data
innodb_log_arch_dir=C:/Program Files/MysqlInstance1/Bin/data

# options for mysql service 2
[testdb2]
port = 3308
datadir= C:/Program Files/MysqlInstance2/Bin/data
innodb_data_home_dir=C:/Program Files/MysqlInstance2/Bin/data
innodb_data_file_path=ibdata2:10M:autoextend
innodb_log_group_home_dir=C:/Program Files/MysqlInstance2/Bin/data
innodb_log_arch_dir=C:/Program Files/MysqlInstance2/Bin/data

=======================================
*This is the following command i type in to get the service installed.

C:\Documents and Settings\admin>"C:\program files\mysql\mysql server
5.0\bin\mys
qld-nt" --install testdb1(or2) --defaults-file="C:\my.ini"
One thing that bothers me is this. When i open up the Instance
Manager, and look at both installed serviecs. Under the Configuration
file it says "Section Name: mysqld". I want it to use "testdb1". It
uses mysqld for both services. I can go into Startup variables and
change them but it doesnt seem to affect anything.

Any help would be greatly appreciated. Thanks.

Jun 6 '06 #1
1 2791
I may have forgotten how I did this as I did it a few years ago, but I
believe you have to use different my.ini files, at least I believe it
is the way I did it back then
ri*******@gmail.com wrote:
Having some major issues... Racking my brain. Also it is worthy to
note as of 3 weeks ago i have 0 experience with MySQL.

So anyway.. HOW DO YOU DO IT?? hehe - I can get multiple services
installed and started, but everytime i try to make any edits to them
and stop/restart they wont restart. here is my exact .ini file.

===================================

# options for mysql service 1
[testdb1]
port = 3306
datadir= C:/Program Files/MysqlInstance1/Bin/data
innodb_data_home_dir= C:/Program Files/MysqlInstance1/Bin/data
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir=C:/Program Files/MysqlInstance1/Bin/data
innodb_log_arch_dir=C:/Program Files/MysqlInstance1/Bin/data

# options for mysql service 2
[testdb2]
port = 3308
datadir= C:/Program Files/MysqlInstance2/Bin/data
innodb_data_home_dir=C:/Program Files/MysqlInstance2/Bin/data
innodb_data_file_path=ibdata2:10M:autoextend
innodb_log_group_home_dir=C:/Program Files/MysqlInstance2/Bin/data
innodb_log_arch_dir=C:/Program Files/MysqlInstance2/Bin/data

=======================================
*This is the following command i type in to get the service installed.

C:\Documents and Settings\admin>"C:\program files\mysql\mysql server
5.0\bin\mys
qld-nt" --install testdb1(or2) --defaults-file="C:\my.ini"
One thing that bothers me is this. When i open up the Instance
Manager, and look at both installed serviecs. Under the Configuration
file it says "Section Name: mysqld". I want it to use "testdb1". It
uses mysqld for both services. I can go into Startup variables and
change them but it doesnt seem to affect anything.

Any help would be greatly appreciated. Thanks.


Jun 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by phpnube | last post: by
reply views Thread by Paul DuBois | last post: by
reply views Thread by Massimo Petrini | last post: by
reply views Thread by Stefan Kuhn | last post: by
3 posts views Thread by rallykarro | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.