centos7升级Mariadb10.2

备份数据库

mysqldump  -uroot  -p  --database database_name >name.sql

卸载旧版本mariaadb

yum remove mariadb  

删除配置文件：

添加国内10.2版本yum源

vi  /etc/yum.repos.d/Mariadb.repo

rm -f /etc/my.cnf

删除数据目录：

rm -rf /var/lib/mysql/

[mariadb]
name = MariaDB
baseurl = https://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64
gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

yum clean all

yum makecache all

yum install MariaDB-server MariaDB-client -y

systemctl start mariadb.service
systemctl enable mariadb.service

/usr/bin/mysql_secure_installation

Enter current password for root (enter for none): Just press the Enter button
Set root password? [Y/n]: Y
New password: your-MariaDB-root-password
Re-enter new password: your-MariaDB-root-password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: n
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y

方法一：

登陆mysql后用source命令:(后面跟的是我们备份的sql文件的路径)

source /root/backup/java_api.sql

方法二：
在命令行直接导入

mysql -uroot -p >/root/backup/java_api.sql