本篇内容主要讲解“MySQL利用xtrabackup进行增量备份的详细过程”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“MySQL利用xtrabackup进行增量备份的详细过程”吧!

1,创建mysql备份用户

mysql -uroot --password="" -e"CREATE USER 'backup'@'192.168.%' IDENTIFIED BY '123456'";

mysql -uroot --password="" -e"GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT, CREATE TABLESPACE, SUPERON *.* TO 'backup'@'192.168.%'";

2,xtrabackup进行全量备份

备份命令:

xtrabackup --defaults-file=/etc/my.cnf--user=backup --password="123456" --port=3306 --backup--target-dir=/data/backups/mysql/full_incre_$(date +%Y%m%d)

PS: 2>/tmp/fullbackup.log 将备份信息放入文件中。

备份过程信息如下:

[root@data01~]#xtrabackup--defaults-file=/etc/my.cnf--user=backup--password="123456"--port=3306--backup--target-dir=/data/backups/mysql/full_incre_$(date+%Y%m%d)xtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423920168)xtrabackup:Generatingalistoftablespaces[01]Copying./IBdata1to/data/backups/mysql/full_incre_20150319/IBdata1>>logscannedupto(423920168)>>logscannedupto(423920168)[01]...done[01]Copying./IBdata2to/data/backups/mysql/full_incre_20150319/IBdata2>>logscannedupto(423920168)>>logscannedupto(423920168)[01]...done[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/full_incre_20150319/mysql/slave_master_info.ibd[01]...done[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/full_incre_20150319/mysql/slave_relay_log_info.ibd[01]...done[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/full_incre_20150319/mysql/innodb_index_stats.ibd[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/full_incre_20150319/mysql/slave_worker_info.ibd[01]...done[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/full_incre_20150319/mysql/innodb_table_stats.ibd[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest1.ibd[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest5.ibd[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest8.ibd[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest4.ibd[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest2.ibd[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest6.ibd[01]...done[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest7.ibd[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/full_incre_20150319/sbtest/sbtest3.ibd[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/full_incre_20150319/test/t1.ibd[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/full_incre_20150319/test/t3.ibd[01]...done[01]Copying./test/t.ibdto/data/backups/mysql/full_incre_20150319/test/t.ibd[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/full_incre_20150319/user_db/t1.ibd[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/full_incre_20150319/user_db/test.ibd[01]...done[01]Copying./user_db/test2.ibdto/data/backups/mysql/full_incre_20150319/user_db/test2.ibd[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/full_incre_20150319/user_db/t3.ibd[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/full_incre_20150319/user_db/UC_USER.ibd>>logscannedupto(423920168)[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/full_incre_20150319/user_db/t.ibd[01]...donextrabackup:Thelatestcheckpoint(forincremental):'423920168'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423920168)xtrabackup:Transactionlogoflsn(423920168)to(423920168)wascopied.[root@data01~]#3,xtrabackup进行增量备份3.1先录入一张表,实现第一次增量数据:

mysql>createtablet4select'aaa'asa,1asb;QueryOK,1rowaffected(0.36sec)Records:1Duplicates:0Warnings:0mysql>mysql>insertintot4select'bbb',2;QueryOK,1rowaffected(0.05sec)Records:1Duplicates:0Warnings:0mysql>3.2 再进行增量备份1

xtrabackup --defaults-file=/etc/my.cnf--backup --user=backup --password="123456" --port=3306--target-dir=/data/backups/mysql/incre_20150320/--incremental-basedir=/data/backups/mysql/full_incre_201503192>/tmp/incre_backup_1.log

查看备份日志信息:

[root@data01~]#more/tmp/incre_backup_1.logxtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423920168isenabled.xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423925813)xtrabackup:Generatingalistoftablespacesxtrabackup:usingthefullscanforincrementalbackup[01]Copying./IBdata1to/data/backups/mysql/incre_20150320/IBdata1.delta>>logscannedupto(423925813)[01]...done[01]Copying./IBdata2to/data/backups/mysql/incre_20150320/IBdata2.delta>>logscannedupto(423925813)[01]...done>>logscannedupto(423925813)[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/incre_20150320/mysql/slave_master_info.ibd.delta[01]...done[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/incre_20150320/mysql/slave_relay_log_info.ibd.delta[01]...done[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/incre_20150320/mysql/innodb_index_stats.ibd.delta[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/incre_20150320/mysql/slave_worker_info.ibd.delta[01]...done[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/incre_20150320/mysql/innodb_table_stats.ibd.delta[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.delta[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.delta[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.delta[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.delta[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.delta[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.delta[01]...done[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.delta[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.delta[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/incre_20150320/test/t1.ibd.delta[01]...done[01]Copying./test/t4.ibdto/data/backups/mysql/incre_20150320/test/t4.ibd.delta[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/incre_20150320/test/t3.ibd.delta[01]...done[01]Copying./test/t.ibdto/data/backups/mysql/incre_20150320/test/t.ibd.delta[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/incre_20150320/user_db/t1.ibd.delta[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/incre_20150320/user_db/test.ibd.delta[01]...done>>logscannedupto(423925813)[01]Copying./user_db/test2.ibdto/data/backups/mysql/incre_20150320/user_db/test2.ibd.delta[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/incre_20150320/user_db/t3.ibd.delta[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.delta[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/incre_20150320/user_db/t.ibd.delta[01]...donextrabackup:Thelatestcheckpoint(forincremental):'423925813'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423925813)xtrabackup:Transactionlogoflsn(423925813)to(423925813)wascopied.3.3 再建立表2,实现第二天增量数据

建立一张表t_incre_2:

mysql>usetest;Databasechangedmysql>createtablet_incre_2select'cc'asa,2asb;QueryOK,1rowaffected(0.25sec)Records:1Duplicates:0Warnings:0mysql>insertintot_incre_2select'dd',2;QueryOK,1rowaffected(0.05sec)Records:1Duplicates:0Warnings:0mysql>select*fromt_incre_2;+----+---+|a|b|+----+---+|cc|2||dd|2|+----+---+2rowsinset(0.05sec)mysql>3.4 进行第二天的增量备份

备份命令:

xtrabackup --defaults-file=/etc/my.cnf--backup --user=backup --password="123456" --port=3306--target-dir=/data/backups/mysql/incre_20150321/--incremental-basedir=/data/backups/mysql/incre_20150320 2>/tmp/incre_backup_2.log

备份信息记录如下:

