前言
mysql 5.7.40 升级到 5.7.42
下载升级包
解压
tar -zxvf mysql-5.7.40-linux-glibc2.12-x86_64.tar.gz
备份数据目录
cp -r mysql/data/ mysql_data_20230504
停止mysql服务
service mysql stop
备份mysql数据
./mysqldump -u用户 -p -h127.0.0.1 -P3306 --all-databases > /home/mysql_bak_20230504.sql
数据备份为了保证可靠性，建议多备份几次，备份前一定要停止MySQL服务
备份mysql服务目录
mv /usr/local/mysql /usr/local/mysql_20230504
将之前解压的升级包移动到mysql安装目录
mv /home/mysql-5.7.42-linux-glibc2.12-x86_64 /usr/local/mysql
# 修改目录权限
chown -R mysql:mysql /usr/local/mysql
复制原来log_bin目录到mysql安装目录
cp -r /usr/local/mysql_20230504/log-bin/ /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/log-bin/
我本地不执行这一步报错 The server quit without updating PID file (/data/mysql/mysql.pid).具体错误可以查看mysql.err
启动mysql服务
service mysql start
执行mysql升级
/usr/local/mysql/bin/mysql_upgrade -u root -p
