发一下之前存的MySQL升级流程
1、数据库备份
创建备份目录
mkdir -p /data/data-for-upgrade
进入目录备份
cd /data/data-for-upgrade
mysqldump -u root -p --add-drop-table --routines --events --all-databases --force > data-for-upgrade.sql
Enter password:
备份my.cnf文件
cp /etc/my.cnf /data/data-for-upgrade
确认备份文件
2、下载mysql5.6.51文件
wget https://cdn.mysql.com/archives/mysql-5.6/MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar
解压
tar -xvf MySQL-5.6.49-1.el7.x86_64.rpm-bundle.tar
tar -xvf MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar
3、关闭数据库
为了正常完成所有full purge和merge insert buffer操作,
命令行中执行:
mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
关闭数据库:
systemctl stop mysql
4、检查卸载旧版本RPM安装包
检查之前的安装包
rpm -qa | grep -i mysql
将上面查询出来的mysql,依次执行卸载命令,注意可以只卸载5.6的
rpm -e --nodeps MySQL-devel-5.6.37-1.el7.x86_64
rpm -e --nodeps MySQL-client-5.6.37-1.el7.x86_64
rpm -e --nodeps MySQL-server-5.6.37-1.el7.x86_64
#!!! 注意这里只是卸载软件,数据库文件和配置文件/etc/my.cnf不要改动或者删除
5、执行安装新版本mysql_RPM
rpm -ivh MySQL-client-5.6.51-1.el7.x86_64.rpm
rpm -ivh MySQL-devel-5.6.51-1.el7.x86_64.rpm
rpm -ivh MySQL-embedded-5.6.51-1.el7.x86_64.rpm
rpm -ivh MySQL-server-5.6.51-1.el7.x86_64.rpm
rpm -ivh MySQL-shared-5.6.51-1.el7.x86_64.rpm
rpm -ivh MySQL-shared-compat-5.6.51-1.el7.x86_64.rpm
# rpm -ivh MySQL-test-5.6.51-1.el7.x86_64.rpm
6、检查/etc/my.cnf 是否是原来配置
编辑 /etc/my.cnf
在[mysqld]最后添加:
检查是否配置通用查询日志
general_log = 1
禁止mysql对本地文件存取
local-infile = 0
7、升级数据库
启动,启动之后先不要操作,要进行升级
systemctl restart mysql.service
升级,检查不兼容的表,更新grant表
mysql_upgrade -u root -p
升级之后重新关闭数据库
mysqladmin -u root -p shutdown
重新启动
systemctl restart mysql.service
添加自启动
/sbin/chkconfig mysql on
感谢这位童鞋
https://blog.csdn.net/jc_benben/article/details/105425182?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param