[root@data01~]#more/tmp/incre_backup_2.logxtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423925813isenabled.xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423931610)xtrabackup:Generatingalistoftablespacesxtrabackup:usingthefullscanforincrementalbackup[01]Copying./IBdata1to/data/backups/mysql/incre_20150321/IBdata1.delta>>logscannedupto(423931610)>>logscannedupto(423931610)>>logscannedupto(423931610)>>logscannedupto(423931610)>>logscannedupto(423931610)[01]...done>>logscannedupto(423931610)[01]Copying./IBdata2to/data/backups/mysql/incre_20150321/IBdata2.delta>>logscannedupto(423931610)>>logscannedupto(423931610)[01]...done[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/incre_20150321/mysql/slave_master_info.ibd.delta[01]...done[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.delta[01]...done>>logscannedupto(423931610)[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/incre_20150321/mysql/innodb_index_stats.ibd.delta[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/incre_20150321/mysql/slave_worker_info.ibd.delta[01]...done[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/incre_20150321/mysql/innodb_table_stats.ibd.delta[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.delta[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.delta[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.delta[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.delta[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.delta[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.delta[01]...done[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.delta[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.delta[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/incre_20150321/test/t1.ibd.delta[01]...done[01]Copying./test/t4.ibdto/data/backups/mysql/incre_20150321/test/t4.ibd.delta[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/incre_20150321/test/t3.ibd.delta[01]...done>>logscannedupto(423931610)[01]Copying./test/t.ibdto/data/backups/mysql/incre_20150321/test/t.ibd.delta[01]...done[01]Copying./test/t_incre_2.ibdto/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.delta[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/incre_20150321/user_db/t1.ibd.delta[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/incre_20150321/user_db/test.ibd.delta[01]...done[01]Copying./user_db/test2.ibdto/data/backups/mysql/incre_20150321/user_db/test2.ibd.delta[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/incre_20150321/user_db/t3.ibd.delta[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.delta[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/incre_20150321/user_db/t.ibd.delta[01]...done>>logscannedupto(423931610)xtrabackup:Thelatestcheckpoint(forincremental):'423931610'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423931610)xtrabackup:Transactionlogoflsn(423931610)to(423931610)wascopied.


4,xtrabackup进行增量恢复4.1为了验证比对,先删除两个增量备份前表里面的数据

mysql>deletefromt4;QueryOK,2rowsaffected(0.05sec)mysql>deletefromt_incre_2;QueryOK,2rowsaffected(0.04sec)mysql>select*fromt4;Emptyset(0.00sec)mysql>select*fromt_incre_2;Emptyset(0.00sec)mysql>4.2开始全备份恢复PREPARE THE BASE BACKUP

备份命令如下:

xtrabackup --defaults-file=/etc/my.cnf--prepare --user=backup --password="123456" --apply-log-only--target-dir=/data/backups/mysql/full_incre_20150319 2>/tmp/full_restore.log

备份信息记录如下:

[root@data01mysql]#xtrabackup--defaults-file=/etc/my.cnf--prepare--user=backup--password="123456"--apply-log-only--target-dir=/data/backups/mysql/full_incre_20150319xtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)xtrabackup:cdto/data/backups/mysql/full_incre_20150319xtrabackup:Thistargetseemstobealreadyprepared.xtrabackup:notice:xtrabackup_logfilewasalreadyusedto'--prepare'.xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864xtrabackup:StartingInnoDBinstanceforrecovery.xtrabackup:Using104857600bytesforbufferpool(setby--use-memoryparameter)InnoDB:UsingatomicstorefcountbufferpoolpagesInnoDB:TheInnoDBmemoryheapisdisabledInnoDB:Mutexesandrw_locksuseGCCatomicbuiltinsInnoDB:MemorybarrierisnotusedInnoDB:Compressedtablesusezlib1.2.3InnoDB:UsingCPUcrc32instructionsInnoDB:Initializingbufferpool,size=100.0MInnoDB:CompletedinitializationofbufferpoolInnoDB:Settinglogfile./ib_logfile101sizeto64MBInnoDB:Settinglogfile./ib_logfile1sizeto64MBInnoDB:Settinglogfile./ib_logfile2sizeto64MBInnoDB:Renaminglogfile./ib_logfile101to./ib_logfile0InnoDB:Newlogfilescreated,LSN=423920168InnoDB:HighestsupportedfileformatisBarracuda.[notice(again)]Ifyouusebinaryloganddon'tuseanyhackofgroupcommit,thebinarylogpositionseemstobe:InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053xtrabackup:startingshutdownwithinnodb_fast_shutdown=1InnoDB:Startingshutdown...InnoDB:Shutdowncompleted;logsequencenumber423920652[root@data01mysql]#


4.3 恢复到第一次增量的时刻

恢复命令:

xtrabackup --defaults-file=/etc/my.cnf--prepare --user=backup --password="123456" --apply-log-only--target-dir=/data/backups/mysql/full_incre_20150319--incremental-dir=/data/backups/mysql/incre_20150320 2>/tmp/restore_incre_1.log

恢复过程:

