MariaDB Rollback to an Older Version

Last modified: March 24, 2017
You are here:
Estimated reading time: < 1 min

1. Run the following commands to back up your existing MariaDB databases and data:
cp -a /var/lib/mysql /var/lib/mysql.mariadb-old
cp -a /etc/my.cnf /etc/my.cnf.mariadb-old

2. Run the following command:
cat /var/cpanel/rpm.versions.d/local.versions

3.Roll back MariaDB repo file located at /etc/yum.repos.d/
Verify the text has the MariaDB database version that you’d like.
The file should look something like the following.

# MariaDB 10.1 CentOS Repository List
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

3.Roll back MariaDB repo file located at /etc/yum.repos.d/
Verify the text has the MariaDB database version that you’d like.
The file should look something like the following.

# MariaDB 10.1 CentOS Repository List
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

4. yum downgrade MariaDB-*

Was this article helpful?
Dislike 0
Views: 53