WampServer
Apache, PHP, MySQL
on Windows
Reinstalled Windows, then Wampserver, phpMyAdmin won't detect databases
Posted by:
SRD
(---.lns4.way.bigpond.net.au)
Date: March 14, 2017 08:36AM
My Windows 10 broke, so I had to reinstall Windows removing all applications.
I reinstalled Wampserver, and edited my.cnf to change to:
datadir=D:/Dropbox/WAMP/SQL/data
When I open [localhost], phpMyAdmin does not detect my databases, which I can see in File Explorer.
Help appreciated.
I reinstalled Wampserver, and edited my.cnf to change to:
datadir=D:/Dropbox/WAMP/SQL/data
When I open [localhost], phpMyAdmin does not detect my databases, which I can see in File Explorer.
Help appreciated.
Re: Reinstalled Windows, then Wampserver, phpMyAdmin won't detect databases
Posted by:
Otomatic
(Moderator)
Date: March 14, 2017 09:55AM
Hi,
The transfer of databases between different versions of MySQL or MariaDB should be performed by EXPORT / IMPORT of SQL files using phpMyAdmin or a similiar tools of your choice.
Do not copy the data folder between different versions of MYSQL. Databases from different versions of MYSQL are VERY unlikely to be compatible! You will also destroy the version of MYSQL that you copied the data folder to.
> and edited my.cnf to change to:
There is no my.cnf file with Wampserver.
The correct file is my.ini :
Left-Click Wampmanager tray icon -> MySQL -> my.ini
And the contents of datadir must be enclosed in quotation marks "..."
---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
Edited 1 time(s). Last edit at 03/14/2017 10:26AM by Otomatic.
The transfer of databases between different versions of MySQL or MariaDB should be performed by EXPORT / IMPORT of SQL files using phpMyAdmin or a similiar tools of your choice.
Do not copy the data folder between different versions of MYSQL. Databases from different versions of MYSQL are VERY unlikely to be compatible! You will also destroy the version of MYSQL that you copied the data folder to.
> and edited my.cnf to change to:
There is no my.cnf file with Wampserver.
The correct file is my.ini :
Left-Click Wampmanager tray icon -> MySQL -> my.ini
And the contents of datadir must be enclosed in quotation marks "..."
---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
Edited 1 time(s). Last edit at 03/14/2017 10:26AM by Otomatic.
Sorry, only registered users may post in this forum.