[root@data01mysql]#more/tmp/restore_incre_1.logxtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423920168isenabled.xtrabackup:cdto/data/backups/mysql/full_incre_20150319xtrabackup:Thistargetseemstobealreadyprepared.xtrabackup:xtrabackup_logfiledetected:size=2097152,start_lsn=(423925813)xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=/data/backups/mysql/incre_20150320xtrabackup:innodb_log_files_in_group=1xtrabackup:innodb_log_file_size=2097152xtrabackup:Generatingalistoftablespacesxtrabackup:pagesizefor/data/backups/mysql/incre_20150320/IBdata2.deltais16384bytesApplying/data/backups/mysql/incre_20150320/IBdata2.deltato./IBdata2...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/IBdata1.deltais16384bytesApplying/data/backups/mysql/incre_20150320/IBdata1.deltato./IBdata1...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/mysql/slave_worker_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/mysql/slave_worker_info.ibd.deltato./mysql/slave_worker_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/mysql/innodb_table_stats.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/mysql/innodb_table_stats.ibd.deltato./mysql/innodb_table_stats.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/mysql/innodb_index_stats.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/mysql/innodb_index_stats.ibd.deltato./mysql/innodb_index_stats.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/mysql/slave_relay_log_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/mysql/slave_relay_log_info.ibd.deltato./mysql/slave_relay_log_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/mysql/slave_master_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/mysql/slave_master_info.ibd.deltato./mysql/slave_master_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.deltato./sbtest/sbtest4.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.deltato./sbtest/sbtest3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.deltato./sbtest/sbtest1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.deltato./sbtest/sbtest7.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.deltato./sbtest/sbtest6.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.deltato./sbtest/sbtest8.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.deltato./sbtest/sbtest2.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.deltato./sbtest/sbtest5.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/test/t3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/test/t3.ibd.deltato./test/t3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/test/t.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/test/t.ibd.deltato./test/t.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/test/t4.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/test/t4.ibd.deltato./test/t4.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/test/t1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/test/t1.ibd.deltato./test/t1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/t3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/t3.ibd.deltato./user_db/t3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/t.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/t.ibd.deltato./user_db/t.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/test2.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/test2.ibd.deltato./user_db/test2.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/test.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/test.ibd.deltato./user_db/test.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/t1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/t1.ibd.deltato./user_db/t1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.deltato./user_db/UC_USER.ibd...xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=/data/backups/mysql/incre_20150320xtrabackup:innodb_log_files_in_group=1xtrabackup:innodb_log_file_size=2097152xtrabackup:StartingInnoDBinstanceforrecovery.xtrabackup:Using104857600bytesforbufferpool(setby--use-memoryparameter)InnoDB:UsingatomicstorefcountbufferpoolpagesInnoDB:TheInnoDBmemoryheapisdisabledInnoDB:Mutexesandrw_locksuseGCCatomicbuiltinsInnoDB:MemorybarrierisnotusedInnoDB:Compressedtablesusezlib1.2.3InnoDB:UsingCPUcrc32instructionsInnoDB:Initializingbufferpool,size=100.0MInnoDB:CompletedinitializationofbufferpoolInnoDB:HighestsupportedfileformatisBarracuda.InnoDB:Thelogsequencenumbers423920652and423920652inibdatafilesdonotmatchthelogsequencenumber423925813intheib_logfiles!InnoDB:Databasewasnotshutdownnormally!InnoDB:Startingcrashrecovery.InnoDB:Readingtablespaceinformationfromthe.ibdfiles...InnoDB:Restoringpossiblehalf-writtendatapagesInnoDB:fromthedoublewritebuffer...InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053[notice(again)]Ifyouusebinaryloganddon'tuseanyhackofgroupcommit,thebinarylogpositionseemstobe:InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053xtrabackup:startingshutdownwithinnodb_fast_shutdown=1InnoDB:Startingshutdown...InnoDB:Shutdowncompleted;logsequencenumber423925813


4.4 恢复到第二次增量备份前面:

恢复命令:

xtrabackup --defaults-file=/etc/my.cnf--prepare --user=backup --password="123456" --apply-log-only --target-dir=/data/backups/mysql/full_incre_20150319--incremental-dir=/data/backups/mysql/incre_201503212>/tmp/restore_incre_2.log

恢复过程:

[root@data01mysql]#more/tmp/restore_incre_2.logxtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423925813isenabled.xtrabackup:cdto/data/backups/mysql/full_incre_20150319xtrabackup:Thistargetseemstobealreadyprepared.xtrabackup:xtrabackup_logfiledetected:size=2097152,start_lsn=(423931610)xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=/data/backups/mysql/incre_20150321xtrabackup:innodb_log_files_in_group=1xtrabackup:innodb_log_file_size=2097152xtrabackup:Generatingalistoftablespacesxtrabackup:pagesizefor/data/backups/mysql/incre_20150321/IBdata2.deltais16384bytesApplying/data/backups/mysql/incre_20150321/IBdata2.deltato./IBdata2...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/IBdata1.deltais16384bytesApplying/data/backups/mysql/incre_20150321/IBdata1.deltato./IBdata1...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/mysql/slave_worker_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/mysql/slave_worker_info.ibd.deltato./mysql/slave_worker_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/mysql/innodb_table_stats.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/mysql/innodb_table_stats.ibd.deltato./mysql/innodb_table_stats.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/mysql/innodb_index_stats.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/mysql/innodb_index_stats.ibd.deltato./mysql/innodb_index_stats.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.deltato./mysql/slave_relay_log_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/mysql/slave_master_info.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/mysql/slave_master_info.ibd.deltato./mysql/slave_master_info.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.deltato./sbtest/sbtest4.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.deltato./sbtest/sbtest3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.deltato./sbtest/sbtest1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.deltato./sbtest/sbtest7.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.deltato./sbtest/sbtest6.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.deltato./sbtest/sbtest8.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.deltato./sbtest/sbtest2.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.deltato./sbtest/sbtest5.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/test/t3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/test/t3.ibd.deltato./test/t3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.deltato./test/t_incre_2.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/test/t.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/test/t.ibd.deltato./test/t.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/test/t4.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/test/t4.ibd.deltato./test/t4.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/test/t1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/test/t1.ibd.deltato./test/t1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/t3.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/t3.ibd.deltato./user_db/t3.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/t.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/t.ibd.deltato./user_db/t.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/test2.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/test2.ibd.deltato./user_db/test2.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/test.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/test.ibd.deltato./user_db/test.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/t1.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/t1.ibd.deltato./user_db/t1.ibd...xtrabackup:pagesizefor/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.deltais16384bytesApplying/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.deltato./user_db/UC_USER.ibd...xtrabackup:usingthefollowingInnoDBconfigurationforrecovery:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=/data/backups/mysql/incre_20150321xtrabackup:innodb_log_files_in_group=1xtrabackup:innodb_log_file_size=2097152xtrabackup:StartingInnoDBinstanceforrecovery.xtrabackup:Using104857600bytesforbufferpool(setby--use-memoryparameter)InnoDB:UsingatomicstorefcountbufferpoolpagesInnoDB:TheInnoDBmemoryheapisdisabledInnoDB:Mutexesandrw_locksuseGCCatomicbuiltinsInnoDB:MemorybarrierisnotusedInnoDB:Compressedtablesusezlib1.2.3InnoDB:UsingCPUcrc32instructionsInnoDB:Initializingbufferpool,size=100.0MInnoDB:CompletedinitializationofbufferpoolInnoDB:HighestsupportedfileformatisBarracuda.InnoDB:Thelogsequencenumbers423925813and423925813inibdatafilesdonotmatchthelogsequencenumber423931610intheib_logfiles!InnoDB:Databasewasnotshutdownnormally!InnoDB:Startingcrashrecovery.InnoDB:Readingtablespaceinformationfromthe.ibdfiles...InnoDB:Restoringpossiblehalf-writtendatapagesInnoDB:fromthedoublewritebuffer...InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053[notice(again)]Ifyouusebinaryloganddon'tuseanyhackofgroupcommit,thebinarylogpositionseemstobe:InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053xtrabackup:startingshutdownwithinnodb_fast_shutdown=1InnoDB:Startingshutdown...InnoDB:Shutdowncompleted;logsequencenumber423931610[root@data01mysql]#


4.5 恢复整个库

恢复命令:

xtrabackup --defaults-file=/etc/my.cnf--prepare --user=backup --password="123456"--target-dir=/data/backups/mysql/full_incre_20150319 2>/tmp/restore_end_3.log

停止mysql服务:

