Migrate/Upgrade to MariaDB from MySQL on Ubuntu 14.04 LTS
- December 25, 2015
So… I just upgraded this blog to use MariaDB 10.1 instead of MySQL 5.6. I had some hiccups because by default, Ubuntu was trying to install MariaDB version 5, which apparently seems incompatible with my existing database.
Here’s what you need to do to upgrade/migrate to MariaDB 10.1 from MySQL on your AWS EC2 (shouldn’t really matter if it’s AWS) Ubuntu 14.04 LTS.
Warning: BACKUP your instance before you do this and pay close attention to the prompts – make sure you make the selection that ensures your existing database stays as is
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] http://mirrors.supportex.net/mariadb/repo/10.1/ubuntu trusty main'
sudo apt-get update
sudo apt-get install mariadb-server
Optional step for phpMyAdmin & PHP:
sudo apt-get install mariadb-client libmariadbclient-dev libmariadbd-dev phpmyadmin php5-mysql