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.

Options: ReplyQuote
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 "..."

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.10/7.0.24/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.10/7.0.24/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

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 »



Edited 1 time(s). Last edit at 03/14/2017 10:26AM by Otomatic.

Options: ReplyQuote


Sorry, only registered users may post in this forum.