Skip to content

Instantly share code, notes, and snippets.

@tidalgo22
Created May 20, 2019 01:23
Show Gist options
  • Save tidalgo22/062f830561c54090507ec43b0d0c628f to your computer and use it in GitHub Desktop.
Save tidalgo22/062f830561c54090507ec43b0d0c628f to your computer and use it in GitHub Desktop.
I’m a fan of short articles/news!
Tested: Upgrading to MariaDB 10.2 for XAMPP v7.1.4
Download an installer of the latest stable version of MariaDB
Be sure all modules are stopped from the XAMPP Control Panel
Rename (xampp path)/mysql to something else (i.e. mysql-old)
Install the downloaded MariaDB to the (xampp path)/mysql
Copy the mysql-old/bin/my.ini file to mysql/bin directory
Copy all .ini and .bat files from mysql-old root to the mysql root
Copy the whole mysql-old/data/phpmyadmin directory to mysql/data
Copy the mysql-old/data/ibdata1 file to mysql/data
Run Apache and MySQL modules from the XAMPP Control Panel
If both modules started correctly, run a CMD as administrator, then enter mysql-upgrade -force -username=root -password command (If your username is different, change the root to your username, and change single dash character to double dash characters)
If above command successfully was done, restart your computer once, and start using new MariaDB ;)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment