WampServer

I have a setup of Wamp, running PHP5 and MySQL5,

However, I now have a client who uses MySQL 4.1.20, and some of the queries don't work.

I tried installing the older version of MySQL, starting the MySQL 4 service, and only starting the WAMP Apache, but the database just didn't respond.

Is there a way to use both versions (obviously, not at once) of MySQL?



Pete Clark

I have php5, php6, mysql5, mysql6 on my machine running w/o any problem. I've never tried mysql4, but I think it's the same concept and it should works

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

I am sorry, are you saying "it is possible", or "the instructions are here", because I checked the pages in your links, and couldn't see it.

I simply need to know how to set up MySQL so that I can switch between versions - at present, I can only see the version "originally" installed under Wamp.



Pete Clark

Ooops - I had something wrong in my test code!

Install two (or more) versions of MySQL, using different names for the services, and only 'start' the service that you want. It works!



Pete Clark

yes,
the services have to have different names, e.g.,

cd \mysql4\
bin\mysqld-nt --install mysql41 --defaults-file="%cd%\bin\my.cnf"
cd \mysql5\
bin\mysqld-nt --install mysql5045 --defaults-file="%cd%\bin\my.cnf"

you can even start several mysql versions simultaniously *if* configured to use different ports/sockets in ...\bin\my.cnf

Or you can edit config file to switch b/w them through wamp tray icon; it's more convenient

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

Which config file?



Pete Clark

I have a mysql 5 version already installed on my Vista system.

I cannot use wamp - the mysql service shows that it is not started, and wont start.

can you please help?

which config files do i need to monkey with??

thanks !!



Logical Design Database Solutions
www.logicaldesigndbs.com

wamp already come w/ mysql, so make sure there is no other mysql running on same port. If you do have other mysql, then shut down wamp, backup db from old mysql, uninstall and clean registry from old mysql, shut down and restart computer, restart wamp

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)




Post Edited (11-06-07 14:50)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I use XP, and have no knowledge of Vista - but perhaps this will help.

On my setup, the simplest thing to do would be edit
C:\wamp\launch_wampserver.bat
and remove or rem out the line
NET START wampmysqld

This would make Wamp start with just Apache, and for me, makes it easier to handle.

Then I have the other version of MySQL installed, so that I can switch it on or off manually, by Control Panel - Administrative Tools - Ser vices. In fact, I have a link on the bar which goes direct to Services.

My problem is that I need to use two different versions of MySQL.


But... if your WAMP won't start MySQL, is it because you already have your original version of MySQL running? You can only have one version running at once.

Or perhaps you have something else running that stops MySQL. I use Skype, and I have to remember to start Apache before I start Skype, or it just wont start.



Pete Clark