MySQL 5.6.19升级到 5.7.9 的步骤是什么
发布时间：2021-12-19 18:18:08 所属栏目：MySql教程 来源：互联网
导读：MySQL 5.6.19升级到 5.7.9 的步骤是什么，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。 升级前版本检查+测试表创建 [root@localhost ~]# mysql -uroot -p123456 --socket
|
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]# 看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。 （编辑：威海站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
