Xtrabackup-1.5 binary 安装备份恢复成功！

xtrabackup-1.5 source安装失败，只好去试试用xtrabackup-1.5 binary 了，这个比较简单，我成功了！

 

1 下载
shell> wget http://www.percona.com/downloads/XtraBackup/XtraBackup-1.5/Linux/binary/i686/xtrabackup-1.5.tar.gz

2 解压缩
[root@localhost source]# tar zxvf xtrabackup-1.5.tar.gz
[root@localhost xtrabackup-1.5]# cd bin
[root@localhost bin]# pwd
[root@localhost bin]# export PATH=$PATH:/root/source/xtrabackup-1.5/bin

3 -- backup all databases
./innobackupex-1.5.1 --user=root --password=mysql /tmp/backup/ --defaults-file=/etc/my.cnf

3.1 -- backup gzip all databases
./innobackupex-1.5.1 --user=root --password=mysql /tmp/backup/ --stream=tar --defaults-file=/etc/my.cnf | gzip> /tmp/backup/mysqldb_back.tar

 

4 -- delete all data files
[root@ldap-mysql-svn-trac var]# rm -rf *

5 -- create ib_logfile file of 'ib_logfile0 ib_logfile1' on /tmp/backup/2011-01-20_14-58-47
[root@ldap-mysql-svn-trac var]# innobackupex-1.5.1 --apply-log /tmp/backup/2011-01-20_14-58-47   --defaults-file=/etc/my.cnf
 

6 -- copy all file to data directory, set the privileges to files.
shell> innobackupex-1.5.1 --copy-back /tmp/backup/2011-01-20_14-58-47  --defaults-file=/etc/my.cnf

7 -- restart mysql db
all is ok.