Skip to content

Instantly share code, notes, and snippets.

@mtvbrianking
Last active August 25, 2018 16:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mtvbrianking/3a9ee106c457fb6e04e912591a1e7dfe to your computer and use it in GitHub Desktop.
Save mtvbrianking/3a9ee106c457fb6e04e912591a1e7dfe to your computer and use it in GitHub Desktop.
Update Maria DB - Xampp

Xampp upgrade MariaDB

Shutdown Xampp (Apache, and MySQl)

...$cd /c/xampp

Download desired version of MariaDB

/c/xampp$ wget http://ftp.hosteurope.de/mirror/archive.mariadb.org//mariadb-10.2.10/winx64-packages/mariadb-10.2.10-winx64.zip

Backup existing DB version

/c/xampp$ mv mysql mysql_old

Extra new verion to mysql dir

/c/xampp$ unzip mariadb-10.2.10-winx64.zip

/c/xampp$ rm mariadb-10.2.10-winx64.zip

/c/xampp$ mv mariadb-10.2.10-winx64 mysql

Retrieve old data

/c/xampp$ mv mysql/data/ mysql/data_old

/c/xampp$ cp mysql_old/data/ mysql

Retrieve old backups

/c/xampp$ cp mysql_old/backup/ mysql

Retrieve old scripts

/c/xampp$ cp mysql_old/scripts/ mysql

Reuse existing services

/c/xampp$ cp mysql_old/mysql_installservice.bat mysql

/c/xampp$ cp mysql_old/mysql_uninstallservice.bat mysql

Keep old configurations

/c/xampp$ cp mysql_old/bin/my.ini mysql/bin/

Update old settings

/c/xampp$ vim mysql/bin/my.ini

Make the following changes...

...
+ skip-grant-tables
- skip-federated
+ # skip-federated
- innodb_additional_mem_pool_size=2M
+ # innodb_additional_mem_pool_size=2M
...

Finally...

Start :: Apache

Run :: xampp/mysql/bin/mysql_upgrade.exe

Start :: MySQL

MariaDB

Source

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment