How to: MariaDB portable using XAMPP

Posted by in Databases, MariaDB

In the last posts of the blog I have talked about databases again, and we are working again with MySQL (what’s new in MySQL 8) and MariaDB. Some weeks ago I had the need to update part of my thesis, which implies (because of the availability) to have portable MySQL or MariaDB. So, I’ll tell you how I got it.

Back to 2014 I already published a post testing one of the first versions of the MariaDB 10 series database using the installer (in spanish). And it is still a valid method, no matter what version 10.x you download!

Before going on, I would like you to invite to contribute to maintain this blog.

In the first part, I encaurage you to work with XAMPP and MariaDB as a database, because it is a fork of MySQL with several years going on in their own way.

The XAMPP option

If you do not want to complicate your life and you need to save time, the most convenient way is to download the latest version of XAMPP, decompress the content in the unit you like, and access the xampp directory, and activate MySQL simply by running mysql_start.bat which is included in the directory.

Here you have where to download xampp:

Once unzipped, you access xampp directory and have different utilities to start everything:

As you can see, in the content you have avaliable several .bat files as quick links, or maybe, you prefer to start xampp-control where you have a complete pannel for controlling everything under xampp: you can start and stop several services, access to their configuration and more:

How you can check, XAMPP is a very useful and interesting tool, so having a portable MariaDB database server is very fast, accessible and has almost no complications.

I have proceeded to start the database server:

Let’s open HeidiSQL (by the way, this is the database admin software I like to use, but I never write an spacific blog post about it) adn let’s check what version we are running:

Versión del servidor MariaDB de Xampp

And that’s it. Everything s ready for working in a few steps and in a few minutes. I hope this little tutorial have been of your interest, and of course, you have more options if you need a portable database server.

Happy coding!