yum安装mysql-5.6(centos7)

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

centos 7.3 安装mysql 5.6

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

yum repolist enabled | grep "mysql.*-community.*" （查看当前可用的mysql安装资源）

yum -y install mysql-community-server

systemctl start mysqld

安装阿里云的备份文件恢复工具：

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

yum install percona-xtrabackup

其他操作：

调整本地的磁盘：/ 分区110g的大小

systemctl stop mysqld

下载阿里云的全北实例：

tar  fx xxx.tar.gz

mv /var/lib/mysql/* /opt

cp -rp ./* /var/lib/mysql/

innobackupex --defaults-file=/var/lib/mysql/backup-my.cnf --apply-log /var/lib//mysql

......

InnoDB: Starting shutdown...

InnoDB: Shutdown completed; log sequence number 1552626957387

190320 17:26:02 completed OK!    --------->代表恢复成功

chown -R mysql. /var/lib/mysql

systemctl start  mysql

此时就可以利用登录账号登录了。