Multiple MySQL installs - 2 applications [help modify my.cnf/my.ini]

Here's my installation issue:

I have two versions of an application (I'll refer to it as "ABC"). One
version of the tool requires MySQL 4.1.x and the other requires MySQL
5.0.x, which is not an issue as I can install each of these on their
own port; 3346 and 3356 respectively.

The complex part of this problem is that ABC's executable is ABC in
both versions of the tool. In the past I could easily define ABC in the
my.ini/my.cnf by calling the client with [ABC].

Each version of ABC resides in it's own directory:
C:\Program Files\ABC1\
C:\Program Files\ABC2\

The client connection process is limited to an installation application
that asks for the following:

Server:
Username:
Password:
Database:

How can I get both of these versions to connect to their respective
MySQL installation.

Thank you in advanced!

-L

Re: Multiple MySQL installs - 2 applications [help modifymy.cnf/my.ini]

Sorry my first email went personal instead of the group!!!

Maybe try something like this:

server:port#

For example:

10.10.10.1:3356

Or
If you're using dsn names:

Myserver.com:3356

Hope this helps


On 7/5/06 08:47, in article
1152103625.587046.94740@75g2000cwc.googlegroups.com, "kription@gmail.com"
wrote:

> Here's my installation issue:
>
> I have two versions of an application (I'll refer to it as "ABC"). One
> version of the tool requires MySQL 4.1.x and the other requires MySQL
> 5.0.x, which is not an issue as I can install each of these on their
> own port; 3346 and 3356 respectively.
>
> The complex part of this problem is that ABC's executable is ABC in
> both versions of the tool. In the past I could easily define ABC in the
> my.ini/my.cnf by calling the client with [ABC].
>
> Each version of ABC resides in it's own directory:
> C:\Program Files\ABC1\
> C:\Program Files\ABC2\
>
> The client connection process is limited to an installation application
> that asks for the following:
>
> Server:
> Username:
> Password:
> Database:
>
> How can I get both of these versions to connect to their respective
> MySQL installation.
>
> Thank you in advanced!
>
> -L
>

Re: Multiple MySQL installs - 2 applications [help modify my.cnf/my.ini]

Unfortunately this didn't work..

Any other ideas.

I have a feeling that modifying the my.ini/.cnf may be required.

Thank you,

-L

Shawn Hamzee wrote:
> Sorry my first email went personal instead of the group!!!
>
> Maybe try something like this:
>
> server:port#
>
> For example:
>
> 10.10.10.1:3356
>
> Or
> If you're using dsn names:
>
> Myserver.com:3356
>
> Hope this helps
>
>
> On 7/5/06 08:47, in article
> 1152103625.587046.94740@75g2000cwc.googlegroups.com, "kription@gmail.com"
> wrote:
>
> > Here's my installation issue:
> >
> > I have two versions of an application (I'll refer to it as "ABC"). One
> > version of the tool requires MySQL 4.1.x and the other requires MySQL
> > 5.0.x, which is not an issue as I can install each of these on their
> > own port; 3346 and 3356 respectively.
> >
> > The complex part of this problem is that ABC's executable is ABC in
> > both versions of the tool. In the past I could easily define ABC in the
> > my.ini/my.cnf by calling the client with [ABC].
> >
> > Each version of ABC resides in it's own directory:
> > C:\Program Files\ABC1\
> > C:\Program Files\ABC2\
> >
> > The client connection process is limited to an installation application
> > that asks for the following:
> >
> > Server:
> > Username:
> > Password:
> > Database:
> >
> > How can I get both of these versions to connect to their respective
> > MySQL installation.
> >
> > Thank you in advanced!
> >
> > -L
> >

Re: Multiple MySQL installs - 2 applications [help modifymy.cnf/my.ini]

Potentially, you can run a virtual machine on your server and run one of the
mysql instances on that virtual machine with its own ip address. You can
even run both mysql servers on the same port because ip addresses are
different!

Am not not sure how you can change the conf file to accommodate something
like this??!!

-s


On 7/5/06 19:55, in article
1152143704.857237.289170@m73g2000cwd.googlegroups.com, "kription@gmail.com"
wrote:

> Unfortunately this didn't work..
>
> Any other ideas.
>
> I have a feeling that modifying the my.ini/.cnf may be required.
>
> Thank you,
>
> -L
>
> Shawn Hamzee wrote:
>> Sorry my first email went personal instead of the group!!!
>>
>> Maybe try something like this:
>>
>> server:port#
>>
>> For example:
>>
>> 10.10.10.1:3356
>>
>> Or
>> If you're using dsn names:
>>
>> Myserver.com:3356
>>
>> Hope this helps
>>
>>
>> On 7/5/06 08:47, in article
>> 1152103625.587046.94740@75g2000cwc.googlegroups.com, "kription@gmail.com"
>> wrote:
>>
>>> Here's my installation issue:
>>>
>>> I have two versions of an application (I'll refer to it as "ABC"). One
>>> version of the tool requires MySQL 4.1.x and the other requires MySQL
>>> 5.0.x, which is not an issue as I can install each of these on their
>>> own port; 3346 and 3356 respectively.
>>>
>>> The complex part of this problem is that ABC's executable is ABC in
>>> both versions of the tool. In the past I could easily define ABC in the
>>> my.ini/my.cnf by calling the client with [ABC].
>>>
>>> Each version of ABC resides in it's own directory:
>>> C:\Program Files\ABC1\
>>> C:\Program Files\ABC2\
>>>
>>> The client connection process is limited to an installation application
>>> that asks for the following:
>>>
>>> Server:
>>> Username:
>>> Password:
>>> Database:
>>>
>>> How can I get both of these versions to connect to their respective
>>> MySQL installation.
>>>
>>> Thank you in advanced!
>>>
>>> -L
>>>
>