MARIABD MySQL Upgrade mariadb

[Email protected]/]# mysqldump--all-databases--user=root--password--master-data > Backupdatabase.sql #备份原数据库
Enter Password:
Mysqldump:Error:Binlogging on server not active #提示启动过日志
[[email protected]/]# VI/ETC/MY.CNF # [mysqld] Add log-bin = mysql-bin start log function

[[Email protected]/]# service mysqld Stop # CENTOS6 chkconfig mysqld off Centos7 [[email protected] ~]# Systemctl Disable Mysqld.service Delete boot boot

Step three: Uninstall MySQL:

1	[[email protected] ~]# yum remove mysql* mysql-server mysql-devel mysql-libs

The above command will back up your current MySQL profile/etc/my.cnf file to/etc/my.cnf.rpmsave.

Fourth step: Install the Remi repository to resolve MySQL compatibility issues

You may get a dependency error in installing MARIADB. So let's add the Remi repository to solve the dependency problem. Thanks to the Askmonty Knowledgebase to help me solve the dependency problem.

1	[[email protected] ~]# rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

This step suggests an error

[[email protected] ~]# RPM-IVH remi-release-6.rpm Warning: remi-release-6.rpm: Head V3 dsa/sha1 Signatu Re, key ID 00f97f56:nokey
Error: Dependency detection failed:
epel-release >= 6 is needed by Remi-release-6.5-1.el6.remi.noarch

[Email protected] ~]# wget ftp://ftp.pbone.net/mirror/dl.iuscommunity.org/pub/ius/archive/Redhat/6/i386/ epel-release-6-5.noarch.rpm # Download Epel-release

[Email protected] ~]# RPM-IVH epel-release-6-5.noarch.rpm

[Email protected] ~]# RPM-IVH remi-release-6.rpm # Fix

Now install the COMPAT-MYSQL55 package:

1	[[email protected] ~]# yum --enablerepo=remi-test --disablerepo=remi install compat-mysql55

Fifth Step: Install MARIADB:

Create a library file for mariadb, and add the following lines:

For 32-bit systems:

12345678

[[email protected] ~] #  vi /etc/yum.repos.d/mariadb.repo  # mariadb 5.5  centos repository list - created   #  http://mariadb.org/mariadb/repositories/  [mariadb]  Code class= "Bash Plain" >name = mariadb  baseurl = http: //yum .mariadb.org /5 .5 /centos6-x86  gpgkey=https: //yum .mariadb.org /rpm-gpg-key-mariadb  gpgcheck=1

For system 64:

1234567

[[email protected] ~] # VI /ETC/YUM.REPOS.D/MARIADB.REPO  # MARIADB 5.5 CENTOS REPOSITORY LIST  # HTTP://MARIADB.ORG/MARIADB/REPOSITORIES/  [ MARIADB] name = mariadb  baseurl  = http: //yum .mariadb.org Code class= "Bash plain" >/5 .5 /centos6-amd64  gpgkey=https: //yum .mariadb.org /rpm-gpg-key-mariadb  gpgcheck=1

Save and exit Run

1	#yum update

Download Start installation mariadb:

1	[[email protected] ~]# yum install MariaDB-devel MariaDB-client MariaDB-server -y

The installation process prompts for conflicts, yum remove Mysql-community-common after uninstallation and then the above installation succeeds.

Sixth step: Start the MARIADB service

123	[[email protected] ~]# service mysql start Starting MySQL...... SUCCESS! [[email protected] ~]# chkconfig mysql on

MARIABD MySQL Upgrade mariadb