MySQL 5.6.19升级到 5.7.9 的步骤是什么

MySQL 5.6.19升级到 5.7.9 的步骤是什么,很多新手对此不是很清楚,为了帮助大家解决这个难题,下面小编将为大家详细讲解,有这方面需求的人可以来学习下,希望你能有所收获。

升级前版本检查+测试表创建

[root@localhost ~]# mysql -uroot -p123456 –socket=/var/lib/mysql/mysql3307.sock –port=3307 -e"create database lottery; use lottery;create table lottery.mhq as select 'test';select  version();"
+———–+
| version() |
+———–+
| 5.6.19-log |
+———–+
[root@localhost ~]# 

软件包:
wget http://downloads.mysql.com/archives/get/file/mysql-community-client-5.7.9-1.el6.x86_64.rpm 

wget http://downloads.mysql.com/archives/get/file/mysql-community-server-5.7.9-1.el6.x86_64.rpm 

wget http://downloads.mysql.com/archives/get/file/mysql-community-common-5.7.9-1.el6.x86_64.rpm 
wget http://downloads.mysql.com/archives/get/file/mysql-community-libs-5.7.9-1.el6.x86_64.rpm 

yum安装命令:

yum install numactl*

yum localinstall –skip-broken  mysql-community*

升级后验证版本和表数据

[root@localhost ~]# mysql -uroot -p123456 –socket=/var/lib/mysql/mysql3307.sock –port=3307 -EN -e" select version(); select * from lottery.mhq;"

*************************** 1. row ***************************
5.7.9-log
*************************** 1. row ***************************
test 
[root@localhost ~]#

注释:

基本查询db表没问题,不过一些mysqldump用到设计到系统表时需要mysql_upgrade做下系统表升级;

升级前使用mysqldump 

[root@localhost mysql]#  mysqldump -uroot -p123456 -B retail_pms > /root/retail_pms.sql
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid/_mode'': Native table 'performance_schema'.'session_variables' has the wrong structure (1682)
[root@localhost mysql]#  


升级系统表

[root@localhost mysql]# mysql_upgrade -u root -p123456 –socket=/var/lib/mysql/mysql3307.sock –port=3307 –force
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv            OK
mysql.db                   OK
mysql.engine_cost             OK
mysql.event                 OK
mysql.func                 OK
mysql.general_log             OK
mysql.gtid_executed           OK
mysql.help_category           OK
mysql.help_keyword            OK
mysql.help_relation           OK
mysql.help_topic             OK
mysql.innodb_index_stats        OK
mysql.innodb_table_stats        OK
mysql.ndb_binlog_index         OK
mysql.plugin                OK
mysql.proc                 OK
mysql.procs_priv             OK
mysql.proxies_priv            OK
mysql.server_cost            OK
mysql.servers               OK
mysql.slave_master_info         OK
mysql.slave_relay_log_info       OK
mysql.slave_worker_info         OK
mysql.slow_log               OK
mysql.tables_priv             OK
mysql.time_zone              OK
mysql.time_zone_leap_second      OK
mysql.time_zone_name           OK
mysql.time_zone_transition       OK
mysql.time_zone_transition_type   OK
mysql.user                 OK
Upgrading the sys schema.
Checking databases.
lottery.mhq                 OK
sys.sys_config               OK
Upgrade process completed successfully.
Checking if update is needed. 

[root@localhost mysql]# 

简单查询系统表是否存在:

[root@localhost mysql]# find / -name session_variables*
/var/lib/mysql/performance_schema/session_variables.frm
/data/wonhigh/mysql3307/performance_schema/session_variables.frm 

[root@localhost mysql]#

重启DB 

[root@localhost ~]# date;mysqldump -uroot -pW@h2Gh#2ol5 -A –single-transaction -q -R –set-gtid-purged=OFF  > /data/all.sql;date
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo/_version'': Native table 'performance_schema'.'session_variables' has the wrong structure (1682)  —->这种需要重启DB才能解决哦~
[root@localhost ~]#  

[root@localhost mysql]# /etc/init.d/mysqld restart
停止 mysqld:          [确定]

正在启动 mysqld:        [确定] 

[root@localhost mysql]#

再尝试mysqldump是否成功

[root@localhost mysql]#  mysqldump -uroot -p123456 retail_pms  BRAND COLOR_INFO SHOP_BRAND ITEM  > /root/retail_pms.sql

[root@localhost mysql]#

看完上述内容是否对您有帮助呢?如果还想对相关知识有进一步的了解或阅读更多相关文章,请关注亿速云行业资讯频道,感谢您对亿速云的支持。

原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/201799.html

(0)
上一篇 2021年11月25日
下一篇 2021年11月25日

相关推荐

发表回复

登录后才能评论