1、備份原數(shù)據(jù)庫

按數(shù)據(jù)庫名導(dǎo)出：mysqldump -uroot -p --database database_name >name.dump

導(dǎo)出所有數(shù)據(jù)庫：mysqldump -u root -p --all-databases > alldb.sql

如出錯，嘗試這個：mysqldump --single-transaction -u root -p --all-databases> alldb.sql

2、停止服務(wù)運行

systemctl stop mariadb && systemctl status mariadb

3、卸載mariadb

yum remove -y mariadb &&yum remove -y mariadb-*

4、查找安裝信息并刪除

yun list installed |grep mariadb?
rpm -qa |grep mariadb?
find / -name mysql?
find / -name mariadb?
刪除配置文件：rm -f /etc/my.cnf?
刪除數(shù)據(jù)目錄：rm -rf /var/lib/mysql

5、添加國內(nèi)yum源

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

添加以下內(nèi)容：

# MariaDB 11.0 CentOS repository list - created 2023-06-17 03:06 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# baseurl = https://rpm.mariadb.org/11.0/centos/$releasever/$basearch
baseurl = https://mirrors.neusoft.edu.cn/mariadb/yum/11.0/centos/$releasever/$basearch
module_hotfixes = 1
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://mirrors.neusoft.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1
?

官方y(tǒng)um源（國內(nèi)安裝較慢）
Download MariaDB Server - MariaDB.org

[mariadb] name = MariaDB

baseurl = http://yum.mariadb.org/10.2/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

6、清除yum源緩存數(shù)據(jù)，并生成新的yum源數(shù)據(jù)緩存

yum clean all && yum makecache all
查看下載緩存信息：ll /var/cache/yum/x86_64/7/mariadb

7、安裝mariadb

yum install MariaDB-server MariaDB-client -y

啟動并添加開機自啟：

systemctl start mariadb
systemctl enable mariadb

8、mariadb初始化

mysql_secure_installation

一般建議按以下進(jìn)行配置：

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

9、導(dǎo)入數(shù)據(jù)到新版本mariadb

方法一：

登陸mysql后用source命令:(后面跟的是我們備份的sql文件的路徑)

source /root/backup/java_api.sql

方法二：

在命令行直接導(dǎo)入

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

以上就是整個版本升級的過程了。文章來源地址http://www.zghlxwxcb.cn/news/detail-488563.html

到了這里，關(guān)于centos7升級mariadb的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！