service mysqld5612 stop

开始rsync数据文件:

cd /data/backups/mysql/full_incre_20150319

rsync -rvt --exclude'xtrabackup_checkpoints' --exclude 'xtrabackup_logfile' ./ /home/data/mysql/data

授予mysql访问权限:

chown -R mysql:mysql /home/data/mysql/data

启动mysql服务:

service mysqld5612 start

4.6,验证

登录mysql,看到以前在备份之后删除的t4以及t_incre_2表的数据已经通过2次增量备份恢复过来了,如下所示:

mysql>select*fromt4;+-----+---+|a|b|+-----+---+|aaa|1||bbb|2|+-----+---+2rowsinset(0.05sec)mysql>select*fromt_incre_2;+----+---+|a|b|+----+---+|cc|2||dd|2|+----+---+2rowsinset(0.06sec)mysql>5,innobackupex先做全量备份

命令如下:

innobackupex --defaults-file=/etc/my.cnf--user=backup --password="123456" --host=192.168.52.129/data/backups/mysql/innobackupex_full_20150319/ --no-timestamp 2>/tmp/innobackupex_full.log

备份过程信息:

[root@data01mysql]#more/tmp/innobackupex_full.logInnoDBBackupUtilityv1.5.1-xtrabackup;Copyright2003,2009InnobaseOyandPerconaLLCand/oritsaffiliates2009-2013.AllRightsReserved.ThissoftwareispublishedundertheGNUGENERALPUBLICLICENSEVersion2,June1991.GetthelatestversionofPerconaXtraBackup,documentation,andhelpresources:http://www.percona.com/xb/p15031902:31:18innobackupex:ConnectingtoMySQLserverwithDSN'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup;host=192.168.52.129'as'backup'(usingpassword:YES).15031902:31:18innobackupex:ConnectedtoMySQLserver15031902:31:18innobackupex:Executingaversioncheckagainsttheserver...15031902:31:18innobackupex:Done.15031902:31:18innobackupex:StartingthebackupoperationIMPORTANT:Pleasecheckthatthebackupruncompletessuccessfully.Attheendofasuccessfulbackupruninnobackupexprints"completedOK!".innobackupex:Usingserverversion5.6.12-loginnobackupex:Createdbackupdirectory/data/backups/mysql/innobackupex_full_2015031915031902:31:18innobackupex:Startingibbackupwithcommand:xtrabackup--defaults-file="/etc/my.cnf"--defaults-group="mysqld"--backup--suspend-at-end--target-dir=/data/backups/mysql/innobackupex_full_20150319--tmpdir=/tmp--extra-lsndir='/tmp'innobackupex:Waitingforibbackup(pid=13118)tosuspendinnobackupex:Suspendfile'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_suspended_2'xtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423920964)xtrabackup:Generatingalistoftablespaces[01]Copying./IBdata1to/data/backups/mysql/innobackupex_full_20150319/IBdata1>>logscannedupto(423920964)[01]...done[01]Copying./IBdata2to/data/backups/mysql/innobackupex_full_20150319/IBdata2>>logscannedupto(423920964)>>logscannedupto(423920964)[01]...done>>logscannedupto(423920964)[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/innobackupex_full_20150319/mysql/slave_master_info.ibd[01]...done[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/innobackupex_full_20150319/mysql/slave_relay_log_info.ibd[01]...done[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/innobackupex_full_20150319/mysql/innodb_index_stats.ibd[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/innobackupex_full_20150319/mysql/slave_worker_info.ibd[01]...done[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/innobackupex_full_20150319/mysql/innodb_table_stats.ibd[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest1.ibd[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest5.ibd[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest8.ibd[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest4.ibd[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest2.ibd[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest6.ibd[01]...done[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest7.ibd[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest3.ibd[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/innobackupex_full_20150319/test/t1.ibd[01]...done[01]Copying./test/t4.ibdto/data/backups/mysql/innobackupex_full_20150319/test/t4.ibd[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/innobackupex_full_20150319/test/t3.ibd[01]...done[01]Copying./test/t.ibdto/data/backups/mysql/innobackupex_full_20150319/test/t.ibd[01]...done[01]Copying./test/t_incre_2.ibdto/data/backups/mysql/innobackupex_full_20150319/test/t_incre_2.ibd[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/t1.ibd[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/test.ibd[01]...done[01]Copying./user_db/test2.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/test2.ibd[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/t3.ibd[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/UC_USER.ibd>>logscannedupto(423920964)[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/innobackupex_full_20150319/user_db/t.ibd[01]...donextrabackup:Creatingsuspendfile'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_suspended_2'withpid'13118'15031902:31:24innobackupex:Continuingafteribbackuphassuspended15031902:31:24innobackupex:ExecutingFLUSHTABLESWITHREADLOCK...15031902:31:24innobackupex:Alltableslockedandflushedtodisk15031902:31:24innobackupex:Startingtobackupnon-InnoDBtablesandfilesinnobackupex:insubdirectoriesof'/home/data/mysql/data/'innobackupex:Backingupfiles'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53files)>>logscannedupto(423920964)innobackupex:Backingupfiles'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74files)>>logscannedupto(423920964)innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest3.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest4.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest6.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest8.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest1.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest2.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest7.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest5.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t_incre_2.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t4.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t1.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/UC_USER.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test2.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t1.frm'15031902:31:26innobackupex:Finishedbackingupnon-InnoDBtablesandfiles15031902:31:26innobackupex:ExecutingFLUSHNO_WRITE_TO_BINLOGENGINELOGS...15031902:31:26innobackupex:Waitingforlogcopyingtofinish>>logscannedupto(423920964)xtrabackup:Thelatestcheckpoint(forincremental):'423920964'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423920964)xtrabackup:Creatingsuspendfile'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_log_copied'withpid'13118'xtrabackup:Transactionlogoflsn(423920964)to(423920964)wascopied.15031902:31:27innobackupex:Alltablesunlockedinnobackupex:Backupcreatedindirectory'/data/backups/mysql/innobackupex_full_20150319'innobackupex:MySQLbinlogposition:filename'mysql-bin.000066',position12015031902:31:27innobackupex:Connectiontodatabaseserverclosed15031902:31:27innobackupex:completedOK![root@data01mysql]#


6,innobackupex做增量备份6.1做第一次增量备份

先录入增量数据

mysql>createtableincre1select'incre1table'asincre1,'a'asid;QueryOK,1rowaffected(0.06sec)Records:1Duplicates:0Warnings:0mysql>select*fromincre1;+---------------+----+|incre1|id|+---------------+----+|incre1table|a|+---------------+----+1rowinset(0.00sec)mysql>

再进行增量备份,命令如下:

