备份数据库
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