Migrate/Upgrade to MariaDB from MySQL on Ubuntu 14.04 LTS

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

Optional step for phpMyAdmin & PHP:

Before MariaDB

Before MariaDB

After MariaDB

After MariaDB

Success! 🙂


Write a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.