redhat6.5mysql升級5.5.48經(jīng)mysql5.6.32至mysql5.7.16實行概略

2024-07-24 12:32:34

字體：大中小

供稿：網(wǎng)友

redhat6.5mysql升級5.5.48經(jīng)mysql5.6.32至mysql5.7.16實施概略：

1,os version
redhat 6.5

2,舊版本mysql 5.5.48創(chuàng)建測試數(shù)據(jù)庫及測試表
mysql> create database zxy;
Query OK, 1 row affected (0.00 sec)

3，查詢舊版本MYSQL 5.5.48 DATA DIR及相關SOCKET文件及PID
mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)

mysql> show variables like 'socket';
+---------------+---------------------------+
| Variable_name | Value                     |
+---------------+---------------------------+
| socket        | /var/lib/mysql/mysql.sock |
+---------------+---------------------------+
1 row in set (0.00 sec)

4,舊版本MYSQL 5.5.48沒有使用配置文件my.cnf

[root@mysqlupgrade mysql_5548_dir]# ps -ef|grep -i mysql
root      6563 5378 0 16:52 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --user=root
root      6643 6563 0 16:52 pts/0    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=root
--log-error=/var/lib/mysql/mysqlupgrade.err --pid-file=/var/lib/mysql/mysqlupgrade.pid
root      6712 5378 0 17:02 pts/0    00:00:00 grep -i mysql

5, 移除舊版本mysql 5.5.48
[root@mysqlupgrade mysql_5548_dir]# rpm -qa|grep -i mysql
MySQL-devel-5.5.48-1.el6.x86_64
MySQL-server-5.5.48-1.el6.x86_64
MySQL-client-5.5.48-1.el6.x86_64
[root@mysqlupgrade mysql_5548_dir]#

（編輯：武林網(wǎng)）

上一篇：RDS MySQL 5.7三節(jié)點企業(yè)版重磅公布

下一篇：mysql學習之-show table status 獲取表的信息參數(shù)解說