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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby userapache123 » 08. May 2021 22:35

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]
userapache123
 
Posts: 14
Joined: 06. May 2021 06:01
XAMPP version: xampp-windows-x64-7.4.16-0-VC1
Operating System: Windows

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

Postby Altrea » 08. May 2021 22:44

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?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

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

Postby Nobbie » 09. May 2021 12:17

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
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 137 guests