WampServer

Hello

I just re-installed windows and therefore re-installed WampServer. I was using 2.4 before but now downloaded and installed the latest 2.5.

I am using Windows 7, Wampserver 2.5 which comes with Apache : 2.4.9 MySQL : 5.6.17 PHP : 5.5.12 PHPMyAdmin : 4.1.14

I install all software on my e: drive in e:\ProgramFilesx86 <- note no spaces and this has always worked well.

I also change the MySQL data directory to my user space as this then gets backed up better
datadir=e:/users/chris/data-2014

However, when I start WAMP I cannot see any of the databases in the datadir.

Connecting to MySQL on the command line and show datadir I get the following:-
mysql> show variables like 'datadir';
+---------------+-----------------------------------------------------+
| Variable_name | Value |
+---------------+-----------------------------------------------------+
| datadir | e:\ProgramFilesx86\wamp\bin\mysql\mysql5.6.17\data\ |
+---------------+-----------------------------------------------------+
1 row in set (0.00 sec)

However, if I search the wamp directory there is no mention anywhere of "e:\ProgramFilesx86\wamp\bin\mysql\mysql5.6.17\data\"

So it looks like it's using a default directory for some reason.

Thanks for any help!
Chris



Edited 1 time(s). Last edit at 12/22/2014 07:46PM by sudweb.

I guess what you forgot to mention is that you downloaded the 64bit WAMPserver.

If that is the case, then edit the my.ini file and chnage the section name from

[wampmysqld]

to

[wampmysqld64]

and the changes to your my.ini file will be picked up.

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

Yes, thank you! I did install the 64 bit version.

I tried changing as you suggested and MySQL wouldn't boot at all. Nothing in the log files.

So, I've installed the 32 bit version, changed the my.ini back and all works fine!

Thank you again
Chris