Page 1 of 1

xampp-windows-x64-7.4.16-0-VC15 - Is it MySQL or MariaDB?

PostPosted: 08. May 2021 22:35
by userapache123
I am using xampp-windows-x64-7.4.16-0-VC15-installer. Does it come with MariaDB, or MySQL?

I get the following, but I am not sure what it means.

C:\Xampp\mysql\bin>mysql --version
mysql Ver 15.1 Distrib 10.4.18-MariaDB, for Win64 (AMD64), source revision 53123dfa3e365138591fd2f160c6057aca00a3e6

The shell shows mariaDB [(none)]>

Please tell me:
1. If it is using MariaDB or MySQL.
2. If it is indeed using MariaDB, how can I change it so that it will use MySQL instead of MariaDB?

3. I am trying to load an older MySQL database into this one and it is not working with command as:
mysql -u root -p mediawikidb < "C:\MySQL\Wikidbbackup-20210416"
The command prompt returns but the database is not getting loaded into mediawwikidb
I am wondering if it has to do with the default database of MariaDB, as the original SQL is from MySQL

[EDIT by Altrea: moved to the english section]

Re: xampp-windows-x64-7.4.16-0-VC15 - Is it MySQL or MariaDB

PostPosted: 08. May 2021 22:44
by Altrea
userapache123 wrote:1. If it is using MariaDB or MySQL.

MariaDB

userapache123 wrote:2. If it is indeed using MariaDB, how can I change it so that it will use MySQL instead of MariaDB?

XAMPP don't provide any instructions to change any of the single components, but there are step by step tutorials you can find with help of your favorite search engine.
But why do you want to switch? MariaDB is highly compatible with MySQL.

userapache123 wrote:3. I am trying to load an older MySQL database into this one and it is not working with command as:
mysql -u root -p mediawikidb < "C:\MySQL\Wikidbbackup-20210416"
The command prompt returns but the database is not getting loaded into mediawwikidb
I am wondering if it has to do with the default database of MariaDB, as the original SQL is from MySQL

Unlikely. Mediawiki dumps are working very well on MariaDB.
Is there a way that you can share this dump so that someone is able to do some tests?

Re: xampp-windows-x64-7.4.16-0-VC15 - Is it MySQL or MariaDB

PostPosted: 09. May 2021 12:17
by Nobbie
Altrea wrote:Is there a way that you can share this dump so that someone is able to do some tests?


Thats exactly what i asked for.... viewtopic.php?f=16&t=80792#p272924