备份
innobackupex --defaults-file=/data//mysqldata/3306/my.cnf --user=root --password=root /data/mysqldata/backup/full
zy版:innobackupex --defaults-file=/mysql/3306/my.cnf --user=root --password=123456 /mysql/3306backup/full
innobackupex --defaults-file=/data//mysqldata/3306/my.cnf --user=root --password=root /data/mysqldata/backup/ --incremental --incremental-basedir=/data/mysqldata/backup/full/2014-05-29_16-11-55/
zy版:
/etc/init.d/mysqld stopinnobackupex --defaults-file=/mysql/3306/my.cnf --user=root --password=123456 /mysql/3306backup/increment/ --incremental --incremental-basedir=/mysql/3306backup/full/2014-12-17_08-55-02/
还原
mv /data/mysqldata/3306 /data/mysqldata/3306bak
mkdir /data/mysqldata/3306
cd /data/mysqldata/3306
mkdir tmp binlog data innodb_log innodb_ts
apply-log阶段
innobackupex --defaults-file=/data/mysqldata/3306bak/my.cnf --apply-log --redo-only /data/mysqldata/backup/full/2014-05-29_16-11-55/ --user=root --password=root
zy版:innobackupex --defaults-file=/mysql/old3306/my.cnf --user=root --password=123456 --apply-log --redo-only /mysql/3306backup/full/2014-12-17_08-55-02/
innobackupex --defaults-file=/data/mysqldata/3306bak/my.cnf --apply-log --redo-only /data/mysqldata/backup/full/2014-05-29_16-11-55/ --incremental-dir=/data/mysqldata/backup/inc/2014-05-29_16-14-36/ --user=root --password=root
zy版:innobackupex --defaults-file=/mysql/old3306/my.cnf --user=root --password=123456 --apply-log --redo-only /mysql/3306backup/full/2014-12-17_08-55-02/ --incremental-dir=/mysql/3306backup/increment/2014-12-17_08-58-53/
copy-back阶段
innobackupex --defaults-file=/data/mysqldata/3306bak/my.cnf --copy-back /data/mysqldata/backup/full/2014-05-29_16-11-55/ --incremental-dir=/data/mysqldata/backup/inc/2014-05-29_16-14-36/ --user=root --password=root
cp /data/mysqldata/3306bak/my.cnf /data/mysqldata/3306/
chown mysql.mysql /data/mysqldata/3306 -R
kill -9 mysql
mkdir /mysql/3306/relay_log
chown mysql.mysql /mysql -R
/etc/init.d/mysqld start
mysql>reset slave ;
mysql>change master to master_host='dbMaster', master_user='repl', master_password='p4ssword', master_log_file='mysql-bin.000025', master_log_pos=0;
mysql>slave start;