innobackupex --incremental/data/backups/mysql/innobackex_incre_1--incremental-basedir=/data/backups/mysql/innobackupex_full_20150319/--user=backup--password="123456" --host=192.168.52.129 --no-timestamp2>/tmp/innobackex_incre_1.log

备份过程信息如下:

[root@data01mysql]#more/tmp/innobackex_incre_1.logInnoDBBackupUtilityv1.5.1-xtrabackup;Copyright2003,2009InnobaseOyandPerconaLLCand/oritsaffiliates2009-2013.AllRightsReserved.ThissoftwareispublishedundertheGNUGENERALPUBLICLICENSEVersion2,June1991.GetthelatestversionofPerconaXtraBackup,documentation,andhelpresources:http://www.percona.com/xb/p15031902:38:04innobackupex:ConnectingtoMySQLserverwithDSN'dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.52.129'as'backup'(usingpassword:YES).15031902:38:04innobackupex:ConnectedtoMySQLserver15031902:38:04innobackupex:Executingaversioncheckagainsttheserver...15031902:38:04innobackupex:Done.15031902:38:04innobackupex:StartingthebackupoperationIMPORTANT:Pleasecheckthatthebackupruncompletessuccessfully.Attheendofasuccessfulbackupruninnobackupexprints"completedOK!".innobackupex:Usingserverversion5.6.12-loginnobackupex:Createdbackupdirectory/data/backups/mysql/innobackex_incre_115031902:38:04innobackupex:Startingibbackupwithcommand:xtrabackup--defaults-group="mysqld"--backup--suspend-at-end--target-dir=/data/backups/mysql/innobackex_incre_1--tmpdir=/tmp--extra-lsndir='/tmp'--incremental-basedir='/data/backups/mysql/innobackupex_full_20150319/'innobackupex:Waitingforibbackup(pid=13358)tosuspendinnobackupex:Suspendfile'/data/backups/mysql/innobackex_incre_1/xtrabackup_suspended_2'xtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423920964isenabled.xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423925361)xtrabackup:Generatingalistoftablespacesxtrabackup:usingthefullscanforincrementalbackup>>logscannedupto(423925361)>>logscannedupto(423925361)>>logscannedupto(423925361)>>logscannedupto(423925361)[01]Copying./IBdata1to/data/backups/mysql/innobackex_incre_1/IBdata1.delta>>logscannedupto(423925361)[01]...done>>logscannedupto(423925361)[01]Copying./IBdata2to/data/backups/mysql/innobackex_incre_1/IBdata2.delta[01]...done[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/innobackex_incre_1/mysql/slave_master_info.ibd.delta[01]...done[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/innobackex_incre_1/mysql/slave_relay_log_info.ibd.delta[01]...done[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/innobackex_incre_1/mysql/innodb_index_stats.ibd.delta[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/innobackex_incre_1/mysql/slave_worker_info.ibd.delta[01]...done>>logscannedupto(423925361)[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/innobackex_incre_1/mysql/innodb_table_stats.ibd.delta[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest1.ibd.delta[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest5.ibd.delta[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest8.ibd.delta[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest4.ibd.delta[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest2.ibd.delta[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest6.ibd.delta[01]...done>>logscannedupto(423925361)[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest7.ibd.delta[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/innobackex_incre_1/sbtest/sbtest3.ibd.delta[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/innobackex_incre_1/test/t1.ibd.delta[01]...done[01]Copying./test/t4.ibdto/data/backups/mysql/innobackex_incre_1/test/t4.ibd.delta[01]...done[01]Copying./test/incre1.ibdto/data/backups/mysql/innobackex_incre_1/test/incre1.ibd.delta[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/innobackex_incre_1/test/t3.ibd.delta[01]...done[01]Copying./test/t.ibdto/data/backups/mysql/innobackex_incre_1/test/t.ibd.delta[01]...done[01]Copying./test/t_incre_2.ibdto/data/backups/mysql/innobackex_incre_1/test/t_incre_2.ibd.delta[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/innobackex_incre_1/user_db/t1.ibd.delta[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/innobackex_incre_1/user_db/test.ibd.delta[01]...done[01]Copying./user_db/test2.ibdto/data/backups/mysql/innobackex_incre_1/user_db/test2.ibd.delta[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/innobackex_incre_1/user_db/t3.ibd.delta[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/innobackex_incre_1/user_db/UC_USER.ibd.delta[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/innobackex_incre_1/user_db/t.ibd.delta[01]...done>>logscannedupto(423925361)xtrabackup:Creatingsuspendfile'/data/backups/mysql/innobackex_incre_1/xtrabackup_suspended_2'withpid'13358'>>logscannedupto(423925361)15031902:38:15innobackupex:Continuingafteribbackuphassuspended15031902:38:15innobackupex:ExecutingFLUSHTABLESWITHREADLOCK...15031902:38:15innobackupex:Alltableslockedandflushedtodisk15031902:38:15innobackupex:Startingtobackupnon-InnoDBtablesandfilesinnobackupex:insubdirectoriesof'/home/data/mysql/data/'innobackupex:Backingupfiles'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53files)>>logscannedupto(423925361)innobackupex:Backingupfiles'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74files)>>logscannedupto(423925361)innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest3.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest4.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest6.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest8.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest1.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest2.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest7.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest5.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t_incre_2.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t4.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/incre1.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t1.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/UC_USER.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test2.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t1.frm'15031902:38:17innobackupex:Finishedbackingupnon-InnoDBtablesandfiles15031902:38:17innobackupex:ExecutingFLUSHNO_WRITE_TO_BINLOGENGINELOGS...15031902:38:17innobackupex:Waitingforlogcopyingtofinishxtrabackup:Thelatestcheckpoint(forincremental):'423925361'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423925361)xtrabackup:Creatingsuspendfile'/data/backups/mysql/innobackex_incre_1/xtrabackup_log_copied'withpid'13358'xtrabackup:Transactionlogoflsn(423925361)to(423925361)wascopied.15031902:38:18innobackupex:Alltablesunlockedinnobackupex:Backupcreatedindirectory'/data/backups/mysql/innobackex_incre_1'innobackupex:MySQLbinlogposition:filename'mysql-bin.000066',position12015031902:38:18innobackupex:Connectiontodatabaseserverclosed15031902:38:18innobackupex:completedOK![root@data01mysql]#


6.2 基于全备和第一个增量备份来做第二次增量备份

先录入增量数据录入

mysql>createtableincre2select'incre2'asa,3asid;QueryOK,1rowaffected(0.12sec)Records:1Duplicates:0Warnings:0mysql>mysql>select*fromincre2;+--------+----+|a|id|+--------+----+|incre2|3|+--------+----+1rowinset(0.00sec)mysql>

