MySQL8.0.24 升级至8.3.0

1.1 确认版本信息

rpm -qa|grep mysql mysql -V

如图:
[root@vpswhw2-wonders-zy ~]# rpm -qa|grep mysql
mysql-community-common-8.0.24-1.el7.x86_64
mysql-community-client-8.0.24-1.el7.x86_64
mysql-community-server-8.0.24-1.el7.x86_64
mysql-community-client-plugins-8.0.24-1.el7.x86_64
mysql-community-libs-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy ~]# mysql -V
mysql  Ver 8.0.24 for Linux on x86_64 (MySQL Community Server - GPL)
[root@vpswhw2-wonders-zy ~]#

1.2 下载安装包

MySQL :: Download MySQL Community Server

MySQL :: Download MySQL Community Server

以升级8.0.24为例,下载mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar

1.3 解压安装包文件

tar -xvf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar

[root@vpswhw2-wonders-zy tools]# tar -xvf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
mysql-community-client-8.3.0-1.el7.x86_64.rpm
mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm
mysql-community-common-8.3.0-1.el7.x86_64.rpm
mysql-community-debuginfo-8.3.0-1.el7.x86_64.rpm
mysql-community-devel-8.3.0-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm
mysql-community-libs-8.3.0-1.el7.x86_64.rpm
mysql-community-libs-compat-8.3.0-1.el7.x86_64.rpm
mysql-community-server-8.3.0-1.el7.x86_64.rpm
mysql-community-server-debug-8.3.0-1.el7.x86_64.rpm
mysql-community-test-8.3.0-1.el7.x86_64.rpm
[root@vpswhw2-wonders-zy tools]# ll
▒▒▒▒▒ 2865412
-rw-r--r-- 1 root root  1069373440 2▒▒  19 14:20 mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
-rw-r--r-- 1 7155 31415   17008176 12▒▒ 15 18:03 mysql-community-client-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    3623692 12▒▒ 15 18:04 mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415     698240 12▒▒ 15 18:04 mysql-community-common-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  563964668 12▒▒ 15 18:04 mysql-community-debuginfo-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    2015760 12▒▒ 15 18:04 mysql-community-devel-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    4217684 12▒▒ 15 18:04 mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    2344976 12▒▒ 15 18:04 mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    1587092 12▒▒ 15 18:04 mysql-community-libs-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415     685936 12▒▒ 15 18:04 mysql-community-libs-compat-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   68000076 12▒▒ 15 18:05 mysql-community-server-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   26362656 12▒▒ 15 18:05 mysql-community-server-debug-8.3.0-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  378844364 12▒▒ 15 18:06 mysql-community-test-8.3.0-1.el7.x86_64.rpm

1.4 逻辑备份数据库

mysqldump -u root -h host -p --all-databases > /data/backdb.sql

1.5 停止数据库服务

service mysqld stop

systemctl stop mysqld

1.6 备份数据库配置文件及数据文件

a、/etc/my.cnf(默认位置) 配置文件

b、/var/lib/mysql(默认位置) 数据文件,具体位置见配置文件

1.7 升级安装

rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm --nodeps --force

[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm --nodeps --force
▒▒▒棺mysql-community-common-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY
׼▒▒▒▒...                             ################################# [100%]
▒▒▒▒▒▒/▒▒װ...
   1:mysql-community-common-8.3.0-1.el################################# [100%]
[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm --nodeps --force
▒▒▒棺mysql-community-libs-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY
׼▒▒▒▒...                             ################################# [100%]
▒▒▒▒▒▒/▒▒װ...
   1:mysql-community-libs-8.3.0-1.el7 ################################# [100%]
[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm --nodeps --force
▒▒▒棺mysql-community-client-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY
׼▒▒▒▒...                             ################################# [100%]
▒▒▒▒▒▒/▒▒װ...
   1:mysql-community-client-8.3.0-1.el################################# [100%]
[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm --nodeps --force
▒▒▒棺mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY
׼▒▒▒▒...                             ################################# [100%]
▒▒▒▒▒▒/▒▒װ...
   1:mysql-community-client-plugins-8.################################# [100%]
[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm --nodeps --force
▒▒▒棺mysql-community-server-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY
׼▒▒▒▒...                             ################################# [100%]
▒▒▒▒▒▒/▒▒װ...
   1:mysql-community-server-8.3.0-1.el################################# [100%]
[root@vpswhw2-wonders-zy mysql8.3]#

1.8 卸载原版本

rpm -qa | grep mysql

rpm -e mysql-community-server-8.0.24-1.el7.x86_64

rpm -e mysql-community-client-8.0.24-1.el7.x86_64

rpm -e mysql-community-libs-8.0.24-1.el7.x86_64

rpm -e mysql-community-common-8.0.24-1.el7.x86_64

rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64

[root@vpswhw2-wonders-zy mysql8.3]# rpm -qa | grep mysql
mysql-community-common-8.0.24-1.el7.x86_64
mysql-community-common-8.3.0-1.el7.x86_64
mysql-community-client-8.0.24-1.el7.x86_64
mysql-community-server-8.0.24-1.el7.x86_64
mysql-community-server-8.3.0-1.el7.x86_64
mysql-community-libs-8.3.0-1.el7.x86_64
mysql-community-client-plugins-8.0.24-1.el7.x86_64
mysql-community-libs-8.0.24-1.el7.x86_64
mysql-community-client-plugins-8.3.0-1.el7.x86_64
mysql-community-client-8.3.0-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-server-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64
▒▒▒▒▒▒▒▒▒▒ʧ▒ܣ▒
        mysql-community-client-plugins = 8.0.24-1.el7 ▒▒ (▒Ѱ▒?) mysql-community-libs-8.0.24-1.el7.x86_64 ▒▒Ҫ
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-libs-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-common-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -qa|grep mysql
mysql-community-common-8.3.0-1.el7.x86_64
mysql-community-server-8.3.0-1.el7.x86_64
mysql-community-libs-8.3.0-1.el7.x86_64
mysql-community-client-plugins-8.0.24-1.el7.x86_64
mysql-community-client-plugins-8.3.0-1.el7.x86_64
mysql-community-client-8.3.0-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -qa|grep mysql
mysql-community-common-8.3.0-1.el7.x86_64
mysql-community-server-8.3.0-1.el7.x86_64
mysql-community-libs-8.3.0-1.el7.x86_64
mysql-community-client-plugins-8.3.0-1.el7.x86_64
mysql-community-client-8.3.0-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]#

1.9 启动数据库

systemctl start mysqld

systemctl status mysqld

[root@vpswhw2-wonders-zy mysql8.3]# systemctl start mysqld
[root@vpswhw2-wonders-zy mysql8.3]# systemctl status mysqld
* mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since һ 2024-02-19 15:16:07 CST; 48s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 38367 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 38416 (mysqld)
   Status: "Server is operational"
    Tasks: 38
   Memory: 609.8M
   CGroup: /system.slice/mysqld.service
           `-38416 /usr/sbin/mysqld
​
2▒▒ 19 15:15:30 vpswhw2-wonders-zy systemd[1]: Starting MySQL Server...
2▒▒ 19 15:16:07 vpswhw2-wonders-zy systemd[1]: Started MySQL Server.
[root@vpswhw2-wonders-zy mysql8.3]#

2.0 确认新版本信息和数据完整性

[root@vpswhw2-wonders-zy mysql8.3]# mysql -V
mysql  Ver 8.3.0 for Linux on x86_64 (MySQL Community Server - GPL)
[root@vpswhw2-wonders-zy mysql8.3]#

至此,升级完成。

  • 25
    点赞
  • 24
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值