Friday, December 06, 2024
Wampserver - jumping between different configurations
If you have an old wampserver installation, which might include a MySQL5 database, then it may not be a simple process to upgrade to a newer version, eg including MySQL9.
Having failed to export to SQL from the old databases before upgrading, I had real problems importing old "data" folders (to include both the database folders and the crucial files ib_logfile0, ib_logfile1 and ibdata1).
I ended up with multiple versions of C:\wamp64 on my system - I renamed each one as I prepared to install a different version.
But you can't just run the link to wampserver64 and use the current C:\wamp64 installation. Wampmanager is too clever.
One comment said of wampmanager.ini "It is rebuilt on each restart from information from various places but mainly the wampmanager.tpl file." I believe the "various places" bit, but my wampserver.tpl was unchanged for months despite much mucking around in recent days so I don't think that is the answer.
It seems that Wampmanager does its own checks and decides which versions of the services it is expecting, and if you have modified file names and reinstalled, it will be confused.
The answer is to remove and then reinstall all services except PHP.
What follows is an updated version of the approach suggested here.
Having installed a different version of wampserver into C:\wamp64 do this:
Start Wampserver
Don't worry that the tray icon is red. (If it isn't, Stop All Services) Left-Click on the W icon.
REMOVE THE SERVICES
Choose Apache, then "Service wampapache64", and choose "Remove Service"
Choose MySQL, then "Service wampsqld64", and choose "Remove Service"
Choose MariaDB, then "Service wampmariadb64", and choose "Remove Service"
NOTE - you seem to need to do this for MariaDB even if you aren't using it.
ADD BACK THE SERVICES
Choose Apache, then "Service wampapache64", and choose "Install Service" - wait a few seconds (watch for a confirm message needing your OK)
Choose MySQL, then "Service wampsqld64", and choose "Install Service" - wait a few seconds
Choose MariaDB, then "Service wampmariadb64", choose "Install Service" - wait a few seconds
RESTART
Now restart all services. If that doesn't work, exit and start Wampmanager64 again.