MySQL 5.6.19升級到 5.7.9 的步驟是什么

144次閱讀

共計 3448 個字符，預計需要花費 9 分鐘才能閱讀完成。

MySQL 5.6.19 升級到 5.7.9 的步驟是什么，很多新手對此不是很清楚，為了幫助大家解決這個難題，下面丸趣 TV 小編將為大家詳細講解，有這方面需求的人可以來學習下，希望你能有所收獲。

升級前版本檢查 + 測試表創建

[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]#

看完上述內容是否對您有幫助呢？如果還想對相關知識有進一步的了解或閱讀更多相關文章，請關注丸趣 TV 行業資訊頻道，感謝您對丸趣 TV 的支持。

正文完