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: Couldnt execute SHOW VARIABLES LIKE gtid\_mode: Native tableperformance_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: Couldnt 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]#

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