Win32 dev on two versions of mysql

Hi,

I read the recent thread (Sept) on installing two instances of mysqld
and binding them to two different IP addresses, but unfortunately I have
to develop on two different versions of MySQL and they both need to work
on 127.0.0.1 (localhost)--though not at the same time, of course.
What's an easy way to accomplish this, so that I can (quickly, if
possible) switch between say, 4.1 and 5.0.23 or whatever and have them
both on localhost? I realize that I can remove the instance of the
service on each, in turn, using the MySQL Server Instance Config Wizard,
but I'm hoping there's a quicker and easier way to do this than that.

Can anyone help out..? I'm sure this isn't too unusual a situation for
developers on Windows.

Thanks,
Brad

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Win32 dev on two versions of mysql

On 10/23/06, Brad wrote:
> Hi,
>
> I read the recent thread (Sept) on installing two instances of mysqld
> and binding them to two different IP addresses, but unfortunately I have
> to develop on two different versions of MySQL and they both need to work
> on 127.0.0.1 (localhost)--though not at the same time, of course.
> What's an easy way to accomplish this, so that I can (quickly, if
> possible) switch between say, 4.1 and 5.0.23 or whatever and have them
> both on localhost? I realize that I can remove the instance of the
> service on each, in turn, using the MySQL Server Instance Config Wizard,
> but I'm hoping there's a quicker and easier way to do this than that.
>
> Can anyone help out..? I'm sure this isn't too unusual a situation for
> developers on Windows.
>

Simply install manually both versions, giving different names for each
service, set the service to the "manual" state, so windows will not
turn it on automatically, then create simple batch files like that:

net stop mysql4
net start mysql5

and another

net stop mysql5
net start mysql4

Place a shortcut on your Desktop and you can quickly switch between versions...


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Win32 dev on two versions of mysql

As long, only ONE service is running at a time it's ok to use same port.

The database `mysql` are not 100% compatible between 4.0 and 5.0=20
So you should use seperate datadirs for each service.

my.cnf could contain:
-----------------------
[mysql4]
datdir =3D path/to/v4data

[mysql5]
datdir =3D path/to/v5data
-----------------------

For installing them use:
c:\path-to-4.0\bin\mysqld.exe --install-manual mysql4
c:\path-to-5.0\bin\mysqld.exe --install-manual mysql5



/jesper

-----Original Message-----
From: Jorge Bastos [mailto:mysql.jorge@decimal.pt]
Sent: 24. oktober 2006 21:16
To: win32@lists.mysql.com
Subject: Fw: Win32 dev on two versions of mysql


And don't forget to run them in diferent ports also.




----- Original Message -----=20
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Tuesday, October 24, 2006 7:05 PM
Subject: Re: Win32 dev on two versions of mysql


> On 10/23/06, Brad wrote:
>> Hi,
>>
>> I read the recent thread (Sept) on installing two instances of mysqld
>> and binding them to two different IP addresses, but unfortunately I =
have
>> to develop on two different versions of MySQL and they both need to =
work
>> on 127.0.0.1 (localhost)--though not at the same time, of course.
>> What's an easy way to accomplish this, so that I can (quickly, if
>> possible) switch between say, 4.1 and 5.0.23 or whatever and have =
them
>> both on localhost? I realize that I can remove the instance of the
>> service on each, in turn, using the MySQL Server Instance Config =
Wizard,
>> but I'm hoping there's a quicker and easier way to do this than that.
>>
>> Can anyone help out..? I'm sure this isn't too unusual a situation =
for
>> developers on Windows.
>>
>
> Simply install manually both versions, giving different names for each
> service, set the service to the "manual" state, so windows will not
> turn it on automatically, then create simple batch files like that:
>
> net stop mysql4
> net start mysql5
>
> and another
>
> net stop mysql5
> net start mysql4
>
> Place a shortcut on your Desktop and you can quickly switch between=20
> versions...
>
>
> --=20
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org