开始进行第二次增量备份,备份命令:

innobackupex --incremental/data/backups/mysql/innobackex_incre_2 --incremental-basedir=/data/backups/mysql/innobackex_incre_1/--user=backup--password="123456" --host=192.168.52.129 --no-timestamp2>/tmp/innobackex_incre_2.log

备份过程信息如下:

[root@data01innobackex_incre_1]#more/tmp/innobackex_incre_2.logInnoDBBackupUtilityv1.5.1-xtrabackup;Copyright2003,2009InnobaseOyandPerconaLLCand/oritsaffiliates2009-2013.AllRightsReserved.ThissoftwareispublishedundertheGNUGENERALPUBLICLICENSEVersion2,June1991.GetthelatestversionofPerconaXtraBackup,documentation,andhelpresources:http://www.percona.com/xb/p15031902:51:09innobackupex:ConnectingtoMySQLserverwithDSN'dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.52.129'as'backup'(usingpassword:YES).15031902:51:09innobackupex:ConnectedtoMySQLserver15031902:51:09innobackupex:Executingaversioncheckagainsttheserver...15031902:51:09innobackupex:Done.15031902:51:09innobackupex:StartingthebackupoperationIMPORTANT:Pleasecheckthatthebackupruncompletessuccessfully.Attheendofasuccessfulbackupruninnobackupexprints"completedOK!".innobackupex:Usingserverversion5.6.12-loginnobackupex:Createdbackupdirectory/data/backups/mysql/innobackex_incre_215031902:51:10innobackupex:Startingibbackupwithcommand:xtrabackup--defaults-group="mysqld"--backup--suspend-at-end--target-dir=/data/backups/mysql/innobackex_incre_2--tmpdir=/tmp--extra-lsndir='/tmp'--incremental-basedir='/data/backups/mysql/innobackex_incre_1/'innobackupex:Waitingforibbackup(pid=13694)tosuspendinnobackupex:Suspendfile'/data/backups/mysql/innobackex_incre_2/xtrabackup_suspended_2'xtrabackupversion2.2.9basedonMySQLserver5.6.22Linux(x86_64)(revisionid:)incrementalbackupfrom423925361isenabled.xtrabackup:usesposix_fadvise().xtrabackup:cdto/home/data/mysql/dataxtrabackup:openfileslimitrequested0,setto1024xtrabackup:usingthefollowingInnoDBconfiguration:xtrabackup:innodb_data_home_dir=./xtrabackup:innodb_data_file_path=IBdata1:128M;IBdata2:128M:autoextendxtrabackup:innodb_log_group_home_dir=./xtrabackup:innodb_log_files_in_group=3xtrabackup:innodb_log_file_size=67108864>>logscannedupto(423929601)xtrabackup:Generatingalistoftablespacesxtrabackup:usingthefullscanforincrementalbackup>>logscannedupto(423929601)[01]Copying./IBdata1to/data/backups/mysql/innobackex_incre_2/IBdata1.delta>>logscannedupto(423929601)[01]...done[01]Copying./IBdata2to/data/backups/mysql/innobackex_incre_2/IBdata2.delta[01]...done[01]Copying./mysql/slave_master_info.ibdto/data/backups/mysql/innobackex_incre_2/mysql/slave_master_info.ibd.delta[01]...done>>logscannedupto(423929601)[01]Copying./mysql/slave_relay_log_info.ibdto/data/backups/mysql/innobackex_incre_2/mysql/slave_relay_log_info.ibd.delta[01]...done[01]Copying./mysql/innodb_index_stats.ibdto/data/backups/mysql/innobackex_incre_2/mysql/innodb_index_stats.ibd.delta[01]...done[01]Copying./mysql/slave_worker_info.ibdto/data/backups/mysql/innobackex_incre_2/mysql/slave_worker_info.ibd.delta[01]...done[01]Copying./mysql/innodb_table_stats.ibdto/data/backups/mysql/innobackex_incre_2/mysql/innodb_table_stats.ibd.delta[01]...done[01]Copying./sbtest/sbtest1.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest1.ibd.delta[01]...done[01]Copying./sbtest/sbtest5.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest5.ibd.delta[01]...done[01]Copying./sbtest/sbtest8.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest8.ibd.delta[01]...done[01]Copying./sbtest/sbtest4.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest4.ibd.delta[01]...done[01]Copying./sbtest/sbtest2.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest2.ibd.delta[01]...done[01]Copying./sbtest/sbtest6.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest6.ibd.delta[01]...done[01]Copying./sbtest/sbtest7.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest7.ibd.delta[01]...done[01]Copying./sbtest/sbtest3.ibdto/data/backups/mysql/innobackex_incre_2/sbtest/sbtest3.ibd.delta[01]...done[01]Copying./test/incre2.ibdto/data/backups/mysql/innobackex_incre_2/test/incre2.ibd.delta[01]...done[01]Copying./test/t1.ibdto/data/backups/mysql/innobackex_incre_2/test/t1.ibd.delta[01]...done[01]Copying./test/t4.ibdto/data/backups/mysql/innobackex_incre_2/test/t4.ibd.delta[01]...done[01]Copying./test/incre1.ibdto/data/backups/mysql/innobackex_incre_2/test/incre1.ibd.delta[01]...done[01]Copying./test/t3.ibdto/data/backups/mysql/innobackex_incre_2/test/t3.ibd.delta[01]...done>>logscannedupto(423929601)[01]Copying./test/t.ibdto/data/backups/mysql/innobackex_incre_2/test/t.ibd.delta[01]...done[01]Copying./test/t_incre_2.ibdto/data/backups/mysql/innobackex_incre_2/test/t_incre_2.ibd.delta[01]...done[01]Copying./user_db/t1.ibdto/data/backups/mysql/innobackex_incre_2/user_db/t1.ibd.delta[01]...done[01]Copying./user_db/test.ibdto/data/backups/mysql/innobackex_incre_2/user_db/test.ibd.delta[01]...done[01]Copying./user_db/test2.ibdto/data/backups/mysql/innobackex_incre_2/user_db/test2.ibd.delta[01]...done[01]Copying./user_db/t3.ibdto/data/backups/mysql/innobackex_incre_2/user_db/t3.ibd.delta[01]...done[01]Copying./user_db/UC_USER.ibdto/data/backups/mysql/innobackex_incre_2/user_db/UC_USER.ibd.delta[01]...done[01]Copying./user_db/t.ibdto/data/backups/mysql/innobackex_incre_2/user_db/t.ibd.delta[01]...done>>logscannedupto(423929601)xtrabackup:Creatingsuspendfile'/data/backups/mysql/innobackex_incre_2/xtrabackup_suspended_2'withpid'13694'15031902:51:16innobackupex:Continuingafteribbackuphassuspended15031902:51:16innobackupex:ExecutingFLUSHTABLESWITHREADLOCK...15031902:51:16innobackupex:Alltableslockedandflushedtodisk15031902:51:16innobackupex:Startingtobackupnon-InnoDBtablesandfilesinnobackupex:insubdirectoriesof'/home/data/mysql/data/'innobackupex:Backingupfiles'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53files)>>logscannedupto(423929601)innobackupex:Backingupfiles'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74files)>>logscannedupto(423929601)innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest3.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest4.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest6.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest8.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest1.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest2.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest7.frm'innobackupex:Backingupfile'/home/data/mysql/data//sbtest/sbtest5.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t_incre_2.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t4.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/incre2.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/incre1.frm'innobackupex:Backingupfile'/home/data/mysql/data//test/t1.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/UC_USER.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t3.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/db.opt'innobackupex:Backingupfile'/home/data/mysql/data//user_db/test2.frm'innobackupex:Backingupfile'/home/data/mysql/data//user_db/t1.frm'15031902:51:17innobackupex:Finishedbackingupnon-InnoDBtablesandfiles15031902:51:17innobackupex:ExecutingFLUSHNO_WRITE_TO_BINLOGENGINELOGS...15031902:51:17innobackupex:Waitingforlogcopyingtofinishxtrabackup:Thelatestcheckpoint(forincremental):'423929601'xtrabackup:Stoppinglogcopyingthread..>>logscannedupto(423929601)xtrabackup:Creatingsuspendfile'/data/backups/mysql/innobackex_incre_2/xtrabackup_log_copied'withpid'13694'xtrabackup:Transactionlogoflsn(423929601)to(423929601)wascopied.15031902:51:18innobackupex:Alltablesunlockedinnobackupex:Backupcreatedindirectory'/data/backups/mysql/innobackex_incre_2'innobackupex:MySQLbinlogposition:filename'mysql-bin.000066',position12015031902:51:19innobackupex:Connectiontodatabaseserverclosed15031902:51:19innobackupex:completedOK!


