Connecting to nonwamp MySQL version
Posted by: springwater (---.ph.ph.cox.net)
Date: May 03, 2016 09:20AM

Several months ago I installed MySQL (version 5.6.29) from the Oracle website.

A few days agao I installed Wampserver, which includes MySQL version 5.6.1.7. The wampserver install went fine. See details below.

However, all my data is in the version I installed from the Oracle web site.

Can I get Wampserver to use/point to the non-wamp version? How?

Thanks in advance for the help!


* Windows version used -Windows 7 64 bit
* Version WampServer - 2.5 64 bit
* Apache Version - 2.4.9
* PHP Version - 5.5.1.2
* MySQL Version - 5.6.1.7 (Wampserver version)
* What color is the WampServer icon - Green when wampmysqld64 service is started. Yellow/orange when MySQL (version 5.6.29 service is started)
* Do you have access to localhost (Homepage WampServer)? - yes
* Do you have access to phpMyAdmin? - yes

Options: ReplyQuote
Re: Connecting to nonwamp MySQL version
Posted by: RiggsFolly (Moderator)
Date: May 03, 2016 11:38AM

Hi,

Well if you start the other MYSQL first you will see (like you say) that the WAMPServer MySQL Server does not start. Thats because they both try to use TPC PORT 3306.

So if wampservers MySQL has not started you will in fact be using the other MYSQL Server.


This will get a bit fiddly though.

My suggestion would be to
- backup your database(s) on the other MySQL
- Stop the other MySQL
- Start WAMPServers MYSQL
- Restore the databases to WAMPServers MYSQL

Once you are sure you have all you need from the old MYSQL I would then uninstall the other MySQL

Now all your databases are in one place and under one MYSQL.

---------------------------------------------------------------------------------------------
(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-

Options: ReplyQuote
Re: Connecting to nonwamp MySQL version
Posted by: springwater (---.ph.ph.cox.net)
Date: May 03, 2016 07:59PM

Thanks for the quick reply. I'll give it a try and report back.

Options: ReplyQuote


Sorry, only registered users may post in this forum.