Restore from Backup?
Posted by: LeMarque (---.cybermesa.com)
Date: October 23, 2019 06:09AM

Fessing up here. I had intermittent problems with WAMP and php/MySQL. So I uninstalled it and re-installed 3.19 without backing up any of my WordPress databases.

So my original install was c:\wamp - which I deleted. My new install is to f:\wamp. I just have to ask, if I restore from backup my c:\wamp, will it run also having an install on my f/wamp drive?

I know, I know ... but I just had to ask.

Options: ReplyQuote
Re: Restore from Backup?
Posted by: Otomatic (Moderator)
Date: October 23, 2019 09:26AM

Hi,

It can't work in a simple way.
You will need to remove the services from the first installation before launching the new one and recreating the services. And vice versa.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.11/7.2.23/7.1.32/7.0.33/5.6.40 - MySQL 5.7.28 - MariaDB 10.4.9
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.11/7.2.23/7.1.32/7.0.33/5.6.40 - MySQL 5.7.28/8.0.18 - MariaDB 10.4.9
PhPMyadmin 4.9.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Restore from Backup?
Posted by: LeMarque (---.cybermesa.com)
Date: October 23, 2019 04:46PM

Thanks Oto -

When you say "remove the services" - even tho they show as "Stopped"? You're saying that I'd have to completely delete the service?

Options: ReplyQuote
Re: Restore from Backup?
Posted by: Otomatic (Moderator)
Date: October 23, 2019 05:34PM

Hi,

When you leave Wampserver, the services are stopped but still exist.

They must be deleted before launching the other instance of Wampserver, this can be done in a command window, launched as administrator, by the commands :
sc delete wampapache
sc delete wampmysqld
sc delete wampmariadb
Or wampapache64 and so on.

Then, the new services can be installed, via Wampserver and :
- Left-click -> Apache -> Service administration -> Install the service
Same for MySQL and mariaDB

Then Left-Click -> Start all services

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.11/7.2.23/7.1.32/7.0.33/5.6.40 - MySQL 5.7.28 - MariaDB 10.4.9
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.11/7.2.23/7.1.32/7.0.33/5.6.40 - MySQL 5.7.28/8.0.18 - MariaDB 10.4.9
PhPMyadmin 4.9.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Restore from Backup?
Posted by: RiggsFolly (Moderator)
Date: October 23, 2019 05:36PM

Step 1 To Uninstall the current services (just deactivate really)


wampmanager -> Apache ->Service Administration -> Remove service
wampmanager -> MySQL ->Service Administration -> Remove service
wampmanager -> mariaDB ->Service Administration -> Remove service

Exit WAMPServer
Now basically you have uninstalled the new version of WAMPServer (without actually removeing anything from disk


Step 2 Restore old WAMP and install its services


Now restore the old \wamp\ folder onto C where it lived before (important to replace it on the same drive)

Find and execute `C:\wamp\wampmanager.exe`

Using the menus

wampmanager -> Apache ->Service Administration -> Install service
wampmanager -> MySQL->Service Administration -> Install service
if you are not using mariaDB dont bother with this next line
wampmanager -> mariaDB->Service Administration -> Install service

The database should now be visible just as before you removed this C drive version
Export the database you want to keep.



Step3 Once you have got a backup remove the C drive version and activate the F drive version again
wampmanager -> Apache ->Service Administration -> remove service
wampmanager -> MySQL->Service Administration -> remove service

Exit WAMPServer

Using the wampmanager.exe from the F drive version

wampmanager -> Apache ->Service Administration -> Install service
wampmanager -> MySQL->Service Administration -> Install service

Now run the restore into your new versions database.


You can leave the C Drive version there for a little while if you like or at this point when you know the database has been recovered you can just remove the `C:\wamp` folder (DONT do an uninstall as that will uninstall the F Drive version)

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.9 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

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 MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Restore from Backup?
Posted by: LeMarque (---.cybermesa.com)
Date: October 23, 2019 07:48PM

You folks are on my Christmas list.

Thanks

Options: ReplyQuote


Sorry, only registered users may post in this forum.