1.tar 完整备份
systemctl stop mysqld 1先关闭mysql
mkdir /backup 2准备目录,放置备份数据
tar -cf /backup/`date +%F`-mysql-all.tar /var/lib/mysql 3备份数据
rm -rf /var/lib/mysql/* 4模拟数据库损坏
tar -xf /backup/2016-12-07-mysql-all.tar -C / 5导入备份数据
chown -R mysql.mysql 注意权限
systemctl start mysqld 启动MySQL 还原完成
2差异备份(percona-xtrabackup 物理备份 + binlog)
1 安装
wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm 下载yum源
yum -y install percona-release-0.1-3.noarch.rpm 安装yum源
yum -y install percona-xtrabackup-24.x86_64 &