MariaDB upgrade from 5.5 to 10.1

Please do the following steps

mysqldump -u root -ppassword –all-databases > all_db_backup.sql

systemctl stop mysql
cp -a /var/lib/mysql/ /var/lib/mysql.bak
yum –skip-broken update

Please put the below text in this file

vim /etc/yum.repos.d/MariaDB10.repo

#+++++++++++++++++++++++++++++++++++++++++++++++
# MariaDB 10.1 CentOS repository list
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
#+++++++++++++++++++++++++++++++++++++++++++++++

yum remove mariadb-server mariadb mariadb-libs
yum clean all
yum -y install MariaDB-server MariaDB-client
systemctl start mariadb

systemctl enable mariadb
mysql_upgrade
mysql -V

 

MariaDB upgrade from 5.5 to 10.1