redhat6.5mysql升级5.5.48经mysql5.6.32至mysql5.7.16实行概略

2024-07-24 12:32:34

字体：大中小

来源：转载

供稿：网友

redhat6.5mysql升级5.5.48经mysql5.6.32至mysql5.7.16实施概略：

1,os version
redhat 6.5

2,旧版本mysql 5.5.48创建测试数据库及测试表
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]#

（编辑：武林网）

上一篇：RDS MySQL 5.7三节点企业版重磅公布

下一篇：mysql学习之-show table status 获取表的信息参数解说