用Xtrabackup备份MySQL

安装方法：

wget http://www.percona.com/mysql/xtrabackup/xtrabackup-0.8.tar.gz
tar zxf xtrabackup-0.8.tar.gz
cd xtrabackup-0.8
./configure
make
make install

使用命令：

sudo ./innobackupex-1.5.1 –user=root –stream=tar backup/ –slave-info –databases=broad | gzip > backup/broad.gz

备注：

innobackupex: You must use -i (–ignore-zeros) option for extraction of the tar stream.