WampServer

I was creating a website on localhost (WAMP 2.5 + Joomla 3.6) for several months and got that stupid idea to update WAMP from 2.5 to 3.0.6. I downloaded and ran the installation and read "Do not install Wampserver OVER an existing version". OK, so I canceled the installation, uninstalled the old WAMP and copied remaining folders under c:\wamp elsewhere as a backup. At this time, I already had a bad feeling that something might not work, so I better installed WAMP 2.5 in the same folder again. However, the attempt to access the web only generates this:

Error displaying the error page: Application Instantiation Error: Table 'joomla.#__session' doesn't exist SQL=SELECT `session_id` FROM `#__session` WHERE `session_id` = 'r4j9do38jv2jq2pi3s0nel5840' LIMIT 1

When I run phpMyAdmin, I see the joomla database at the left side, and after clicking at the + sign I see all joomla tables. However, when I click on any of the tables, I get a message like #1146 - Table 'joomla.hh1i3_users' doesn't exist.

Please, does anyone know how to get my website back to the previous state?

- Windows 8 64b
- WampServer 2.5 32b
- Apache, PHP and MySQL versions - out of the WAMP box
- WampServer icon is green



Edited 1 time(s). Last edit at 12/27/2016 05:01PM by microworks.

Hi,

There is an explanation here : Install a new release of Wampserver
You have to ask advice BEFORE you do stupid things.
And of course, you have no backup of your database as an SQL file.

The only possibility, without any certainty that it's work, is to replace the entire wamp/bin/mysql/mysql5.x.y/data/ folder of the current version of MySQL with the one you saved.

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

Does not work indeed

Hi,

Without saving the database by exporting to an SQL file, there is no other solution.

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

When I have the MySQL data\joomla folder with FRM, IBD and other files, cannot the database be reconstructed from it?

Hi,

> When I have the MySQL data\joomla folder with FRM, IBD and other files,
> cannot the database be reconstructed from it?
This is not enough.
One of the most important files for rebuilding databases is the 'wamp\bin\mysql\mysql5.7.14\data\ibdata1' file. That's why I suggested you replace the entire data folder.

You can see the MySQL documentation that explains how to try to retrieve a database, but without any guarantee of success.

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

In the end, I have found this explanation and recovery procedure:
[superuser.com]
I have reconstructed one table and it seems to work.