How to migrate MySQL database to MariaDB in CentOS6

The VPS operating system is CentOS 6, and the mysql version is 5.5.31 (the REMI source is used ).

A. Configure the installation source of MariaDB first.

Currently, the main version of MariaDB is MariaDB 5.5.33a Stable. Save the following installation source configuration as MariaDB. repo and upload it to the/etc/yum. repos. d folder on the server:

For CentOS 6 32 bit:

[Mariadb] name = MariaDB enable = 1 priority = 3 baseurl = http://yum.mariadb.org/5.5.33a/centos6-x86/ gpgkey = https://yum.mariadb.org/rpm-GPG-KEY-MariaDB gpgcheck = 1
For CentOS 6 64 bit:

[Mariadb] name = MariaDB enable = 1 priority = 3 baseurl = http://yum.mariadb.org/5.5.33a/centos6-amd64/ gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck = 1

B. Execute the system upgrade directly.

Yum update -- skip-broken

MariaDB-related installation packages will be installed, and unwanted MySQL packages will be uninstalled. You do not need to repair the system after the upgrade.