mysql-community-server-5.7.24 & 5.7.31 (5.6.35 升级到 5.7.24)

阶段1:
rpm -qa | grep mysql

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.24-1.el6.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.31-1.el6.x86_64.rpm-bundle.tar
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.31-1.el6.x86_64.rpm

yum repolist all | grep mysql

cat /etc/yum.repos.d/mysql-community.repo

Note: MySQL 5.7 is currently in development. For use at your own risk.

Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=【1】
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

vim /etc/yum.repos.d/mysql-community.repo

yum repolist all | grep mysql

yum install mysql-community-server-5.7.24-1.el6.x86_64.rpm

tar --help
/usr/software/mysql/5.7.24
tar -tvf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
tar -xf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar

yum 【upgrade】 【mysql-*】

阶段2:
Error:1146 - Table 'performance schema.session variables' doesn't exist
sudo su【否则可能无法生成升级报告文件】
mysql_upgrade -u root -p --force
service mysqld restart

mysql - Table 'performance_schema.session_variables' doesn't exist - Stack Overflow
https://stackoverflow.com/questions/36746677/table-performance-schema-session-variables-doesnt-exist

连接mysql报错Table ‘performance_schema.session_variables’-阿里云开发者社区
https://developer.aliyun.com/article/689012

rpm下载地址:
MySQL :: Download MySQL Community Server
https://dev.mysql.com/downloads/mysql/5.7.html

MySQL :: Download MySQL Community Server (Archived Versions)
https://downloads.mysql.com/archives/community/

官网文档:
mysql5.7安装升级 - 浩然&开心 - 博客园
https://www.cnblogs.com/dahaoran/p/12913031.html

MySQL升级 - iVictor - 博客园
https://www.cnblogs.com/ivictor/p/5776349.html

MySQL 5.6 升级到MySQL 5.7-云栖社区-阿里云
https://yq.aliyun.com/articles/543336

MySQL dump进行5.6迁移升级到5.7踩过的坑_布偶猫爸爸的博客-CSDN博客_5.6迁移到5.7有什么坑
https://blog.csdn.net/qq_21108311/article/details/89881183

MySQL 5.6升级至MySQL 5.7--------版本升级最佳实战 - MySQL数据库 - 亿速云
https://www.yisu.com/zixun/34154.html

参考文章:

mysql5.7安装升级 - 浩然&开心 - 博客园
https://www.cnblogs.com/dahaoran/p/12913031.html

MySQL升级 - iVictor - 博客园
https://www.cnblogs.com/ivictor/p/5776349.html

MySQL 5.6 升级到MySQL 5.7-云栖社区-阿里云
https://yq.aliyun.com/articles/543336

MySQL dump进行5.6迁移升级到5.7踩过的坑_布偶猫爸爸的博客-CSDN博客_5.6迁移到5.7有什么坑
https://blog.csdn.net/qq_21108311/article/details/89881183

MySQL 5.6升级至MySQL 5.7--------版本升级最佳实战 - MySQL数据库 - 亿速云
https://www.yisu.com/zixun/34154.html

posted @ 2020-07-22 17:14  任国强  阅读(605)  评论(0编辑  收藏  举报