WampServer

Hello everybody,

before installing Wampserver 3.1.7 I had MariaDB 10.1 installed.
I uninstalled MariaDB without backing up the databases.
After that I installed Wampserver.
Then i copied all databases from c:\MariaDB10.1\data into C:\wamp64\bin\mariadb\mariadb10.3.12\data.
In MyPHPAdmin I see the databases but I can not open them.

How should I proceed?

regards
Kostas

Hi,

I'm very afraid your databases are lost. The only way to transfer databases between different versions of MariaDB or MySQL is to export/import them as SQL files.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

You could try

1. Putting the databases somewhere safe
2. Reinstalling the old version of mariadb.
3. copying the saved databases to the new install
4. Doing an export of the databases you want to keep
5. uninstall the old version again
6. Start WAMPServer
7. Reinstall the mariadb service from the wamp manus
8. import that backups

But there are no guarantee's that this would work, and it assumes you have all the files involved in all the databases currently and know what you are doing.

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

Thanks for your help.

When uninstalling Mariadb-10.1.22 I was asked to delete the database. I said no.
For a new installation, Setup wants to have an empty folder, that is, no databases.
So I installed, stopped the service and replaced the Data folder with the old one.
Now the service can not be started anymore.
MariaDB re-installed, service stopped, and ONLY my databases copied into it. The service can now be started.
About HeidiSQL I try to open my database and get the message for each table: "Table 'xyTable' doensn't exist in engine" All tables are displayed inside the database.

Does somebody has any idea?

Hi,

Because you have backed up only the folders of your databases and not the complete data folder with all its subfolders and files.
However, in the data folder, there are the databases specific to mariaDB: for example mysql, and it is in these databases specific to mariaDB that the informations related to your databases are stored.

It would also be necessary to have backed up some files in the data folder, such as \data\ib_logfile0, \data\ib_logfile1\data\ibdata1

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Sorry that is a misunderstanding.

I uninstalled MariaDB 10.1 WITHOUT the \ Data folder.

The folder Data of MariaDB 10.1 is still unchanged!


09.02.2019 16:18 16.384 aria_log.00000001
09.02.2019 16:18 52 aria_log_control
09.02.2019 16:19 79.691.776 ibdata1
09.02.2019 16:19 52.428.800 ib_logfile0
09.02.2019 16:19 52.428.800 ib_logfile1
02.09.2017 20:54 <DIR> jsgridsample
20.04.2017 13:41 0 multi-master.info
09.02.2019 16:36 139 my.ini
20.04.2017 13:41 <DIR> mysql
20.04.2017 13:41 <DIR> performance_schema
09.02.2019 16:28 49.069 php.err
09.02.2019 16:19 5 php.pid
25.10.2017 20:23 <DIR> rwk <<<<<<<<< my database 1
30.04.2018 19:14 <DIR> rwkmelder <<<<<<<<< my database 2
20.04.2017 16:18 <DIR> webrpg
17.05.2018 20:21 107.340 Win10x64PC.err