DBA数据库-同主机版本升级

2019-08-05  本文已影响0人  学Linux的小子

1.备份

(略。)

2.安装8.0软件到新位置

[root@db01 /application]#mv mysql-8.0.16-linux-glibc2.12-x86_64  mysql8

3.停原库

[root@db01 /application]#systemctl stop mysqld

4.修改已有配置

共修改三处配置文件
mysql 改为mysql8

[root@db01 ~]#vim /etc/profile
export PATH=/application/mysql8/bin:$PATH
[root@db01 /application]#source /etc/profile
[root@db01 /application]#mysql -V
mysql  Ver 8.0.16 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

[root@db01 /application]#vim /etc/my.cnf 
[mysqld]
user=mysql
basedir=/application/mysql8
datadir=/data/3306/data
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock

[root@db01 /application]#vim /etc/systemd/system/mysqld.service 
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql8/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

  systemctl stop mysqld.service 
  systemctl start  mysqld

5.恢复5.7.26版本

上一篇 下一篇

猜你喜欢

热点阅读