7,innobackupex做增量恢复7.1先删除两次增量数据,用来查看验证恢复结果

mysql>deletefromincre1;QueryOK,1rowaffected(0.05sec)mysql>deletefromincre2;QueryOK,1rowaffected(0.01sec)mysql>select*fromincre1;Emptyset(0.00sec)mysql>select*fromincre2;Emptyset(0.00sec)7.2 开始做恢复,恢复全备份

备份命令如下:

innobackupex --user=backup--password="123456" --host=192.168.52.129 --apply-log/data/backups/mysql/innobackupex_full_20150319/2>/tmp/innobackex_restore_full.log

备份过程信息如下:

......InnoDB:LastMySQLbinlogfileposition0915,filenamemysql-bin.000053xtrabackup:startingshutdownwithinnodb_fast_shutdown=1InnoDB:FTSoptimizethreadexiting.InnoDB:Startingshutdown...InnoDB:Shutdowncompleted;logsequencenumber42392163415031903:06:57innobackupex:completedOK!7.3 基于全备份进行第一字增量备份的恢复

备份命令:

innobackupex --defaults-file=/etc/my.cnf--user=backup --password="123456" --host=192.168.52.129/data/backups/mysql/innobackupex_full_20150319/--incremental-dir=/data/backups/mysql/innobackex_incre_1 --apply-log2>/tmp/innobackex_restore_incre_1.log

备份过程信息如下:

……xtrabackup:startingshutdownwithinnodb_fast_shutdown=1InnoDB:FTSoptimizethreadexiting.InnoDB:Startingshutdown...InnoDB:Shutdowncompleted;logsequencenumber423925452innobackupex:Startingtocopynon-InnoDBfilesin'/data/backups/mysql/innobackex_incre_1'innobackupex:tothefullbackupdirectory'/data/backups/mysql/innobackupex_full_20150319'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/xtrabackup_info'to'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_info'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/xtrabackup_binlog_info'to'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_binlog_info'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_history.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_history.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_global_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_global_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/threads.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/threads.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_history_long.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_history_long.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/file_summary_by_instance.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/file_summary_by_instance.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_by_user_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_by_user_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_by_account_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_by_account_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_by_user_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_by_user_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_current.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_current.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/table_lock_waits_summary_by_table.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/table_lock_waits_summary_by_table.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/socket_instances.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/socket_instances.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/setup_actors.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/setup_actors.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/table_io_waits_summary_by_table.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/table_io_waits_summary_by_table.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_summary_by_account_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_summary_by_account_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/cond_instances.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/cond_instances.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/users.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/users.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/db.opt'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/db.opt'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_by_instance.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_by_instance.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_summary_by_thread_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_summary_by_thread_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_current.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_current.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/objects_summary_global_by_type.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/objects_summary_global_by_type.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_by_thread_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_by_thread_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_by_host_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_by_host_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/socket_summary_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/socket_summary_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_history.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_history.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_history.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_history.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_by_thread_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_by_thread_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_summary_global_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_summary_global_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/setup_timers.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/setup_timers.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/hosts.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/hosts.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_summary_by_host_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_summary_by_host_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/host_cache.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/host_cache.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/setup_objects.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/setup_objects.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/setup_consumers.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/setup_consumers.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/session_account_connect_attrs.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/session_account_connect_attrs.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_by_host_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_by_host_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/socket_summary_by_instance.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/socket_summary_by_instance.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_global_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_global_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_summary_by_user_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_summary_by_user_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/mutex_instances.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/mutex_instances.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/setup_instruments.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/setup_instruments.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_summary_by_digest.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_summary_by_digest.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/rwlock_instances.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/rwlock_instances.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/file_summary_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/file_summary_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_summary_by_account_by_event_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_summary_by_account_by_event_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_stages_current.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_stages_current.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/session_connect_attrs.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/session_connect_attrs.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/performance_timers.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/performance_timers.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_waits_history_long.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_waits_history_long.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/file_instances.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/file_instances.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/events_statements_history_long.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/events_statements_history_long.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/table_io_waits_summary_by_index_usage.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/table_io_waits_summary_by_index_usage.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/performance_schema/accounts.frm'to'/data/backups/mysql/innobackupex_full_20150319/performance_schema/accounts.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/event.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/event.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/columns_priv.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/columns_priv.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/db.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/db.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/user.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/user.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition_type.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition_type.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/procs_priv.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/procs_priv.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_topic.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_topic.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_name.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_name.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/columns_priv.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/columns_priv.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slow_log.CSV'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slow_log.CSV'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/func.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/func.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/db.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/db.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/servers.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/servers.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proc.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proc.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/tables_priv.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/tables_priv.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slave_worker_info.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slave_worker_info.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/ndb_binlog_index.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/ndb_binlog_index.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slow_log.CSM'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slow_log.CSM'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/ndb_binlog_index.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/ndb_binlog_index.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/tables_priv.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/tables_priv.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/event.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/event.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/func.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/func.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_keyword.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_keyword.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/procs_priv.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/procs_priv.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slave_relay_log_info.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slave_relay_log_info.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_leap_second.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_leap_second.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/func.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/func.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_keyword.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_keyword.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/procs_priv.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/procs_priv.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_topic.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_topic.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/plugin.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/plugin.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/innodb_index_stats.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/innodb_index_stats.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_category.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_category.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition_type.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition_type.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/user.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/user.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/general_log.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/general_log.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_category.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_category.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_relation.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_relation.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proxies_priv.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proxies_priv.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/tables_priv.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/tables_priv.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition_type.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition_type.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/general_log.CSM'to'/data/backups/mysql/innobackupex_full_20150319/mysql/general_log.CSM'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proxies_priv.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proxies_priv.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/ndb_binlog_index.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/ndb_binlog_index.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slave_master_info.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slave_master_info.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_relation.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_relation.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/db.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/db.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_leap_second.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_leap_second.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_leap_second.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_leap_second.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_name.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_name.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proc.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proc.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_relation.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_relation.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proxies_priv.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proxies_priv.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/servers.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/servers.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_keyword.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_keyword.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/servers.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/servers.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_transition.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_transition.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_category.MYI'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_category.MYI'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/innodb_table_stats.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/innodb_table_stats.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/slow_log.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/slow_log.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/user.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/user.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/time_zone_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/plugin.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/plugin.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/columns_priv.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/columns_priv.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/plugin.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/plugin.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/general_log.CSV'to'/data/backups/mysql/innobackupex_full_20150319/mysql/general_log.CSV'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/event.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/event.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/proc.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proc.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/mysql/help_topic.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_topic.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest3.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest4.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest4.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest6.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest6.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest8.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest8.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest1.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/db.opt'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/db.opt'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest2.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest7.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest7.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/sbtest/sbtest5.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest5.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/test/t_incre_2.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t_incre_2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/test/t3.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/test/t4.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t4.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/test/incre1.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/incre1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/test/t1.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/UC_USER.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/UC_USER.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/t.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/t3.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/test.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/test.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/db.opt'to'/data/backups/mysql/innobackupex_full_20150319/user_db/db.opt'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/test2.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/test2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_1/user_db/t1.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t1.frm'15031903:12:51innobackupex:completedOK!


