mysql升级

来源：互联网发布：arduino 单片机编辑：程序博客网时间：2024/05/20 06:25

演示以及5.5升级到5.6
当前数据库信息

mysql> status;--------------mysql  Ver 14.14 Distrib 5.5.46, for Linux (x86_64) using readline 5.1Connection id:          2Current database:Current user:           root@localhostSSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.5.46-log Source distributionProtocol version:       10Connection:             Localhost via UNIX socketServer characterset:    utf8Db     characterset:    utf8Client characterset:    utf8Conn.  characterset:    utf8UNIX socket:            /data/mysql/mysql.sockUptime:                 37 min 18 secmysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || db1                || log                || mysql              || performance_schema || test               || tpcc               |+--------------------+7 rows in set (0.01 sec)

1下载mysql5.6安装包并配置mysql5.6安装包安装路径

5.6安装包[root@miles mysql5.6.27]# pwd/usr/local/mysql5.6.27[root@miles mysql5.6.27]# lltotal 172drwxr-xr-x.  2 root root    4096 Dec  1 19:20 bin-rw-r--r--.  1 7161 wheel  17987 Sep 18 22:24 COPYINGdrwxr-xr-x.  3 root root    4096 Dec  1 19:20 datadrwxr-xr-x.  2 root root    4096 Dec  1 19:20 docsdrwxr-xr-x.  3 root root    4096 Dec  1 19:20 include-rw-r--r--.  1 7161 wheel 105656 Sep 18 22:24 INSTALL-BINARYdrwxr-xr-x.  3 root root    4096 Dec  1 19:20 libdrwxr-xr-x.  4 root root    4096 Dec  1 19:20 mandrwxr-xr-x. 10 root root    4096 Dec  1 19:21 mysql-test-rw-r--r--.  1 7161 wheel   2496 Sep 18 22:24 READMEdrwxr-xr-x.  2 root root    4096 Dec  1 19:20 scriptsdrwxr-xr-x. 28 root root    4096 Dec  1 19:20 sharedrwxr-xr-x.  4 root root    4096 Dec  1 19:20 sql-benchdrwxr-xr-x.  2 root root    4096 Dec  1 19:20 support-files

2关闭mysql5.5的实例，修改部分参数,使用mysql5.6软件启动

[root@miles mysql5.6.27]# ps -ef | grep mysqlroot       1474      1  0 19:04 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/miles.pidmysql      1891   1474  0 19:04 ?        00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/log/error.log --pid-file=/data/mysql/miles.pid --socket=/data/mysql/mysql.sock[root@miles mysql5.6.27]# mysqladmin -uroot -p --socket=/data/mysql/mysql.sock shutdown修改参数文件[root@miles mysql5.6.27]# vi /etc/my.cnf 把文件中指向5.5的位置指向5.6的修改环境变量[root@miles mysql5.6.27]# vi /etc/profileexport MYSQL_HOME=/usr/local/mysql5.6.27export PATH=$MYSQL_HOME/bin:$PATHexport C_INCLUDE_PATH=$MYSQL_HOME/includeexport LIBDIR=/usr/local/libexport LD_LIBRARY_PATH=/usr/local/lib:$MYSQL_HOME/libexport LD_RUN_PATH=/usr/local/lib[root@miles mysql5.6.27]# source /etc/profile使用5.6启动[root@miles mysql5.6.27]# /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/etc/my.cnf  &[root@miles mysql5.6.27]# ps -ef |grep mysqlroot       3607   3093  0 20:17 pts/1    00:00:00 /bin/sh /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/etc/my.cnfmysql      3889   3607 28 20:17 pts/1    00:00:02 /usr/local/mysql5.6.27/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql5.6.27 --datadir=/data/mysql --plugin-dir=/usr/local/mysql5.6.27/lib/plugin --user=mysql --log-error=/data/mysql/log/error.log --pid-file=/data/mysql/mysqld.pid --socket=/data/mysql/mysql.sock[root@miles mysql5.6.27]# mysql -uroot -p --socket=/data/mysql/mysql.sockmysql> status;--------------mysql  Ver 14.14 Distrib 5.6.27, for linux-glibc2.5 (x86_64) using  EditLine wrapperConnection id:          1Current database:Current user:           root@localhostSSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.6.27-log MySQL Community Server (GPL)Protocol version:       10Connection:             Localhost via UNIX socketServer characterset:    latin1Db     characterset:    latin1Client characterset:    utf8Conn.  characterset:    utf8UNIX socket:            /data/mysql/mysql.sockUptime:                 1 min 34 sec

3执行mysql5.6路径下mysql_upgrade脚本

指令的说明[root@miles mysql5.6.27]# /usr/local/mysql5.6.27/bin/mysql_upgrade --help-s, --upgrade-system-tables                       Only upgrade the system tables do not try to upgrade the                      data.如果数据库数据量较大，不加-s的话升级时间可能较长[root@miles mysql5.6.27]# /usr/local/mysql5.6.27/bin/mysql_upgrade -uroot -p --socket=/data/mysql/mysql.sock -s

4验证是否成功升级

[root@miles mysql5.6.27]# mysql -uroot -p --socket=/data/mysql/mysql.sockmysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || db1                || log                || mysql              || performance_schema || test               || tpcc               |+--------------------+7 rows in set (0.00 sec)mysql> status;--------------mysql  Ver 14.14 Distrib 5.6.27, for linux-glibc2.5 (x86_64) using  EditLine wrapperConnection id:          7Current database:Current user:           root@localhostSSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.6.27-log MySQL Community Server (GPL)Protocol version:       10Connection:             Localhost via UNIX socketServer characterset:    latin1Db     characterset:    latin1Client characterset:    utf8Conn.  characterset:    utf8UNIX socket:            /data/mysql/mysql.sockUptime:                 10 min 47 sec

0 0