Two instances of MySql on one PC

[Subychavan]

Hello MySql experts,

I have two separate applications each using Tomcat server on one Windows 2000 PC. Both applications require MySql. MySql writes a my.ini in winnt folder, which has a path to one of the applications. I have not found a method to get the second instance of mysql running. Can someone reading this help me? Is it possible to tell mysql where the my.ini is located?

Please post your replies to css@chavan.de

Regards,
Subhash

 

[sleipnir214]

You don't need to run MySQL more than once.

MySQL is a database server and as such a single instance of the server can handle multiple queries against multiple databases at the same time.

This is in contrast to an application like Access, which is not a database server but a database engine and as such must be run multiple times to support multiple applications.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!