目錄
MySQL利用xtrabackup进行增量备份详细过程汇总_MySQL
備份
過程
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) xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/data/mysql/data xtrabackup: open files limit requested 0,set to 1024 xtrabackup: using the following InnoDBconfiguration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 67108864 >> log scanned up to (423920168) xtrabackup: Generating a list of tablespaces [01] Copying ./IBdata1 to/data/backups/mysql/full_incre_20150319/IBdata1 >> log scanned up to (423920168) >> log scanned up to (423920168) [01] ...done [01] Copying ./IBdata2 to/data/backups/mysql/full_incre_20150319/IBdata2 >> log scanned up to (423920168) >> log scanned up to (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.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest1.ibd [01] ...done [01] Copying ./sbtest/sbtest5.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest5.ibd [01] ...done [01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest8.ibd [01] ...done [01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest4.ibd [01] ...done [01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest2.ibd [01] ...done [01] Copying ./sbtest/sbtest6.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest6.ibd [01] ...done [01] Copying ./sbtest/sbtest7.ibd to /data/backups/mysql/full_incre_20150319/sbtest/sbtest7.ibd [01] ...done [01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/full_incre_20150319/sbtest/sbtest3.ibd [01] ...done [01] Copying ./test/t1.ibd to/data/backups/mysql/full_incre_20150319/test/t1.ibd [01] ...done [01] Copying ./test/t3.ibd to/data/backups/mysql/full_incre_20150319/test/t3.ibd [01] ...done [01] Copying ./test/t.ibd to/data/backups/mysql/full_incre_20150319/test/t.ibd [01] ...done [01] Copying ./user_db/t1.ibd to/data/backups/mysql/full_incre_20150319/user_db/t1.ibd [01] ...done [01] Copying ./user_db/test.ibd to/data/backups/mysql/full_incre_20150319/user_db/test.ibd [01] ...done [01] Copying ./user_db/test2.ibd to/data/backups/mysql/full_incre_20150319/user_db/test2.ibd [01] ...done [01] Copying ./user_db/t3.ibd to/data/backups/mysql/full_incre_20150319/user_db/t3.ibd [01] ...done [01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/full_incre_20150319/user_db/UC_USER.ibd >> log scanned up to (423920168) [01] ...done [01] Copying ./user_db/t.ibd to/data/backups/mysql/full_incre_20150319/user_db/t.ibd [01] ...done xtrabackup: The latest check point (forincremental): '423920168' xtrabackup: Stopping log copying thread. .>> log scanned up to (423920168) xtrabackup: Transaction log of lsn(423920168) to (423920168) was copied. [root@data01 ~]#
登入後複製
3，xtrabackup进行增量备份
3.1先录入一张表，实现第一次增量数据：
mysql> create table t4 select 'aaa' asa, 1 as b; Query OK, 1 row affected (0.36 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> mysql> insert into t4 select 'bbb',2; Query OK, 1 row affected (0.05 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql>
登入後複製
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.log xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) incremental backup from 423920168 isenabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/data/mysql/data xtrabackup: open files limit requested 0,set to 1024 xtrabackup: using the following InnoDBconfiguration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 67108864 >> log scanned up to (423925813) xtrabackup: Generating a list oftablespaces xtrabackup: using the full scan forincremental backup [01] Copying ./IBdata1 to/data/backups/mysql/incre_20150320/IBdata1.delta >> log scanned up to (423925813) [01] ...done [01] Copying ./IBdata2 to/data/backups/mysql/incre_20150320/IBdata2.delta >> log scanned up to (423925813) [01] ...done >> log scanned up to (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.ibd to/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.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest5.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest6.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest7.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.delta [01] ...done [01] Copying ./test/t1.ibd to/data/backups/mysql/incre_20150320/test/t1.ibd.delta [01] ...done [01] Copying ./test/t4.ibd to/data/backups/mysql/incre_20150320/test/t4.ibd.delta [01] ...done [01] Copying ./test/t3.ibd to/data/backups/mysql/incre_20150320/test/t3.ibd.delta [01] ...done [01] Copying ./test/t.ibd to/data/backups/mysql/incre_20150320/test/t.ibd.delta [01] ...done [01] Copying ./user_db/t1.ibd to /data/backups/mysql/incre_20150320/user_db/t1.ibd.delta [01] ...done [01] Copying ./user_db/test.ibd to/data/backups/mysql/incre_20150320/user_db/test.ibd.delta [01] ...done >> log scanned up to (423925813) [01] Copying ./user_db/test2.ibd to /data/backups/mysql/incre_20150320/user_db/test2.ibd.delta [01] ...done [01] Copying ./user_db/t3.ibd to/data/backups/mysql/incre_20150320/user_db/t3.ibd.delta [01] ...done [01] Copying ./user_db/UC_USER.ibd to /data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.delta [01] ...done [01] Copying ./user_db/t.ibd to/data/backups/mysql/incre_20150320/user_db/t.ibd.delta [01] ...done xtrabackup: The latest check point (forincremental): '423925813' xtrabackup: Stopping log copying thread. .>> log scanned up to (423925813) xtrabackup: Transaction log of lsn(423925813) to (423925813) was copied.
登入後複製
3.3 再建立表2，实现第二天增量数据
建立一张表t_incre_2：
mysql> use test; Database changed mysql> create table t_incre_2 select'cc' as a,2 as b; Query OK, 1 row affected (0.25 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into t_incre_2 select'dd',2; Query OK, 1 row affected (0.05 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> select * from t_incre_2; +----+---+ | a | b | +----+---+ | cc | 2 | | dd | 2 | +----+---+ 2 rows in set (0.05 sec) 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.log xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) incremental backup from 423925813 isenabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/data/mysql/data xtrabackup: open files limit requested 0,set to 1024 xtrabackup: using the following InnoDBconfiguration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 67108864 >> log scanned up to (423931610) xtrabackup: Generating a list oftablespaces xtrabackup: using the full scan forincremental backup [01] Copying ./IBdata1 to/data/backups/mysql/incre_20150321/IBdata1.delta >> log scanned up to (423931610) >> log scanned up to (423931610) >> log scanned up to (423931610) >> log scanned up to (423931610) >> log scanned up to (423931610) [01] ...done >> log scanned up to (423931610) [01] Copying ./IBdata2 to/data/backups/mysql/incre_20150321/IBdata2.delta >> log scanned up to (423931610) >> log scanned up to (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.ibd to/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.delta [01] ...done >> log scanned up to (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.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest5.ibd to /data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest6.ibd to /data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest7.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.delta [01] ...done [01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.delta [01] ...done [01] Copying ./test/t1.ibd to/data/backups/mysql/incre_20150321/test/t1.ibd.delta [01] ...done [01] Copying ./test/t4.ibd to/data/backups/mysql/incre_20150321/test/t4.ibd.delta [01] ...done [01] Copying ./test/t3.ibd to/data/backups/mysql/incre_20150321/test/t3.ibd.delta [01] ...done >> log scanned up to (423931610) [01] Copying ./test/t.ibd to/data/backups/mysql/incre_20150321/test/t.ibd.delta [01] ...done [01] Copying ./test/t_incre_2.ibd to/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.delta [01] ...done [01] Copying ./user_db/t1.ibd to/data/backups/mysql/incre_20150321/user_db/t1.ibd.delta [01] ...done [01] Copying ./user_db/test.ibd to /data/backups/mysql/incre_20150321/user_db/test.ibd.delta [01] ...done [01] Copying ./user_db/test2.ibd to/data/backups/mysql/incre_20150321/user_db/test2.ibd.delta [01] ...done [01] Copying ./user_db/t3.ibd to/data/backups/mysql/incre_20150321/user_db/t3.ibd.delta [01] ...done [01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.delta [01] ...done [01] Copying ./user_db/t.ibd to/data/backups/mysql/incre_20150321/user_db/t.ibd.delta [01] ...done >> log scanned up to (423931610) xtrabackup: The latest check point (forincremental): '423931610' xtrabackup: Stopping log copying thread. .>> log scanned up to (423931610) xtrabackup: Transaction log of lsn(423931610) to (423931610) was copied.
登入後複製
4，xtrabackup进行增量恢复
4.1为了验证比对，先删除两个增量备份前表里面的数据
mysql> delete from t4; Query OK, 2 rows affected (0.05 sec) mysql> delete from t_incre_2; Query OK, 2 rows affected (0.04 sec) mysql> select * from t4; Empty set (0.00 sec) mysql> select * from t_incre_2; Empty set (0.00 sec) 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@data01 mysql]# xtrabackup--defaults-file=/etc/my.cnf --prepare --user=backup--password="123456" --apply-log-only --target-dir=/data/backups/mysql/full_incre_20150319 xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) xtrabackup: cd to/data/backups/mysql/full_incre_20150319 xtrabackup: This target seems to be alreadyprepared. xtrabackup: notice: xtrabackup_logfile wasalready used to '--prepare'. xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 67108864 xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 67108864 xtrabackup: Starting InnoDB instance forrecovery. xtrabackup: Using 104857600 bytes forbuffer pool (set by --use-memory parameter) InnoDB: Using atomics to ref count bufferpool pages InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomicbuiltins InnoDB: Memory barrier is not used InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, size =100.0M InnoDB: Completed initialization of bufferpool InnoDB: Setting log file ./ib_logfile101size to 64 MB InnoDB: Setting log file ./ib_logfile1 sizeto 64 MB InnoDB: Setting log file ./ib_logfile2 sizeto 64 MB InnoDB: Renaming log file ./ib_logfile101to ./ib_logfile0 InnoDB: New log files created,LSN=423920168 InnoDB: Highest supported file format isBarracuda. [notice (again)] Ifyou use binary log and don't use any hack of group commit, thebinary log position seems to be: InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053 xtrabackup: starting shutdown withinnodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequencenumber 423920652 [root@data01 mysql]#
登入後複製
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@data01 mysql]# more /tmp/restore_incre_1.log xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) incremental backup from 423920168 isenabled. xtrabackup: cd to/data/backups/mysql/full_incre_20150319 xtrabackup: This target seems to be alreadyprepared. xtrabackup: xtrabackup_logfile detected:size=2097152, start_lsn=(423925813) xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir =/data/backups/mysql/incre_20150320 xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup: Generating a list oftablespaces xtrabackup: page size for /data/backups/mysql/incre_20150320/IBdata2.deltais 16384 bytes Applying/data/backups/mysql/incre_20150320/IBdata2.delta to ./IBdata2... xtrabackup: page size for/data/backups/mysql/incre_20150320/IBdata1.delta is 16384 bytes Applying /data/backups/mysql/incre_20150320/IBdata1.deltato ./IBdata1... xtrabackup: page size for/data/backups/mysql/incre_20150320/mysql/slave_worker_info.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150320/mysql/slave_worker_info.ibd.delta to./mysql/slave_worker_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/mysql/innodb_table_stats.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150320/mysql/innodb_table_stats.ibd.delta to./mysql/innodb_table_stats.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/mysql/innodb_index_stats.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150320/mysql/innodb_index_stats.ibd.delta to./mysql/innodb_index_stats.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/mysql/slave_relay_log_info.ibd.delta is16384 bytes Applying/data/backups/mysql/incre_20150320/mysql/slave_relay_log_info.ibd.delta to./mysql/slave_relay_log_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/mysql/slave_master_info.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150320/mysql/slave_master_info.ibd.delta to./mysql/slave_master_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest4.ibd.delta to./sbtest/sbtest4.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest3.ibd.delta to./sbtest/sbtest3.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest1.ibd.delta to./sbtest/sbtest1.ibd... xtrabackup: page size for /data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.deltais 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest7.ibd.delta to./sbtest/sbtest7.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest6.ibd.delta to./sbtest/sbtest6.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.delta is 16384 bytes Applying /data/backups/mysql/incre_20150320/sbtest/sbtest8.ibd.deltato ./sbtest/sbtest8.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest2.ibd.delta to./sbtest/sbtest2.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/sbtest/sbtest5.ibd.delta to./sbtest/sbtest5.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/test/t3.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/test/t3.ibd.delta to ./test/t3.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/test/t.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/test/t.ibd.delta to ./test/t.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/test/t4.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/test/t4.ibd.delta to ./test/t4.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/test/t1.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/test/t1.ibd.delta to ./test/t1.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/t3.ibd.delta is 16384 bytes Applying /data/backups/mysql/incre_20150320/user_db/t3.ibd.deltato ./user_db/t3.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/t.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/user_db/t.ibd.delta to ./user_db/t.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/test2.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/user_db/test2.ibd.delta to./user_db/test2.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/test.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/user_db/test.ibd.delta to./user_db/test.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/t1.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/user_db/t1.ibd.delta to ./user_db/t1.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150320/user_db/UC_USER.ibd.delta to./user_db/UC_USER.ibd... xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir =/data/backups/mysql/incre_20150320 xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup: Starting InnoDB instance forrecovery. xtrabackup: Using 104857600 bytes forbuffer pool (set by --use-memory parameter) InnoDB: Using atomics to ref count bufferpool pages InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomicbuiltins InnoDB: Memory barrier is not used InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, size = 100.0M InnoDB: Completed initialization of bufferpool InnoDB: Highest supported file format isBarracuda. InnoDB: The log sequence numbers 423920652and 423920652 in ibdata files do not match the log sequence number 423925813 inthe ib_logfiles! InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information fromthe .ibd files... InnoDB: Restoring possible half-writtendata pages InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053 [notice (again)] Ifyou use binary log and don't use any hack of group commit, thebinary log position seems to be: InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053 xtrabackup: starting shutdown withinnodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequencenumber 423925813
登入後複製
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@data01 mysql]# more/tmp/restore_incre_2.log xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: ) incremental backup from 423925813 isenabled. xtrabackup: cd to/data/backups/mysql/full_incre_20150319 xtrabackup: This target seems to be alreadyprepared. xtrabackup: xtrabackup_logfile detected:size=2097152, start_lsn=(423931610) xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir =/data/backups/mysql/incre_20150321 xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup: Generating a list oftablespaces xtrabackup: page size for/data/backups/mysql/incre_20150321/IBdata2.delta is 16384 bytes Applying /data/backups/mysql/incre_20150321/IBdata2.deltato ./IBdata2... xtrabackup: page size for/data/backups/mysql/incre_20150321/IBdata1.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/IBdata1.delta to ./IBdata1... xtrabackup: page size for /data/backups/mysql/incre_20150321/mysql/slave_worker_info.ibd.deltais 16384 bytes Applying/data/backups/mysql/incre_20150321/mysql/slave_worker_info.ibd.delta to./mysql/slave_worker_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/mysql/innodb_table_stats.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150321/mysql/innodb_table_stats.ibd.delta to./mysql/innodb_table_stats.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/mysql/innodb_index_stats.ibd.delta is 16384bytes Applying/data/backups/mysql/incre_20150321/mysql/innodb_index_stats.ibd.delta to./mysql/innodb_index_stats.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.delta is16384 bytes Applying/data/backups/mysql/incre_20150321/mysql/slave_relay_log_info.ibd.delta to./mysql/slave_relay_log_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/mysql/slave_master_info.ibd.delta is 16384bytes Applying /data/backups/mysql/incre_20150321/mysql/slave_master_info.ibd.deltato ./mysql/slave_master_info.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest4.ibd.delta to./sbtest/sbtest4.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest3.ibd.delta to./sbtest/sbtest3.ibd... xtrabackup: page size for /data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.deltais 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest1.ibd.delta to./sbtest/sbtest1.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest7.ibd.delta to./sbtest/sbtest7.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest6.ibd.delta to./sbtest/sbtest6.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest8.ibd.delta to./sbtest/sbtest8.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest2.ibd.delta to./sbtest/sbtest2.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/sbtest/sbtest5.ibd.delta to./sbtest/sbtest5.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/test/t3.ibd.delta is 16384 bytes Applying /data/backups/mysql/incre_20150321/test/t3.ibd.deltato ./test/t3.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/test/t_incre_2.ibd.delta to./test/t_incre_2.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/test/t.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/test/t.ibd.delta to ./test/t.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/test/t4.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/test/t4.ibd.delta to ./test/t4.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/test/t1.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/test/t1.ibd.delta to ./test/t1.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/t3.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/t3.ibd.delta to ./user_db/t3.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/t.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/t.ibd.delta to ./user_db/t.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/test2.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/test2.ibd.delta to./user_db/test2.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/test.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/test.ibd.delta to./user_db/test.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/t1.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/t1.ibd.delta to ./user_db/t1.ibd... xtrabackup: page size for/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.delta is 16384 bytes Applying/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.delta to./user_db/UC_USER.ibd... xtrabackup: using the following InnoDBconfiguration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend xtrabackup: innodb_log_group_home_dir =/data/backups/mysql/incre_20150321 xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup: Starting InnoDB instance forrecovery. xtrabackup: Using 104857600 bytes forbuffer pool (set by --use-memory parameter) InnoDB: Using atomics to ref count bufferpool pages InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomicbuiltins InnoDB: Memory barrier is not used InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, size =100.0M InnoDB: Completed initialization of bufferpool InnoDB: Highest supported file format isBarracuda. InnoDB: The log sequence numbers 423925813and 423925813 in ibdata files do not match the log sequence number 423931610 inthe ib_logfiles! InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information fromthe .ibd files... InnoDB: Restoring possible half-writtendata pages InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053 [notice (again)] Ifyou use binary log and don't use any hack of group commit, thebinary log position seems to be: InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053 xtrabackup: starting shutdown withinnodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequencenumber 423931610 [root@data01 mysql]#
登入後複製
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 * from t4; +-----+---+ | a | b | +-----+---+ | aaa | 1 | | bbb | 2 | +-----+---+ 2 rows in set (0.05 sec) mysql> select * from t_incre_2; +----+---+ | a | b | +----+---+ | cc | 2 | | dd | 2 | +----+---+ 2 rows in set (0.06 sec) 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@data01 mysql]# more/tmp/innobackupex_full.log
InnoDB Backup Utility v1.5.1-xtrabackup;Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2,June 1991.
Get the latest version of PerconaXtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
150319 02:31:18 innobackupex: Connecting to MySQL server withDSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup;host=192.168.52.129'as 'backup' (using
password: YES).
150319 02:31:18 innobackupex: Connected to MySQL server
150319 02:31:18 innobackupex: Executing a version checkagainst the server...
150319 02:31:18 innobackupex: Done.
150319 02:31:18 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup runcompletes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using server version 5.6.12-log
innobackupex: Created backup directory/data/backups/mysql/innobackupex_full_20150319
150319 02:31:18 innobackupex: Starting ibbackup with command: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: Waiting for ibbackup(pid=13118) to suspend
innobackupex: Suspend file'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_suspended_2'
xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/data/mysql/data
xtrabackup: open files limit requested 0, setto 1024
xtrabackup: using the following InnoDBconfiguration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 67108864
>> log scanned up to (423920964)
xtrabackup: Generating a list oftablespaces
[01] Copying ./IBdata1 to/data/backups/mysql/innobackupex_full_20150319/IBdata1
>> log scanned up to (423920964)
[01] ...done
[01] Copying ./IBdata2 to/data/backups/mysql/innobackupex_full_20150319/IBdata2
>> log scanned up to (423920964)
>> log scanned up to (423920964)
[01] ...done
>> log scanned up to (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.ibd to/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.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest1.ibd
[01] ...done
[01] Copying ./sbtest/sbtest5.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest5.ibd
[01] ...done
[01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest8.ibd
[01] ...done
[01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest4.ibd
[01] ...done
[01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest2.ibd
[01] ...done
[01] Copying ./sbtest/sbtest6.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest6.ibd
[01] ...done
[01] Copying ./sbtest/sbtest7.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest7.ibd
[01] ...done
[01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/innobackupex_full_20150319/sbtest/sbtest3.ibd
[01] ...done
[01] Copying ./test/t1.ibd to/data/backups/mysql/innobackupex_full_20150319/test/t1.ibd
[01] ...done
[01] Copying ./test/t4.ibd to/data/backups/mysql/innobackupex_full_20150319/test/t4.ibd
[01] ...done
[01] Copying ./test/t3.ibd to/data/backups/mysql/innobackupex_full_20150319/test/t3.ibd
[01] ...done
[01] Copying ./test/t.ibd to /data/backups/mysql/innobackupex_full_20150319/test/t.ibd
[01] ...done
[01] Copying ./test/t_incre_2.ibd to/data/backups/mysql/innobackupex_full_20150319/test/t_incre_2.ibd
[01] ...done
[01] Copying ./user_db/t1.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/t1.ibd
[01] ...done
[01] Copying ./user_db/test.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/test.ibd
[01] ...done
[01] Copying ./user_db/test2.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/test2.ibd
[01] ...done
[01] Copying ./user_db/t3.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/t3.ibd
[01] ...done
[01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/UC_USER.ibd
>> log scanned up to (423920964)
[01] ...done
[01] Copying ./user_db/t.ibd to/data/backups/mysql/innobackupex_full_20150319/user_db/t.ibd
[01] ...done
xtrabackup: Creating suspend file'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_suspended_2' withpid '13118'
150319 02:31:24 innobackupex: Continuing after ibbackup hassuspended
150319 02:31:24 innobackupex: Executing FLUSH TABLES WITHREAD LOCK...
150319 02:31:24 innobackupex: All tables locked and flushedto disk
150319 02:31:24 innobackupex: Starting to backup non-InnoDBtables and files
innobackupex: in subdirectories of'/home/data/mysql/data/'
innobackupex: Backing up files'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53 files)
>> log scanned up to (423920964)
innobackupex: Backing up files'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74 files)
>> log scanned up to (423920964)
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest3.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest4.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest6.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest8.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest1.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest2.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest7.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest5.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t_incre_2.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t4.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t1.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/UC_USER.frm'
innobackupex: Backing up file '/home/data/mysql/data//user_db/t.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test2.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t1.frm'
150319 02:31:26 innobackupex: Finished backing up non-InnoDBtables and files
150319 02:31:26 innobackupex: Executing FLUSHNO_WRITE_TO_BINLOG ENGINE LOGS...
150319 02:31:26 innobackupex: Waiting for log copying tofinish
>> log scanned up to (423920964)
xtrabackup: The latest check point (forincremental): '423920964'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (423920964)
xtrabackup: Creating suspend file'/data/backups/mysql/innobackupex_full_20150319/xtrabackup_log_copied' with pid'13118'
xtrabackup: Transaction log of lsn(423920964) to (423920964) was copied.
150319 02:31:27 innobackupex: All tables unlocked
innobackupex: Backup created in directory'/data/backups/mysql/innobackupex_full_20150319'
innobackupex: MySQL binlog position:filename 'mysql-bin.000066', position 120
150319 02:31:27 innobackupex: Connection to database serverclosed
150319 02:31:27 innobackupex: completed OK!
[root@data01 mysql]#
登入後複製
6，innobackupex做增量备份
6.1做第一次增量备份
先录入增量数据
mysql> create table incre1 select'incre1 table ' as incre1, 'a' as id; Query OK, 1 row affected (0.06 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> select * from incre1; +---------------+----+ | incre1 | id | +---------------+----+ | incre1 table | a | +---------------+----+ 1 row in set (0.00 sec) 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@data01 mysql]# more/tmp/innobackex_incre_1.log
InnoDB Backup Utility v1.5.1-xtrabackup;Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2,June 1991.
Get the latest version of PerconaXtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
150319 02:38:04 innobackupex: Connecting to MySQL server withDSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.52.129' as'backup' (using password: YES).
150319 02:38:04 innobackupex: Connected to MySQL server
150319 02:38:04 innobackupex: Executing a version checkagainst the server...
150319 02:38:04 innobackupex: Done.
150319 02:38:04 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup runcompletes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using server version 5.6.12-log
innobackupex: Created backup directory/data/backups/mysql/innobackex_incre_1
150319 02:38:04 innobackupex: Starting ibbackup with command:xtrabackup --defaults-group="mysqld" --backup --suspend-at-end--target-dir=/data/backups/mysql/innobackex_incre_1 --tmpdir=/tm
p --extra-lsndir='/tmp'--incremental-basedir='/data/backups/mysql/innobackupex_full_20150319/'
innobackupex: Waiting for ibbackup(pid=13358) to suspend
innobackupex: Suspend file'/data/backups/mysql/innobackex_incre_1/xtrabackup_suspended_2'
xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: )
incremental backup from 423920964 isenabled.
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/data/mysql/data
xtrabackup: open files limit requested 0,set to 1024
xtrabackup: using the following InnoDBconfiguration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 67108864
>> log scanned up to (423925361)
xtrabackup: Generating a list oftablespaces
xtrabackup: using the full scan forincremental backup
>> log scanned up to (423925361)
>> log scanned up to (423925361)
>> log scanned up to (423925361)
>> log scanned up to (423925361)
[01] Copying ./IBdata1 to/data/backups/mysql/innobackex_incre_1/IBdata1.delta
>> log scanned up to (423925361)
[01] ...done
>> log scanned up to (423925361)
[01] Copying ./IBdata2 to /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.ibd to /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
>> log scanned up to (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.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest1.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest5.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest5.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest8.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest4.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest2.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest6.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest6.ibd.delta
[01] ...done
>> log scanned up to (423925361)
[01] Copying ./sbtest/sbtest7.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest7.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/innobackex_incre_1/sbtest/sbtest3.ibd.delta
[01] ...done
[01] Copying ./test/t1.ibd to/data/backups/mysql/innobackex_incre_1/test/t1.ibd.delta
[01] ...done
[01] Copying ./test/t4.ibd to/data/backups/mysql/innobackex_incre_1/test/t4.ibd.delta
[01] ...done
[01] Copying ./test/incre1.ibd to/data/backups/mysql/innobackex_incre_1/test/incre1.ibd.delta
[01] ...done
[01] Copying ./test/t3.ibd to/data/backups/mysql/innobackex_incre_1/test/t3.ibd.delta
[01] ...done
[01] Copying ./test/t.ibd to/data/backups/mysql/innobackex_incre_1/test/t.ibd.delta
[01] ...done
[01] Copying ./test/t_incre_2.ibd to/data/backups/mysql/innobackex_incre_1/test/t_incre_2.ibd.delta
[01] ...done
[01] Copying ./user_db/t1.ibd to/data/backups/mysql/innobackex_incre_1/user_db/t1.ibd.delta
[01] ...done
[01] Copying ./user_db/test.ibd to/data/backups/mysql/innobackex_incre_1/user_db/test.ibd.delta
[01] ...done
[01] Copying ./user_db/test2.ibd to/data/backups/mysql/innobackex_incre_1/user_db/test2.ibd.delta
[01] ...done
[01] Copying ./user_db/t3.ibd to/data/backups/mysql/innobackex_incre_1/user_db/t3.ibd.delta
[01] ...done
[01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/innobackex_incre_1/user_db/UC_USER.ibd.delta
[01] ...done
[01] Copying ./user_db/t.ibd to/data/backups/mysql/innobackex_incre_1/user_db/t.ibd.delta
[01] ...done
>> log scanned up to (423925361)
xtrabackup: Creating suspend file'/data/backups/mysql/innobackex_incre_1/xtrabackup_suspended_2' with pid'13358'
>> log scanned up to (423925361)
150319 02:38:15 innobackupex: Continuing after ibbackup hassuspended
150319 02:38:15 innobackupex: Executing FLUSH TABLES WITHREAD LOCK...
150319 02:38:15 innobackupex: All tables locked and flushedto disk
150319 02:38:15 innobackupex: Starting to backup non-InnoDBtables and files
innobackupex: in subdirectories of'/home/data/mysql/data/'
innobackupex: Backing up files'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53 files)
>> log scanned up to (423925361)
innobackupex: Backing up files'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74 files)
>> log scanned up to (423925361)
innobackupex: Backing up file '/home/data/mysql/data//sbtest/sbtest3.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest4.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest6.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest8.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest1.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest2.frm'
innobackupex: Backing up file '/home/data/mysql/data//sbtest/sbtest7.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest5.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t_incre_2.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t4.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/incre1.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t1.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/UC_USER.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test2.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t1.frm'
150319 02:38:17 innobackupex: Finished backing up non-InnoDBtables and files
150319 02:38:17 innobackupex: Executing FLUSHNO_WRITE_TO_BINLOG ENGINE LOGS...
150319 02:38:17 innobackupex: Waiting for log copying tofinish
xtrabackup: The latest check point (forincremental): '423925361'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (423925361)
xtrabackup: Creating suspend file'/data/backups/mysql/innobackex_incre_1/xtrabackup_log_copied' with pid '13358'
xtrabackup: Transaction log of lsn(423925361) to (423925361) was copied.
150319 02:38:18 innobackupex: All tables unlocked
innobackupex: Backup created in directory'/data/backups/mysql/innobackex_incre_1'
innobackupex: MySQL binlog position:filename 'mysql-bin.000066', position 120
150319 02:38:18 innobackupex: Connection to database server closed
150319 02:38:18 innobackupex: completed OK!
[root@data01 mysql]#
登入後複製
6.2 基于全备和第一个增量备份来做第二次增量备份
先录入增量数据录入
mysql> create table incre2 select'incre2' as a,3 as id; Query OK, 1 row affected (0.12 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> mysql> select * from incre2; +--------+----+ | a | id | +--------+----+ | incre2 | 3 | +--------+----+ 1 row in set (0.00 sec) 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@data01 innobackex_incre_1]# more/tmp/innobackex_incre_2.log
InnoDB Backup Utility v1.5.1-xtrabackup;Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2,June 1991.
Get the latest version of PerconaXtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
150319 02:51:09 innobackupex: Connecting to MySQL server withDSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.52.129' as'backup' (using password: YES).
150319 02:51:09 innobackupex: Connected to MySQL server
150319 02:51:09 innobackupex: Executing a version checkagainst the server...
150319 02:51:09 innobackupex: Done.
150319 02:51:09 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup runcompletes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using server version 5.6.12-log
innobackupex: Created backup directory/data/backups/mysql/innobackex_incre_2
150319 02:51:10 innobackupex: Starting ibbackup with command:xtrabackup --defaults-group="mysqld" --backup --suspend-at-end--target-dir=/data/backups/mysql/innobackex_incre_2 --tmpdir=/tm
p --extra-lsndir='/tmp'--incremental-basedir='/data/backups/mysql/innobackex_incre_1/'
innobackupex: Waiting for ibbackup(pid=13694) to suspend
innobackupex: Suspend file'/data/backups/mysql/innobackex_incre_2/xtrabackup_suspended_2'
xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: )
incremental backup from 423925361 isenabled.
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/data/mysql/data
xtrabackup: open files limit requested 0,set to 1024
xtrabackup: using the following InnoDBconfiguration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 67108864
>> log scanned up to (423929601)
xtrabackup: Generating a list oftablespaces
xtrabackup: using the full scan forincremental backup
>> log scanned up to (423929601)
[01] Copying ./IBdata1 to/data/backups/mysql/innobackex_incre_2/IBdata1.delta
>> log scanned up to (423929601)
[01] ...done
[01] Copying ./IBdata2 to/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
>> log scanned up to (423929601)
[01] Copying./mysql/slave_relay_log_info.ibd to/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.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest1.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest5.ibd to /data/backups/mysql/innobackex_incre_2/sbtest/sbtest5.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest8.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest8.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest4.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest4.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest2.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest2.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest6.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest6.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest7.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest7.ibd.delta
[01] ...done
[01] Copying ./sbtest/sbtest3.ibd to/data/backups/mysql/innobackex_incre_2/sbtest/sbtest3.ibd.delta
[01] ...done
[01] Copying ./test/incre2.ibd to/data/backups/mysql/innobackex_incre_2/test/incre2.ibd.delta
[01] ...done
[01] Copying ./test/t1.ibd to/data/backups/mysql/innobackex_incre_2/test/t1.ibd.delta
[01] ...done
[01] Copying ./test/t4.ibd to/data/backups/mysql/innobackex_incre_2/test/t4.ibd.delta
[01] ...done
[01] Copying ./test/incre1.ibd to/data/backups/mysql/innobackex_incre_2/test/incre1.ibd.delta
[01] ...done
[01] Copying ./test/t3.ibd to/data/backups/mysql/innobackex_incre_2/test/t3.ibd.delta
[01] ...done
>> log scanned up to (423929601)
[01] Copying ./test/t.ibd to/data/backups/mysql/innobackex_incre_2/test/t.ibd.delta
[01] ...done
[01] Copying ./test/t_incre_2.ibd to /data/backups/mysql/innobackex_incre_2/test/t_incre_2.ibd.delta
[01] ...done
[01] Copying ./user_db/t1.ibd to/data/backups/mysql/innobackex_incre_2/user_db/t1.ibd.delta
[01] ...done
[01] Copying ./user_db/test.ibd to /data/backups/mysql/innobackex_incre_2/user_db/test.ibd.delta
[01] ...done
[01] Copying ./user_db/test2.ibd to/data/backups/mysql/innobackex_incre_2/user_db/test2.ibd.delta
[01] ...done
[01] Copying ./user_db/t3.ibd to/data/backups/mysql/innobackex_incre_2/user_db/t3.ibd.delta
[01] ...done
[01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/innobackex_incre_2/user_db/UC_USER.ibd.delta
[01] ...done
[01] Copying ./user_db/t.ibd to/data/backups/mysql/innobackex_incre_2/user_db/t.ibd.delta
[01] ...done
>> log scanned up to (423929601)
xtrabackup: Creating suspend file'/data/backups/mysql/innobackex_incre_2/xtrabackup_suspended_2' with pid'13694'
150319 02:51:16 innobackupex: Continuing after ibbackup hassuspended
150319 02:51:16 innobackupex: Executing FLUSH TABLES WITHREAD LOCK...
150319 02:51:16 innobackupex: All tables locked and flushedto disk
150319 02:51:16 innobackupex: Starting to backup non-InnoDBtables and files
innobackupex: in subdirectories of '/home/data/mysql/data/'
innobackupex: Backing up files'/home/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(53 files)
>> log scanned up to (423929601)
innobackupex: Backing up files'/home/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(74 files)
>> log scanned up to (423929601)
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest3.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest4.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest6.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest8.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest1.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest2.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest7.frm'
innobackupex: Backing up file'/home/data/mysql/data//sbtest/sbtest5.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t_incre_2.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t4.frm'
innobackupex: Backing up file '/home/data/mysql/data//test/incre2.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/incre1.frm'
innobackupex: Backing up file'/home/data/mysql/data//test/t1.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/UC_USER.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t3.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/db.opt'
innobackupex: Backing up file'/home/data/mysql/data//user_db/test2.frm'
innobackupex: Backing up file'/home/data/mysql/data//user_db/t1.frm'
150319 02:51:17 innobackupex: Finished backing up non-InnoDBtables and files
150319 02:51:17 innobackupex: Executing FLUSHNO_WRITE_TO_BINLOG ENGINE LOGS...
150319 02:51:17 innobackupex: Waiting for log copying tofinish
xtrabackup: The latest check point (forincremental): '423929601'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (423929601)
xtrabackup: Creating suspend file'/data/backups/mysql/innobackex_incre_2/xtrabackup_log_copied' with pid '13694'
xtrabackup: Transaction log of lsn(423929601) to (423929601) was copied.
150319 02:51:18 innobackupex: All tables unlocked
innobackupex: Backup created in directory'/data/backups/mysql/innobackex_incre_2'
innobackupex: MySQL binlog position:filename 'mysql-bin.000066', position 120
150319 02:51:19 innobackupex: Connection to database serverclosed
150319 02:51:19 innobackupex: completed OK!
登入後複製
7，innobackupex做增量恢复
7.1先删除两次增量数据，用来查看验证恢复结果
mysql> delete from incre1; Query OK, 1 row affected (0.05 sec) mysql> delete from incre2; Query OK, 1 row affected (0.01 sec) mysql> select * from incre1; Empty set (0.00 sec) mysql> select * from incre2; Empty set (0.00 sec)
登入後複製
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: Last MySQL binlog file position 0915, file name mysql-bin.000053 xtrabackup: st
登入後複製
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
AI Hentai Generator
免費產生 AI 無盡。
熱門文章
R.E.P.O.能量晶體解釋及其做什麼（黃色晶體）
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳圖形設置
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
刺客信條陰影：貝殼謎語解決方案
2 週前
By DDD
R.E.P.O.如果您聽不到任何人，如何修復音頻
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解鎖Myrise中的所有內容
4 週前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
熱門話題
如何備份谷歌瀏覽器的擴充程序
Jan 30, 2024 pm 12:36 PM
谷歌瀏覽器擴充功能如何備份？對於大多數Google瀏覽器用戶來說，日常使用時會安裝或多或少的插件，插件的存在可以提升我們的使用體驗。當我們重裝系統或瀏覽器時，這些插件卻無法保留，重新下載安裝又比較麻煩，那麼有沒有辦法備份目前已安裝的插件呢？下面就為大家帶來操作方法。備份chrome插件的教學方法先打開Google瀏覽器，點擊右上角的選單，選擇更多工具－擴充功能。點擊擴充功能頁面上方的打包擴充功能。在C:UsersAdministratorAppDataLocalGoogleChromeUserDataDe
如何在Windows 11的檔案總管中刪除啟動備份
Feb 18, 2024 pm 05:40 PM
如果您希望在Windows11的檔案總管中隱藏「開始備份」選項，以下是您可以採取的方法。有多種途徑可用於在檔案總管中停用或隱藏啟動備份選項，我們將簡要列出一些方法，以幫助您快速完成此任務。在開始之前，您需要了解這個選項與OneDrive密切相關。一旦您開啟某個庫資料夾（例如Document、Pictures、Music等），它會立即顯示在檔案總管的路徑中。如何在Windows11的檔案總管中刪除啟動備份要在Windows11的檔案總管中刪除啟動備份，請依照下列方法操
如何在 PHP 中使用 MySQL 備份和還原？
Jun 03, 2024 pm 12:19 PM
在PHP中備份和還原MySQL資料庫可透過以下步驟實現：備份資料庫：使用mysqldump指令轉儲資料庫為SQL檔。還原資料庫：使用mysql指令從SQL檔案還原資料庫。
hosts檔案刪了怎麼恢復
Feb 22, 2024 pm 10:48 PM
標題：hosts檔案刪除後如何恢復摘要：hosts檔案是作業系統中非常重要的一個文件，用於將網域名稱對應到IP位址。如果不小心將hosts檔案刪除了，可能會導致上網無法存取特定網站或其他網路問題。本文將介紹如何在Windows和Mac作業系統中復原被誤刪的hosts檔案。內文：一、Windows作業系統中恢復hosts檔案Windows作業系統中的hosts文
ghost怎麼備份系統-ghost備份教學
Mar 06, 2024 pm 04:30 PM
近期有很多小夥伴諮詢小編ghost怎麼備份系統，接下來就讓我們一起學習ghost備份系統的方法教程，希望可以幫助大家。 1、運行Ghost後，點選“OK”，如圖所示。 2.依序點選「Local」→「Partition」→「ToImage」(意為：本地→分割區→到鏡像檔)，如圖所示。 3.出現選擇本機硬碟窗口，點選要備份的分割區所在硬碟，再點選“OK”，如圖所示。 4.出現選擇來源分割區視窗(來源分割區就是你要備份的那個分割區)，點選系統所在的分割區(通常為1區，一定要弄準)，再點選“OK”，如圖所示。 5.此時彈
如何安裝、解除安裝、重設Windows伺服器備份
Mar 06, 2024 am 10:37 AM
WindowsServerBackup是WindowsServer作業系統自帶的功能，旨在協助使用者保護重要資料和系統配置，並為中小型和企業級企業提供完整的備份和復原解決方案。只有執行Server2022及更高版本的使用者才能使用此功能。在本文中，我們將介紹如何安裝、解除安裝或重設WindowsServerBackup。如何重置Windows伺服器備份如果您的伺服器備份遇到問題，備份所需時間過長，或無法存取已儲存的文件，那麼您可以考慮重新設定WindowsServer備份設定。要重設Windows
如何在麒麟作業系統上進行系統備份與還原？
Aug 07, 2023 pm 02:22 PM
如何在麒麟作業系統上進行系統備份與還原？麒麟作業系統是中國自主研發的開源作業系統，廣泛應用於各種場景。在使用麒麟作業系統時，系統備份和復原是非常重要的任務。備份系統可防止因故障或誤操作而導致資料遺失，而係統復原則可在系統崩潰時快速還原正常功能。本文將詳細介紹如何在麒麟作業系統上進行系統備份和恢復，並附上相關程式碼範例。備份系統為了備份整個系統，我們可以
GitLab的程式庫備份與復原功能及實作步驟
Oct 20, 2023 pm 12:04 PM
GitLab是一個開源的程式碼託管平台，提供了豐富的功能，包括程式碼庫備份和還原。程式碼庫備份是確保程式碼安全的重要步驟之一，它可以幫助我們在發生意外情況時恢復資料。本文將介紹GitLab的程式碼庫備份和復原功能，並提供對應的實作步驟和程式碼範例。 GitLab的程式碼庫備份功能GitLab提供了兩種類型的備份：增量備份和全量備份。增量備份：增量備份是指只備份最新變更的數據
