1、Full backuop,一定要先做:
innobackupex –defaults-file=/etc/my.cnf –user=root –password=evlink /home/mysql/backup/
2、Incremental backup,可以每隔一小时或者三小时做一次:
innobackupex –defaults-file=/etc/my.cnf –user=root –password=evlink –incremental /home/mysql/backup/incre –incremental-basedir=/home/mysql/backup
注意:第二次再做一次增量备份–incremental一定要指定一个新的目录。 –incremental-basedir=不变
还原,注意my.cnf指定的datadir一定是空的,否则还原失败:
Prepare restore:
innobackupex –defaults-file=/etc/my.cnf –apply-log –redo-only –use-memory=4G /home/backup/2016-05-10_16-06-24/
innobackupex –defaults-file=/etc/my.cnf –apply-log –redo-only –use-memory=4G /home/backup/2016-05-10_16-06-24/ –incremental-dir=/home/backup/incre/2016-05-10_16-15-55/
innobackupex –defaults-file=/etc/my.cnf –apply-log – –use-memory=4G /home/backup/2016-05-10_16-06-24/
Copy back:
innobackupex –defaults-file=/etc/my.cnf –copy-back –use-memory=4G /home/backup/2016-05-10_16-06-24/