7.4, 基于全备份和第一次增量备份,恢复第二次增量备份

备份命令如下:

innobackupex --defaults-file=/etc/my.cnf--user=backup --password="123456" --host=192.168.52.129/data/backups/mysql/innobackupex_full_20150319/--incremental-dir=/data/backups/mysql/innobackex_incre_2 --apply-log2>/tmp/innobackex_restore_incre_2.log

备份过程信息如下:

……innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/user.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/user.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/time_zone_name.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/time_zone_name.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/plugin.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/plugin.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/columns_priv.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/columns_priv.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/plugin.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/plugin.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/general_log.CSV'to'/data/backups/mysql/innobackupex_full_20150319/mysql/general_log.CSV'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/event.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/event.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/proc.MYD'to'/data/backups/mysql/innobackupex_full_20150319/mysql/proc.MYD'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/mysql/help_topic.frm'to'/data/backups/mysql/innobackupex_full_20150319/mysql/help_topic.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest3.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest4.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest4.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest6.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest6.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest8.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest8.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest1.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/db.opt'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/db.opt'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest2.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest7.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest7.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/sbtest/sbtest5.frm'to'/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest5.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/t_incre_2.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t_incre_2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/t3.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/t4.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t4.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/incre2.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/incre2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/incre1.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/incre1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/test/t1.frm'to'/data/backups/mysql/innobackupex_full_20150319/test/t1.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/UC_USER.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/UC_USER.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/t.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/t3.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t3.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/test.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/test.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/db.opt'to'/data/backups/mysql/innobackupex_full_20150319/user_db/db.opt'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/test2.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/test2.frm'innobackupex:Copying'/data/backups/mysql/innobackex_incre_2/user_db/t1.frm'to'/data/backups/mysql/innobackupex_full_20150319/user_db/t1.frm'15031903:18:34innobackupex:completedOK![root@data01mysql]#


7.5 恢复整个数据库

停止数据库

service mysqld5612 stop

清空数据目录下所有文件

mkdir -p /tmp/mysqldatabak/

mv/home/data/mysql/data/* /tmp/mysqldatabak/

将恢复好的数据按照配置文件的需求拷贝到相应目录

innobackupex --defaults-file=/etc/my.cnf--user=backup --password="123456" --host=192.168.52.129--defaults-file=/etc/my.cnf --copy-back/data/backups/mysql/innobackupex_full_20150319/ 2>/tmp/innobackex_incre_restore_end.log

赋予mysql账号权限

chown -R mysql:mysql /home/data/mysql/data

启动mysql服务

service mysqld5612 start

PS:--copy-back过程如下:

innobackupex:StartingtocopyInnoDBundotablespacesinnobackupex:in'/data/backups/mysql/innobackupex_full_20150319'innobackupex:backto'/home/data/mysql/data'innobackupex:StartingtocopyInnoDBlogfilesinnobackupex:in'/data/backups/mysql/innobackupex_full_20150319'innobackupex:backtooriginalInnoDBlogdirectory'/home/data/mysql/data'innobackupex:Copying'/data/backups/mysql/innobackupex_full_20150319/ib_logfile1'to'/home/data/mysql/data/ib_logfile1'innobackupex:Copying'/data/backups/mysql/innobackupex_full_20150319/ib_logfile2'to'/home/data/mysql/data/ib_logfile2'innobackupex:Copying'/data/backups/mysql/innobackupex_full_20150319/ib_logfile0'to'/home/data/mysql/data/ib_logfile0'innobackupex:Finishedcopyingbackfiles.15031903:23:49innobackupex:completedOK!7.6 check已经被delete的数据

登录mysql界面,查看表incre1和表incre2,数据已经恢复,如下所示:

mysql>select*fromincre1;+---------------+----+|incre1|id|+---------------+----+|incre1table|a|+---------------+----+1rowinset(0.04sec)mysql>select*fromincre2;+--------+----+|a|id|+--------+----+|incre2|3|+--------+----+1rowinset(0.07sec)mysql>


到此,相信大家对“MySQL利用xtrabackup进行增量备份的详细过程”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!