恢复PERCONA XTRABACKUP XBSTREAM的备份
2016-02-17 阅读 94
### 解包得用xbstream -x:
```
xbstream -x < /root/backup/backup.xbstream
```
### 根据是否进行了压缩,需要进行解压缩,可以看到有.qp结尾的文件.需要使用qpress来进行解压.先安装
CentOS/Redhat:
```
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
yum install qpress
```
Debian/Ubuntu:
```
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
echo 'deb http://repo.percona.com/apt VERSION main' >> /etc/apt/sources.list
echo 'deb-src http://repo.percona.com/apt VERSION main' >> /etc/apt/sources.list
apt-get update
apt-get install qpress
```
*Replace VERSION with your Debian/Ubuntu release name
### 解压
```
for i in $(find -name "*.qp"); do qpress -vd $i $(dirname ${i}) && rm -f $i; done
```
### 预处理
```
innobackupex --apply-log --use-memory=4G ./
```
### 停止服务
```
service mysql stop
```
### 复制
```
rm -rf /var/lib/mysql/*
innobackupex --copy-back ./
```
### 修改权限
```
chown -R mysql:mysql /var/lib/mysql
```
### 启动服务
```
service mysql start
```
更新于 2023年03月28日