Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: Kostas (---.dip0.t-ipconnect.de)
Date: February 19, 2019 11:44PM

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

Options: ReplyQuote
Re: Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: Otomatic (Moderator)
Date: February 20, 2019 08:54AM

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.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.3.16
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.3.16
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
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 »

Options: ReplyQuote
Re: Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: RiggsFolly (Moderator)
Date: February 20, 2019 09:26AM

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.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

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 MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: Kostas (---.dip0.t-ipconnect.de)
Date: February 20, 2019 01:26PM

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?

Options: ReplyQuote
Re: Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: Otomatic (Moderator)
Date: February 20, 2019 04:09PM

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

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.3.16
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.3.16
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
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 »

Options: ReplyQuote
Re: Moved DBs from MariaDB to Wampserver.MariaDB
Posted by: Kostas (---.dip0.t-ipconnect.de)
Date: February 20, 2019 04:39PM

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.