有趣的事

恢复PERCONA XTRABACKUP XBSTREAM的备份

解包得用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

相关阅读