centos升级MySQL数据库5.6.39
MySQL数据库升级3.6.39准备工作：
1.新建目录（把升级文件放在此目录中）
# mkdir /mysqlbak
#
2.上传升级的数据库版本：
.https://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.39-1.el7.x86_64.rpm-bundle.tar
3.解压
# tar vxf MySQL-5.6.39-1.el7.x86_64.rpm-bundle.tar
MySQL-shared-compat-5.6.39-1.el7.x86_64.rpm
MySQL-client-5.6.39-1.el7.x86_64.rpm
MySQL-devel-5.6.39-1.el7.x86_64.rpm
MySQL-server-5.6.39-1.el7.x86_64.rpm
MySQL-shared-5.6.39-1.el7.x86_64.rpm
MySQL-test-5.6.39-1.el7.x86_64.rpm
MySQL-embedded-5.6.39-1.el7.x86_64.rpm
备份数据库
注：升级数据库理论是不影响数据的，安全起见备份数据库
# mysqldump -uroot -P 3306 -p -A > /mysqlbak/dabatases.sql
Enter password:
You have new mail in /var/spool/mail/root
#
停止数据库
# service crond stop
Redirecting to /bin/systemctl stopcrond.service
You have new mail in /var/spool/mail/root
# service mysql stop
Shutting down MySQL..................... SUCCESS!
# netstat -lntup | grep 3306
#
删除旧版本MySQL包文件
# yum remove MySQL-share MySQL-client MySQL-devel MySQL-server MySQL-shared
安装新的MySQL包文件
# rpm -ivh MySQL-client-5.6.39-1.el7.x86_64.rpm
warning: MySQL-client-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-client-5.6.39-1.el7 #################################
# rpm -ivh MySQL-devel-5.6.39-1.el7.x86_64.rpm
warning: MySQL-devel-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-devel-5.6.39-1.el7 #################################
# rpm -ivh MySQL-embedded-5.6.39-1.el7.x86_64.rpm
warning: MySQL-embedded-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-embedded-5.6.39-1.el7 #################################
# rpm -ivh MySQL-shared-5.6.39-1.el7.x86_64.rpm
warning: MySQL-shared-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-shared-5.6.39-1.el7 #################################
# rpm -ivh MySQL-shared-compat-5.6.39-1.el7.x86_64.rpm
warning: MySQL-shared-compat-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-shared-compat-5.6.39-1.el7 #################################
# rpm -ivh MySQL-test-5.6.39-1.el7.x86_64.rpm
warning: MySQL-test-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-test-5.6.39-1.el7 #################################
# rpm -ivh MySQL-server-5.6.39-1.el7.x86_64.rpm
warning: MySQL-server-5.6.39-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key> Preparing... #################################
Updating / installing...
1:MySQL-server-5.6.39-1.el7 #################################
登陆升级后MySQL
# /etc/init.d/mysql start
Starting MySQL....... SUCCESS!
# mysql -uroot -pBjqdsc402
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection> Server version: 5.6.39 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases; +--------------------+
Database +--------------------+
mysqlperformance_schematest +--------------------+
7 rows in set (0.05 sec)
mysql>select version();
+-----------+
| version() |
+-----------+
| 5.6.39 |
+-----------+
1 row in set (0.08 sec)
mysql>
页:
[1]