How to upgrade MariaDB within Xampp

I want to upgrade to MariaDB 10.2 and I'm using xampp ( I like that mysqld.exe runs in the background and easy On/Off with a single click ). What happens is that the latest version as of now is 3.2.2 and it has MariaDB 10.1.29 comes with it. I'm looking for a general healthy way to do it. I've tried those steps that pretty much look good :

  • Unzipping/installing the new MariaDB then copying the data directory and the config|bat files + phpMyAdmin from the old to the new installation. After starting for an instant, it shuts down complaining :
13:44:33  [main]  Control Panel Ready
13:52:46  [mysql]     Attempting to start MySQL app...
13:52:46  [mysql]     Status change detected: running
13:52:49  [mysql]     Status change detected: stopped
13:52:49  [mysql]     Error: MySQL shutdown unexpectedly.
13:52:49  [mysql]     This may be due to a blocked port, missing dependencies, 
13:52:49  [mysql]     improper privileges, a crash, or a shutdown by another method.
13:52:49  [mysql]     Press the Logs button to view error logs and check
13:52:49  [mysql]     the Windows Event Viewer for more clues
13:52:49  [mysql]     If you need more help, copy and post this
13:52:49  [mysql]     entire log window on the forums


  • I'm not gonna try some random deletes that are very likely to make my db tables corrupt (even though I did before and it didn't work)

  • Please take notice that if I run the server itself using an unprivileged user (not administrator) on the command line, it runs as expected. Furthermore, the status in the Xampp control panel would change to green :

14:00:35 [mysql] Status change detected: running

And I could even shut down the MySQL server from it, by clicking on stop.

  • If I run Xampp as administrator (which could be a bad idea), I get the same error message above.
  • Please note also that running MySQL server as an administrator involves security risks.
  • I know I can run it as a service, but I'd rather like to have instant control over when to turn it On/Off.

The purpose :

Looking for a clean way to upgrade MariaDB within xampp, on windows (Windows7)