WampServer

Dear developers,

Please help me.
I am loosing my mind.
I had several websites set up on localhost over the years in various stages of development.
I wanted to make sure one of the themes is up to date and started perfoming all the updates.
Yes I am stupid (it being late I thought I don't need a backup) - I don't have a backup.
The update broke the WAMP - icon never was going to green.

After sleepless night, and hours of trying to make it work I decided to upgrade WAMP and all the services too.
This was successful (even though the latest Version of PHP is not liked by lates version of phpMyAdmin) and I was able to start all services (2) just fine.

However, despite localhost page dispaying all my previous Projects, PHPMyAdmin shows no databases relating to them.
Is there anything at all on local machine that stores and is able to recover those databases for me?
All you replies will be very much appreciated.


Windows 10 Pro version 21H1 64-bit OS
Wapmserver - 3.2.6 64bit
phpMyAdmin - 5.2.0
MySQL - 8.0.29
PHP - 8.1.5
Icon is green
I have access to localhost
No error messages at the bottom of the screen - only in red under PhpMyAdmin 5.0.2 message 'Not compatible with PHP 8.1.5
Yes I have access to phpMyAdmin
Path C:\wamp64\wampmanager.exe

I read a lot of entries on this forum, but still have hope I could somehow restore those missing databases.

Please help.
Thank you in advance.

Hi,

Update doesn't delete your databases.

Your databases are in the "data" folder of the MySQL version used.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi

You said I decided to upgrade WAMP and all the services too.

Please tell us Exactly what you did, step by step if possible.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi Dominique,

Could you confirm that this folder is in the path:
wamp64>bin>mysql>mysql[version]>data ?

If yes, and I have updated the previous version to the newest one, does it mean that the previous data file has been replaced? Hence no way I can get my previous databases restored?

Also, what do you do with this data folder to restore databases in the phpMyAdmin??

Thank you in advance.

Kind regards

Hi,

When the WAMP icon wasn't turning green after attempting update of the Theme, I went to remove .maintenance file as previously this solved the issue after attempting an update some time ago.

Realising that some versions of services (like php, MySQL, Apache, phpMyAdmin) might be an issue and maybe even WAPM itself, I went to your page with latest upgrades and daownloaded exe files for all.

First I upgraded WAMP
Then all the rest of services.

I now found that I have at least three MySQP[version] data folders as I have done this before without any problem. Previously I did not have to do anything to copy data files to the new version. So have no idea how right now in the latest version I do not have those files. Maybe there was something I forgot. Sorry.

Do I just copy the data folder to the newest MySQL version folder? Or is there anything else I need to do to get all these databases back into the newest phpMyAdmin?


Your help is very much appreciated.

Kind regards

Hi,

> When the WAMP icon wasn't turning green after attempting update of the Theme,
> I went to remove .maintenance file

Wampserver doesn't have a "Theme" and doesn't have a .maintenance file. Your errors and problems do not come from Wampserver but from the application or CMS you have installed.

> I now found that I have at least three MySQP[version] data folders as I have done this before without any problem.

Your databases are in the data folder of the MySQL version you were using when you created these databases. If you have created a database with the name "mydatabase" there is necessarily a folder "mydatabase" in the data folder.
When you change MySQL version (Left-click -> MySQL -> Version) your databases remain in their original folder and are not magically transferred to the new version of MySQL.

The only permanent way to transfer databases between MySQL versions is by exporting/importing them as SQL files. This is clearly stated at the end of the installation of a new version of MySQL:

Transfer of databases from the previous version must be only performed by export / import in SQL files.
NEVER copy data directories or files between MySQL versions.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Dear Dominique,


Yes I know Theme and the .maintenance files have nothing to do with WAMP, but if by doing the update WAMP doesn't turn green, there must be some connection, doesn't it.

I went on to choose my previous working version of MySQL and was able to open the sites apart from one that is full off endless errors, Warnings repeating themselves over an over again.

After close inspection the Warning is the same on several pages!!??!!

It says:

(!) Warning: Undefined array key "jtma_section_element_link" in C:\wamp64\www\2022elem\wp-content\plugins\masteraddons\inc\modules\wrapper-link\.php on line 69

And them lots of detailed codes with Time Memory Function Location and endless codes.

Is there a way of getting rid of it?

Could this be caused by me deleting ib_logfile0 and ib_logfile1 from data folder when desperately trying to find solution to WAMP not turning green and followed someone elses such advice?

Or is it due to unsuccessful update of a plugin only?

Kind regards

Hi Again,

Now, this is very unsettling but after the updates I did one by one for all my plugins, when attempted ones more Theme (Blocksy) update, I got message:

Update failed: Connection lost or the server is busy. Please try again later.

And yet again the WAMP icon has turned orange and won't budge.

Why??

This is really disturbing right now.

Please help.

Kind regards

Hi,

You have a theme and/or a plugin or even several that are incompatible with the version of PHP that you use.

Before changing PHP version, did you check that your Wordpress, your themes, your plugins were compatible with this version?

Definitely, this is a WordPress problem and not a Wampserver problem. My help stops here. See with WordPress support and the creators of the theme and plugins.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Dear Dominique,

I can reassure you that when I had brief luck of getting back to my sites, I checked all fro compatibility with the software. Nothin was out of ordinary at all.

Right now when I go to check state of services, this is what I get:


The service 'wampapache64' is not RUNNING nor STOPPED.
[SC] EnumQueryServicesStatus:OpenService failure(s) 1060 :
The specified service does not exist as an installed service.
********* The service 'wampapache64' does not exist ********

So , how this can be due to Wordpress?? It isn't. Something, during the update/upgrade must be changing something, somewhere to get this kind of message

The rest of this message is:

The service 'wampmysqld64' is started
Service Session : LocalSystem

WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
is not started.

all services BINARY_PATH_NAME are OK

Is there anyone else to say what needs to be done?

Also, check for Apache config files shows:

Syntax check for Apache config files

'c:/wamp64/bin/apache/apache2.4.46/bin/httpd.exe' is not recognized as an internal or external command,
operable program or batch file.

This again is nothing to do with Wordpress or any plugins. I don't even see httpd.exe anywhere.

How come?

Please help.

Kind regards

Hi,

> c:/wamp64/bin/apache/apache2.4.46/bin/httpd.exe' is not recognized as an internal or external command
Problem of rights on the wamp64 folder and/or Wampserver not installed as administrator
It's easy to check if this file exists with the file explorer.

Wampmanager menus allow you to stop, delete, create and start services.
Left-click -> Apache -> Service Management

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Dear Dominique,

I have two laptops on which to check some files and on both I am administrator.

When I searched for httpd.exe on one that I still have wampserver 3.2.3, Apache 2.4.46 I have httpd application in the bin folder.

Unfortunately I don't have it on the other laptop where the problem is.

Becasue there is no httpd.exe, there is no way to remove the probelmatic service i.e. any Apache version I have installed. None of them have this file! How bizzare?!

Do I just copy this file over to the other laptop or is there a different way of removing installed Apache service?

I tried installation from command line and it didn't work.

Completely exhaused now.

Please when you are reponding, answer the questions I am asking, please.

Thank you in advance.

Kind regards

Hi anyone who is able to help.

PLEASE - IT DRIVES ME INSANE NOW - trying to get to the bottom of this problem.

If I don't have httpd.exe file in Apache bin folder
If because of it I am unable to unistall services and install them again?
Waht do I do?

Can the WAMP server be downgraded to the version that worked previously?

Just give me some hint of hope.

What can I do if I find myself in catch22 situation?
Apache error log has only this:

--- File cleaned up by Wampserver ---
--- on 2022-07-04 06:14

State of services now show this:

State of services:

The service 'wampapache64' is not RUNNING nor STOPPED.
[SC] EnumQueryServicesStatus:OpenService failure(s) 1060 :
The specified service does not exist as an installed service.
********* The service 'wampapache64' does not exist ********

The service 'wampmysqld64' is not RUNNING nor STOPPED.
[SC] EnumQueryServicesStatus:OpenService failure(s) 1060 :
The specified service does not exist as an installed service.
********* The service 'wampmysqld64' does not exist ********

WampServer (Apache, PHP and MySQL) will not function properly if any service
'wampapache64'
'wampmysqld64'
is not started.

all services BINARY_PATH_NAME are OK

When I try to remove a service it comes with this:

Could not execute run action: The system cannot find the file specified
Action : Run
Filename: c:/wamp64/bin/apache/apache2.4.46/bin/httpd.exe
Parameters: -n wampapache64 -k uninstall


Httpd.exe is nowhere to find.

PLEASE, PLEASE, PLEASE if you know what to do with this situation let me know.

Regards

Hi,

Wampserver can't delete a httpd.exe file !

When you use the "Right-Click -> Tools -> Delete unused versions", the whole version folder is deleted.

If you only have the Apache 2.4.46 version, you need to install an additional Apache addon, for example Apache 2.4.54

Once the addon is installed, you switch to this Apache version "Left-click -> Apache -> Version -> 2.4.54" and then you delete the 2.4.46 version "Right-click -> Tools -> Delete unused versions -> Apache -> Apache 2.4.46".

You can then, if you want, install the addon Apache 2.4.46

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Darling Dominique,

I have all three versions of Apache istalled , yet when I try to change between them this message comes up:


Could not execute run action: The system cannot find the file specified
Action : Run
Filename: c:/wamp64/bin/apache/apache2.4.53/bin/httpd.exe
Parameters: -n wampapache64 -k install


Anything I try I get constantly the same messages:


Could not execute run action: The system cannot find the file specified
Action : Run
Filename: c:/wamp64/bin/apache/apache2.4.46/bin/httpd.exe
Parameters: -n wampapache64 -k install

If I try to remove the service it gives me:


Could not execute run action: The system cannot find the file specified
Action : Run
Filename: c:/wamp64/bin/apache/apache2.4.53/bin/httpd.exe
Parameters: -n wampapache64 -k uninstall

or


Could not execute run action: The system cannot find the file specified
Action : Run
Filename: c:/wamp64/bin/apache/apache2.4.54/bin/httpd.exe
Parameters: -n wampapache64 -k install

I went to the folders of these APACHE services and none of them have httpd.exe file.

Surely without it it won't work.

SO THE QUESTION IS HOW DO I GET THIS httpd.exe file in place??
WIthout it nothing can be done it seems.

Is downgrading the WAMP version possible and/or needed?

What else can I do??
I cannot get into the phpMyAdmin as without bloody Apache running it wont open, so I can't export my databases.

If I delete entire WAMP I will loose all my several years worth of work.

I was able to start MySQL service so now the WAMP icon is orange but god forbit this Apache - I need this to get to work.

Please help
Regards

Hi,

> If I delete entire WAMP I will loose all my several years worth of work.
Les sauvegardes des sites et des bases de données existent et DOIVENT être effectuées souvent !!!
Si vous ne le faites jamais, le problème se situe entre la chaise et le clavier !!

Installez un autre addon d'une version Apache.

Vous avez un problème de virus et/ou de malware pour que tous les fichiers httpd.exe disparaissent et ça, en aucune manière, c'est un problème dû à Wampserver !

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Dear Dominique,

I really appreaciate you sense of humor.

If only I could understand french!!

Can you translate?

Thank you

No worries Dominique,

I transalated this now.

I don't think I have any malware.

Yes, I know I am the trouble for not backing up my databases.

No amount of pointing out will solve missing files problem.

Now I learned that I can not simply copy and past httpd.exe file.

But why can't I delete the Apache at all??

This is so very strange.

Regards

Hi Dominique,

I did delete the 'unused' Apache modules and swithced to the new installed.

Hallalujah!!

My Wamp icon is green
I can go to localhost
I can open phpMyAdmin
All my databases are there
I can see httpd.exe in the bin folder.

My GOD how absolutely vital is to delete Apache in this way.

For any other pundits who might be struggling with this it isn't removing the service what is required but deleting unused versions and istalling them again.

It finally clicked in place.

I better backup my databases now.

I would buy you a coffee - just let me know how.

Kind regards

I will just throw my hat into the arena once more. SOrry Oto if I am stepping on your toes!

If your httpd.exe files are "disappearing" then possibly you have an overly agressive FireWall or Virus checker. Have you recently made change to either of these type of services on this PC?


On the subject of gaining access to the databases you had under the original version of MySQL (or was it mariaDB ).... What you have to do is:

1. Change the version of MySQL currently running back to the version that the databases were created under.
. . Now this may require that you read up on how to do this using Windows and MySQL features as you seem to have completely naffed up your WAMPServer installation.

2. Do a backup! Once you have the right version of MySQL running.
. . As you appear to not be able to run apache you cannot run phpMyAdmin ... So, you will have to do this from the command line, using the `mysql.exe` or `mysqldump.exe`
These are found in the `wamp64\bin\mysql\mysql[version]\bin` folder
The documentation on how to use them can be found in the MySQL Documentation,
a link to that can be found in my Signature or there is one in the WAMPManager menu.
3. Once you are sure you have a usable backup of all YOUR databases, and by that I mean the ones you created and NOT the ones that MySQL creates for its own use you can put these backups somewhere VERY SAFE.

4. Now you can start the process of getting a working WAMPServer again.
My suggestion would be to uninstall WAMPServer, then and not before you can delete the whole
Wamp or wamp64 folder structure. So that Safe place for the backups is NOT inside the wamp folder structure.
Then make sure the wampapache and wampmysql and possibly wampmariadb services have been removed.


Once you have a new working WAMPServer, current versio, you can read up on how to restore a backed up database, again in the MySQL Documentation.



Please remember WAMPServer is provided so you and I can have a playground in which to learn and or improve our understanding of Apache/MySQL/mariaDB/PHP/etc
Once installed you become a SYSAdmin, DBAdmin, WebServer Admin, etc etc. That often means you have a steep learning curve, but one that you must at least try and climb at least a little way up.


And finally, when you get issue, the process to sort them out NEVER EVER starts with Oh I will scrap WAMPServer and reinstall. IDENTIFY what the issue is, clearly, before attempting to fix it. You can only make things worse if you blunder about with a big stick playing Whacka Mole with any software

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 2 time(s). Last edit at 07/04/2022 11:57AM by RiggsFolly.