1、测试过程
[root@rec lib]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> drop database full; Query OK, 1 row affected (0.31 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) MariaDB [(none)]> create database full charset=utf8; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> create table full.incr(id int not null auto_increment primary key,tag varchar(256)) charset=utf8; Query OK, 0 rows affected (0.02 sec) MariaDB [(none)]> show table from full; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from full' at line 1 MariaDB [(none)]> show tables from full; +----------------+ | Tables_in_full | +----------------+ | incr | +----------------+ 1 row in set (0.00 sec) MariaDB [(none)]> select * from full.incr; Empty set (0.00 sec) MariaDB [(none)]> exit Bye [root@rec lib]# cd /tmp/ [root@rec tmp]# ll 总用量 4 drwxr-x---. 3 root root 33 8月 26 14:17 fullbak drwxr-x---. 5 root root 45 8月 26 14:21 incr -rw-r--r--. 1 root root 57 8月 26 14:17 percona-version-check [root@rec tmp]# rm /tmp/* -fr [root@rec tmp]# ll 总用量 0 [root@rec tmp]# innobackupex --user=root --no-timestamp /tmp/fullbak xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin xtrabackup: recognized client arguments: 190826 14:31:20 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 190826 14:31:20 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO). 190826 14:31:20 version_check Connected to MySQL server 190826 14:31:20 version_check Executing a version check against the server... 190826 14:31:20 version_check Done. 190826 14:31:20 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Using server version 10.2.26-MariaDB-log innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 190826 14:31:20 >> log scanned up to (1648472) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 190826 14:31:20 [01] Copying ./ibdata1 to /tmp/fullbak/ibdata1 190826 14:31:20 [01] ...done 190826 14:31:21 >> log scanned up to (1648472) 190826 14:31:21 [01] Copying ./mysql/innodb_table_stats.ibd to /tmp/fullbak/mysql/innodb_table_stats.ibd 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/innodb_index_stats.ibd to /tmp/fullbak/mysql/innodb_index_stats.ibd 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/gtid_slave_pos.ibd to /tmp/fullbak/mysql/gtid_slave_pos.ibd 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./full/incr.ibd to /tmp/fullbak/full/incr.ibd 190826 14:31:21 [01] ...done 190826 14:31:21 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 190826 14:31:21 Executing FLUSH TABLES WITH READ LOCK... 190826 14:31:21 Starting to backup non-InnoDB tables and files 190826 14:31:21 [01] Copying ./mysql/db.opt to /tmp/fullbak/mysql/db.opt 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/db.frm to /tmp/fullbak/mysql/db.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/db.MYI to /tmp/fullbak/mysql/db.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/db.MYD to /tmp/fullbak/mysql/db.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/host.frm to /tmp/fullbak/mysql/host.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/host.MYI to /tmp/fullbak/mysql/host.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/host.MYD to /tmp/fullbak/mysql/host.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/user.frm to /tmp/fullbak/mysql/user.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/user.MYI to /tmp/fullbak/mysql/user.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/user.MYD to /tmp/fullbak/mysql/user.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/roles_mapping.frm to /tmp/fullbak/mysql/roles_mapping.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/roles_mapping.MYI to /tmp/fullbak/mysql/roles_mapping.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/roles_mapping.MYD to /tmp/fullbak/mysql/roles_mapping.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/func.frm to /tmp/fullbak/mysql/func.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/func.MYI to /tmp/fullbak/mysql/func.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/func.MYD to /tmp/fullbak/mysql/func.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/plugin.frm to /tmp/fullbak/mysql/plugin.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/plugin.MYI to /tmp/fullbak/mysql/plugin.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/plugin.MYD to /tmp/fullbak/mysql/plugin.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/servers.frm to /tmp/fullbak/mysql/servers.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/servers.MYI to /tmp/fullbak/mysql/servers.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/servers.MYD to /tmp/fullbak/mysql/servers.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/tables_priv.frm to /tmp/fullbak/mysql/tables_priv.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/tables_priv.MYI to /tmp/fullbak/mysql/tables_priv.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/tables_priv.MYD to /tmp/fullbak/mysql/tables_priv.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/columns_priv.frm to /tmp/fullbak/mysql/columns_priv.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/columns_priv.MYI to /tmp/fullbak/mysql/columns_priv.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/columns_priv.MYD to /tmp/fullbak/mysql/columns_priv.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_topic.frm to /tmp/fullbak/mysql/help_topic.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_topic.MYI to /tmp/fullbak/mysql/help_topic.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_topic.MYD to /tmp/fullbak/mysql/help_topic.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_category.frm to /tmp/fullbak/mysql/help_category.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_category.MYI to /tmp/fullbak/mysql/help_category.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_category.MYD to /tmp/fullbak/mysql/help_category.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_relation.frm to /tmp/fullbak/mysql/help_relation.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_relation.MYI to /tmp/fullbak/mysql/help_relation.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_relation.MYD to /tmp/fullbak/mysql/help_relation.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_keyword.frm to /tmp/fullbak/mysql/help_keyword.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_keyword.MYI to /tmp/fullbak/mysql/help_keyword.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/help_keyword.MYD to /tmp/fullbak/mysql/help_keyword.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_name.frm to /tmp/fullbak/mysql/time_zone_name.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_name.MYI to /tmp/fullbak/mysql/time_zone_name.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_name.MYD to /tmp/fullbak/mysql/time_zone_name.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone.frm to /tmp/fullbak/mysql/time_zone.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone.MYI to /tmp/fullbak/mysql/time_zone.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone.MYD to /tmp/fullbak/mysql/time_zone.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition.frm to /tmp/fullbak/mysql/time_zone_transition.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/fullbak/mysql/time_zone_transition.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/fullbak/mysql/time_zone_transition.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/fullbak/mysql/time_zone_transition_type.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/fullbak/mysql/time_zone_transition_type.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/fullbak/mysql/time_zone_transition_type.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/fullbak/mysql/time_zone_leap_second.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/fullbak/mysql/time_zone_leap_second.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/fullbak/mysql/time_zone_leap_second.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proc.frm to /tmp/fullbak/mysql/proc.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proc.MYI to /tmp/fullbak/mysql/proc.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proc.MYD to /tmp/fullbak/mysql/proc.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/procs_priv.frm to /tmp/fullbak/mysql/procs_priv.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/procs_priv.MYI to /tmp/fullbak/mysql/procs_priv.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/procs_priv.MYD to /tmp/fullbak/mysql/procs_priv.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/general_log.frm to /tmp/fullbak/mysql/general_log.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/general_log.CSM to /tmp/fullbak/mysql/general_log.CSM 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/general_log.CSV to /tmp/fullbak/mysql/general_log.CSV 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/slow_log.frm to /tmp/fullbak/mysql/slow_log.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/slow_log.CSM to /tmp/fullbak/mysql/slow_log.CSM 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/slow_log.CSV to /tmp/fullbak/mysql/slow_log.CSV 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/event.frm to /tmp/fullbak/mysql/event.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/event.MYI to /tmp/fullbak/mysql/event.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/event.MYD to /tmp/fullbak/mysql/event.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/fullbak/mysql/innodb_table_stats.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/fullbak/mysql/innodb_index_stats.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proxies_priv.frm to /tmp/fullbak/mysql/proxies_priv.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proxies_priv.MYI to /tmp/fullbak/mysql/proxies_priv.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/proxies_priv.MYD to /tmp/fullbak/mysql/proxies_priv.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/table_stats.frm to /tmp/fullbak/mysql/table_stats.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/table_stats.MYI to /tmp/fullbak/mysql/table_stats.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/table_stats.MYD to /tmp/fullbak/mysql/table_stats.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/column_stats.frm to /tmp/fullbak/mysql/column_stats.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/column_stats.MYI to /tmp/fullbak/mysql/column_stats.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/column_stats.MYD to /tmp/fullbak/mysql/column_stats.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/index_stats.frm to /tmp/fullbak/mysql/index_stats.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/index_stats.MYI to /tmp/fullbak/mysql/index_stats.MYI 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/index_stats.MYD to /tmp/fullbak/mysql/index_stats.MYD 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/fullbak/mysql/gtid_slave_pos.frm 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./test/db.opt to /tmp/fullbak/test/db.opt 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./performance_schema/db.opt to /tmp/fullbak/performance_schema/db.opt 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./full/db.opt to /tmp/fullbak/full/db.opt 190826 14:31:21 [01] ...done 190826 14:31:21 [01] Copying ./full/incr.frm to /tmp/fullbak/full/incr.frm 190826 14:31:21 [01] ...done 190826 14:31:21 Finished backing up non-InnoDB tables and files 190826 14:31:21 [00] Writing /tmp/fullbak/xtrabackup_binlog_info 190826 14:31:21 [00] ...done 190826 14:31:21 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1648463' xtrabackup: Stopping log copying thread. .190826 14:31:21 >> log scanned up to (1648472) 190826 14:31:22 Executing UNLOCK TABLES 190826 14:31:22 All tables unlocked 190826 14:31:22 [00] Copying ib_buffer_pool to /tmp/fullbak/ib_buffer_pool 190826 14:31:22 [00] ...done 190826 14:31:22 Backup created in directory '/tmp/fullbak/' MySQL binlog position: filename 'mysqlbin.000001', position '797', GTID of the last change '0-1-3' 190826 14:31:22 [00] Writing /tmp/fullbak/backup-my.cnf 190826 14:31:22 [00] ...done 190826 14:31:22 [00] Writing /tmp/fullbak/xtrabackup_info 190826 14:31:22 [00] ...done xtrabackup: Transaction log of lsn (1648463) to (1648472) was copied. 190826 14:31:22 completed OK! [root@rec tmp]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 14 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> insert into full.incr(tag) values("第1次增备后"); Query OK, 1 row affected (0.30 sec) MariaDB [(none)]> exit Bye [root@rec tmp]# innobackupex --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/fullbak/ --incremental /tmp/incr/incr1 xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:32:45 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 190826 14:32:46 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO). 190826 14:32:46 version_check Connected to MySQL server 190826 14:32:46 version_check Executing a version check against the server... 190826 14:32:46 version_check Done. 190826 14:32:46 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Using server version 10.2.26-MariaDB-log innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1648463 is enabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 190826 14:32:46 >> log scanned up to (1648883) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: using the full scan for incremental backup xtrabackup: Starting 4 threads for parallel data files transfer 190826 14:32:46 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr1/mysql/innodb_index_stats.ibd.delta 190826 14:32:46 [03] ...done 190826 14:32:46 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr1/mysql/gtid_slave_pos.ibd.delta 190826 14:32:46 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr1/mysql/innodb_table_stats.ibd.delta 190826 14:32:46 [02] ...done 190826 14:32:46 [04] ...done 190826 14:32:46 [01] Copying ./ibdata1 to /tmp/incr/incr1/ibdata1.delta 190826 14:32:46 [03] Copying ./full/incr.ibd to /tmp/incr/incr1/full/incr.ibd.delta 190826 14:32:46 [03] ...done 190826 14:32:46 [01] ...done 190826 14:32:47 >> log scanned up to (1648883) 190826 14:32:47 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 190826 14:32:47 Executing FLUSH TABLES WITH READ LOCK... 190826 14:32:47 Starting to backup non-InnoDB tables and files 190826 14:32:47 [01] Copying ./mysql/db.opt to /tmp/incr/incr1/mysql/db.opt 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/db.frm to /tmp/incr/incr1/mysql/db.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/db.MYI to /tmp/incr/incr1/mysql/db.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/db.MYD to /tmp/incr/incr1/mysql/db.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/host.frm to /tmp/incr/incr1/mysql/host.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/host.MYI to /tmp/incr/incr1/mysql/host.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/host.MYD to /tmp/incr/incr1/mysql/host.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/user.frm to /tmp/incr/incr1/mysql/user.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/user.MYI to /tmp/incr/incr1/mysql/user.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/user.MYD to /tmp/incr/incr1/mysql/user.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr1/mysql/roles_mapping.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr1/mysql/roles_mapping.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr1/mysql/roles_mapping.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/func.frm to /tmp/incr/incr1/mysql/func.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/func.MYI to /tmp/incr/incr1/mysql/func.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/func.MYD to /tmp/incr/incr1/mysql/func.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr1/mysql/plugin.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr1/mysql/plugin.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr1/mysql/plugin.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/servers.frm to /tmp/incr/incr1/mysql/servers.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr1/mysql/servers.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr1/mysql/servers.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr1/mysql/tables_priv.frm 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr1/mysql/tables_priv.MYI 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr1/mysql/tables_priv.MYD 190826 14:32:47 [01] ...done 190826 14:32:47 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr1/mysql/columns_priv.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr1/mysql/columns_priv.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr1/mysql/columns_priv.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr1/mysql/help_topic.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr1/mysql/help_topic.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr1/mysql/help_topic.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr1/mysql/help_category.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr1/mysql/help_category.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr1/mysql/help_category.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr1/mysql/help_relation.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr1/mysql/help_relation.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr1/mysql/help_relation.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr1/mysql/help_keyword.frm 190826 14:32:48 >> log scanned up to (1648883) 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr1/mysql/help_keyword.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr1/mysql/help_keyword.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr1/mysql/time_zone_name.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr1/mysql/time_zone_name.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr1/mysql/time_zone_name.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr1/mysql/time_zone.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr1/mysql/time_zone.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr1/mysql/time_zone.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr1/mysql/time_zone_transition.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr1/mysql/time_zone_transition.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr1/mysql/time_zone_transition.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr1/mysql/time_zone_transition_type.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr1/mysql/time_zone_transition_type.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr1/mysql/time_zone_transition_type.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr1/mysql/time_zone_leap_second.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr1/mysql/time_zone_leap_second.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr1/mysql/time_zone_leap_second.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proc.frm to /tmp/incr/incr1/mysql/proc.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr1/mysql/proc.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr1/mysql/proc.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr1/mysql/procs_priv.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr1/mysql/procs_priv.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr1/mysql/procs_priv.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr1/mysql/general_log.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr1/mysql/general_log.CSM 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr1/mysql/general_log.CSV 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr1/mysql/slow_log.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr1/mysql/slow_log.CSM 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr1/mysql/slow_log.CSV 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/event.frm to /tmp/incr/incr1/mysql/event.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/event.MYI to /tmp/incr/incr1/mysql/event.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/event.MYD to /tmp/incr/incr1/mysql/event.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr1/mysql/innodb_table_stats.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr1/mysql/innodb_index_stats.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr1/mysql/proxies_priv.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr1/mysql/proxies_priv.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr1/mysql/proxies_priv.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr1/mysql/table_stats.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr1/mysql/table_stats.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr1/mysql/table_stats.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr1/mysql/column_stats.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr1/mysql/column_stats.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr1/mysql/column_stats.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr1/mysql/index_stats.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr1/mysql/index_stats.MYI 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr1/mysql/index_stats.MYD 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr1/mysql/gtid_slave_pos.frm 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./test/db.opt to /tmp/incr/incr1/test/db.opt 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr1/performance_schema/db.opt 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./full/db.opt to /tmp/incr/incr1/full/db.opt 190826 14:32:48 [01] ...done 190826 14:32:48 [01] Copying ./full/incr.frm to /tmp/incr/incr1/full/incr.frm 190826 14:32:48 [01] ...done 190826 14:32:48 Finished backing up non-InnoDB tables and files 190826 14:32:48 [00] Writing /tmp/incr/incr1/xtrabackup_binlog_info 190826 14:32:48 [00] ...done 190826 14:32:48 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1648874' xtrabackup: Stopping log copying thread. .190826 14:32:48 >> log scanned up to (1648883) 190826 14:32:48 Executing UNLOCK TABLES 190826 14:32:48 All tables unlocked 190826 14:32:48 [00] Copying ib_buffer_pool to /tmp/incr/incr1/ib_buffer_pool 190826 14:32:48 [00] ...done 190826 14:32:48 Backup created in directory '/tmp/incr/incr1/' MySQL binlog position: filename 'mysqlbin.000001', position '1018', GTID of the last change '0-1-4' 190826 14:32:48 [00] Writing /tmp/incr/incr1/backup-my.cnf 190826 14:32:48 [00] ...done 190826 14:32:48 [00] Writing /tmp/incr/incr1/xtrabackup_info 190826 14:32:48 [00] ...done xtrabackup: Transaction log of lsn (1648874) to (1648883) was copied. 190826 14:32:48 completed OK! [root@rec tmp]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 17 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> insert into full.incr(tag) values("第2次增备后"); Query OK, 1 row affected (0.01 sec) MariaDB [(none)]> exit Bye [root@rec tmp]# innobackupex --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/incr/incr1/ --incremental /tmp/incr/incr2 xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:33:33 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 190826 14:33:33 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO). 190826 14:33:33 version_check Connected to MySQL server 190826 14:33:33 version_check Executing a version check against the server... 190826 14:33:33 version_check Done. 190826 14:33:33 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Using server version 10.2.26-MariaDB-log innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1648874 is enabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 190826 14:33:33 >> log scanned up to (1649256) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: using the full scan for incremental backup xtrabackup: Starting 4 threads for parallel data files transfer 190826 14:33:34 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr2/mysql/gtid_slave_pos.ibd.delta 190826 14:33:34 [04] ...done 190826 14:33:34 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr2/mysql/innodb_index_stats.ibd.delta 190826 14:33:34 [03] ...done 190826 14:33:34 [01] Copying ./ibdata1 to /tmp/incr/incr2/ibdata1.delta 190826 14:33:34 [04] Copying ./full/incr.ibd to /tmp/incr/incr2/full/incr.ibd.delta 190826 14:33:34 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr2/mysql/innodb_table_stats.ibd.delta 190826 14:33:34 [02] ...done 190826 14:33:34 [04] ...done 190826 14:33:34 [01] ...done 190826 14:33:34 >> log scanned up to (1649256) 190826 14:33:35 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 190826 14:33:35 Executing FLUSH TABLES WITH READ LOCK... 190826 14:33:35 Starting to backup non-InnoDB tables and files 190826 14:33:35 [01] Copying ./mysql/db.opt to /tmp/incr/incr2/mysql/db.opt 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/db.frm to /tmp/incr/incr2/mysql/db.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/db.MYI to /tmp/incr/incr2/mysql/db.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/db.MYD to /tmp/incr/incr2/mysql/db.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/host.frm to /tmp/incr/incr2/mysql/host.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/host.MYI to /tmp/incr/incr2/mysql/host.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/host.MYD to /tmp/incr/incr2/mysql/host.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/user.frm to /tmp/incr/incr2/mysql/user.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/user.MYI to /tmp/incr/incr2/mysql/user.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/user.MYD to /tmp/incr/incr2/mysql/user.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr2/mysql/roles_mapping.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr2/mysql/roles_mapping.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr2/mysql/roles_mapping.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/func.frm to /tmp/incr/incr2/mysql/func.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/func.MYI to /tmp/incr/incr2/mysql/func.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/func.MYD to /tmp/incr/incr2/mysql/func.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr2/mysql/plugin.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr2/mysql/plugin.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr2/mysql/plugin.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/servers.frm to /tmp/incr/incr2/mysql/servers.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr2/mysql/servers.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr2/mysql/servers.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr2/mysql/tables_priv.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr2/mysql/tables_priv.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr2/mysql/tables_priv.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr2/mysql/columns_priv.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr2/mysql/columns_priv.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr2/mysql/columns_priv.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr2/mysql/help_topic.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr2/mysql/help_topic.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr2/mysql/help_topic.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr2/mysql/help_category.frm 190826 14:33:35 >> log scanned up to (1649256) 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr2/mysql/help_category.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr2/mysql/help_category.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr2/mysql/help_relation.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr2/mysql/help_relation.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr2/mysql/help_relation.MYD 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr2/mysql/help_keyword.frm 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr2/mysql/help_keyword.MYI 190826 14:33:35 [01] ...done 190826 14:33:35 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr2/mysql/help_keyword.MYD 190826 14:33:35 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr2/mysql/time_zone_name.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr2/mysql/time_zone_name.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr2/mysql/time_zone_name.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr2/mysql/time_zone.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr2/mysql/time_zone.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr2/mysql/time_zone.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr2/mysql/time_zone_transition.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr2/mysql/time_zone_transition.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr2/mysql/time_zone_transition.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr2/mysql/time_zone_transition_type.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr2/mysql/time_zone_transition_type.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr2/mysql/time_zone_transition_type.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr2/mysql/time_zone_leap_second.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr2/mysql/time_zone_leap_second.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr2/mysql/time_zone_leap_second.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proc.frm to /tmp/incr/incr2/mysql/proc.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr2/mysql/proc.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr2/mysql/proc.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr2/mysql/procs_priv.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr2/mysql/procs_priv.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr2/mysql/procs_priv.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr2/mysql/general_log.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr2/mysql/general_log.CSM 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr2/mysql/general_log.CSV 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr2/mysql/slow_log.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr2/mysql/slow_log.CSM 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr2/mysql/slow_log.CSV 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/event.frm to /tmp/incr/incr2/mysql/event.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/event.MYI to /tmp/incr/incr2/mysql/event.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/event.MYD to /tmp/incr/incr2/mysql/event.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr2/mysql/innodb_table_stats.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr2/mysql/innodb_index_stats.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr2/mysql/proxies_priv.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr2/mysql/proxies_priv.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr2/mysql/proxies_priv.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr2/mysql/table_stats.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr2/mysql/table_stats.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr2/mysql/table_stats.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr2/mysql/column_stats.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr2/mysql/column_stats.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr2/mysql/column_stats.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr2/mysql/index_stats.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr2/mysql/index_stats.MYI 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr2/mysql/index_stats.MYD 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr2/mysql/gtid_slave_pos.frm 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./test/db.opt to /tmp/incr/incr2/test/db.opt 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr2/performance_schema/db.opt 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./full/db.opt to /tmp/incr/incr2/full/db.opt 190826 14:33:36 [01] ...done 190826 14:33:36 [01] Copying ./full/incr.frm to /tmp/incr/incr2/full/incr.frm 190826 14:33:36 [01] ...done 190826 14:33:36 Finished backing up non-InnoDB tables and files 190826 14:33:36 [00] Writing /tmp/incr/incr2/xtrabackup_binlog_info 190826 14:33:36 [00] ...done 190826 14:33:36 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1649247' xtrabackup: Stopping log copying thread. .190826 14:33:36 >> log scanned up to (1649256) 190826 14:33:36 Executing UNLOCK TABLES 190826 14:33:36 All tables unlocked 190826 14:33:36 [00] Copying ib_buffer_pool to /tmp/incr/incr2/ib_buffer_pool 190826 14:33:36 [00] ...done 190826 14:33:36 Backup created in directory '/tmp/incr/incr2/' MySQL binlog position: filename 'mysqlbin.000001', position '1239', GTID of the last change '0-1-5' 190826 14:33:36 [00] Writing /tmp/incr/incr2/backup-my.cnf 190826 14:33:36 [00] ...done 190826 14:33:36 [00] Writing /tmp/incr/incr2/xtrabackup_info 190826 14:33:36 [00] ...done xtrabackup: Transaction log of lsn (1649247) to (1649256) was copied. 190826 14:33:37 completed OK! [root@rec tmp]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 20 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> insert into full.incr(tag) values("第3次增备后"); Query OK, 1 row affected (0.30 sec) MariaDB [(none)]> exit Bye [root@rec tmp]# innobackupex --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/incr/incr2/ --incremental /tmp/incr/incr3 xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:34:00 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 190826 14:34:00 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO). 190826 14:34:00 version_check Connected to MySQL server 190826 14:34:00 version_check Executing a version check against the server... 190826 14:34:00 version_check Done. 190826 14:34:00 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Using server version 10.2.26-MariaDB-log innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1649247 is enabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 190826 14:34:00 >> log scanned up to (1650361) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: using the full scan for incremental backup xtrabackup: Starting 4 threads for parallel data files transfer 190826 14:34:01 [04] Copying ./ibdata1 to /tmp/incr/incr3/ibdata1.delta 190826 14:34:01 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr3/mysql/innodb_table_stats.ibd.delta 190826 14:34:01 [02] ...done 190826 14:34:01 [03] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr3/mysql/gtid_slave_pos.ibd.delta 190826 14:34:01 [03] ...done 190826 14:34:01 [04] ...done 190826 14:34:01 [01] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr3/mysql/innodb_index_stats.ibd.delta 190826 14:34:01 [01] ...done 190826 14:34:01 [02] Copying ./full/incr.ibd to /tmp/incr/incr3/full/incr.ibd.delta 190826 14:34:01 [02] ...done 190826 14:34:01 >> log scanned up to (1650361) 190826 14:34:02 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 190826 14:34:02 Executing FLUSH TABLES WITH READ LOCK... 190826 14:34:02 Starting to backup non-InnoDB tables and files 190826 14:34:02 [01] Copying ./mysql/db.opt to /tmp/incr/incr3/mysql/db.opt 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/db.frm to /tmp/incr/incr3/mysql/db.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/db.MYI to /tmp/incr/incr3/mysql/db.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/db.MYD to /tmp/incr/incr3/mysql/db.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/host.frm to /tmp/incr/incr3/mysql/host.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/host.MYI to /tmp/incr/incr3/mysql/host.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/host.MYD to /tmp/incr/incr3/mysql/host.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/user.frm to /tmp/incr/incr3/mysql/user.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/user.MYI to /tmp/incr/incr3/mysql/user.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/user.MYD to /tmp/incr/incr3/mysql/user.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr3/mysql/roles_mapping.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr3/mysql/roles_mapping.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr3/mysql/roles_mapping.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/func.frm to /tmp/incr/incr3/mysql/func.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/func.MYI to /tmp/incr/incr3/mysql/func.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/func.MYD to /tmp/incr/incr3/mysql/func.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr3/mysql/plugin.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr3/mysql/plugin.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr3/mysql/plugin.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/servers.frm to /tmp/incr/incr3/mysql/servers.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr3/mysql/servers.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr3/mysql/servers.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr3/mysql/tables_priv.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr3/mysql/tables_priv.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr3/mysql/tables_priv.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr3/mysql/columns_priv.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr3/mysql/columns_priv.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr3/mysql/columns_priv.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr3/mysql/help_topic.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr3/mysql/help_topic.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr3/mysql/help_topic.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr3/mysql/help_category.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr3/mysql/help_category.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr3/mysql/help_category.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr3/mysql/help_relation.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr3/mysql/help_relation.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr3/mysql/help_relation.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr3/mysql/help_keyword.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr3/mysql/help_keyword.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr3/mysql/help_keyword.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr3/mysql/time_zone_name.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr3/mysql/time_zone_name.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr3/mysql/time_zone_name.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr3/mysql/time_zone.frm 190826 14:34:02 >> log scanned up to (1650361) 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr3/mysql/time_zone.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr3/mysql/time_zone.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr3/mysql/time_zone_transition.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr3/mysql/time_zone_transition.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr3/mysql/time_zone_transition.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr3/mysql/time_zone_transition_type.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr3/mysql/time_zone_transition_type.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr3/mysql/time_zone_transition_type.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr3/mysql/time_zone_leap_second.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr3/mysql/time_zone_leap_second.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr3/mysql/time_zone_leap_second.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proc.frm to /tmp/incr/incr3/mysql/proc.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr3/mysql/proc.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr3/mysql/proc.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr3/mysql/procs_priv.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr3/mysql/procs_priv.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr3/mysql/procs_priv.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr3/mysql/general_log.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr3/mysql/general_log.CSM 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr3/mysql/general_log.CSV 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr3/mysql/slow_log.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr3/mysql/slow_log.CSM 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr3/mysql/slow_log.CSV 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/event.frm to /tmp/incr/incr3/mysql/event.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/event.MYI to /tmp/incr/incr3/mysql/event.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/event.MYD to /tmp/incr/incr3/mysql/event.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr3/mysql/innodb_table_stats.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr3/mysql/innodb_index_stats.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr3/mysql/proxies_priv.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr3/mysql/proxies_priv.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr3/mysql/proxies_priv.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr3/mysql/table_stats.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr3/mysql/table_stats.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr3/mysql/table_stats.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr3/mysql/column_stats.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr3/mysql/column_stats.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr3/mysql/column_stats.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr3/mysql/index_stats.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr3/mysql/index_stats.MYI 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr3/mysql/index_stats.MYD 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr3/mysql/gtid_slave_pos.frm 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./test/db.opt to /tmp/incr/incr3/test/db.opt 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr3/performance_schema/db.opt 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./full/db.opt to /tmp/incr/incr3/full/db.opt 190826 14:34:02 [01] ...done 190826 14:34:02 [01] Copying ./full/incr.frm to /tmp/incr/incr3/full/incr.frm 190826 14:34:02 [01] ...done 190826 14:34:02 Finished backing up non-InnoDB tables and files 190826 14:34:02 [00] Writing /tmp/incr/incr3/xtrabackup_binlog_info 190826 14:34:02 [00] ...done 190826 14:34:02 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1650352' xtrabackup: Stopping log copying thread. .190826 14:34:02 >> log scanned up to (1650361) 190826 14:34:02 Executing UNLOCK TABLES 190826 14:34:02 All tables unlocked 190826 14:34:02 [00] Copying ib_buffer_pool to /tmp/incr/incr3/ib_buffer_pool 190826 14:34:02 [00] ...done 190826 14:34:02 Backup created in directory '/tmp/incr/incr3/' MySQL binlog position: filename 'mysqlbin.000001', position '1460', GTID of the last change '0-1-6' 190826 14:34:02 [00] Writing /tmp/incr/incr3/backup-my.cnf 190826 14:34:02 [00] ...done 190826 14:34:02 [00] Writing /tmp/incr/incr3/xtrabackup_info 190826 14:34:02 [00] ...done xtrabackup: Transaction log of lsn (1650352) to (1650361) was copied. 190826 14:34:03 completed OK! [root@rec tmp]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 23 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> insert into full.incr(tag) values("第4次增备后"); Query OK, 1 row affected (0.30 sec) MariaDB [(none)]> exit Bye [root@rec tmp]# innobackupex --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/incr/incr3/ --incremental /tmp/incr/incr4 xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin --parallel=4 xtrabackup: recognized client arguments: 190826 14:34:47 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 190826 14:34:47 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: NO). 190826 14:34:47 version_check Connected to MySQL server 190826 14:34:47 version_check Executing a version check against the server... 190826 14:34:47 version_check Done. 190826 14:34:47 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set Using server version 10.2.26-MariaDB-log innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1650352 is enabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 190826 14:34:48 >> log scanned up to (1651467) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: using the full scan for incremental backup xtrabackup: Starting 4 threads for parallel data files transfer 190826 14:34:48 [01] Copying ./ibdata1 to /tmp/incr/incr4/ibdata1.delta 190826 14:34:48 [02] Copying ./mysql/innodb_table_stats.ibd to /tmp/incr/incr4/mysql/innodb_table_stats.ibd.delta 190826 14:34:48 [02] ...done 190826 14:34:48 [03] Copying ./mysql/innodb_index_stats.ibd to /tmp/incr/incr4/mysql/innodb_index_stats.ibd.delta 190826 14:34:48 [03] ...done 190826 14:34:48 [04] Copying ./mysql/gtid_slave_pos.ibd to /tmp/incr/incr4/mysql/gtid_slave_pos.ibd.delta 190826 14:34:48 [04] ...done 190826 14:34:48 [01] ...done 190826 14:34:48 [02] Copying ./full/incr.ibd to /tmp/incr/incr4/full/incr.ibd.delta 190826 14:34:48 [02] ...done 190826 14:34:49 >> log scanned up to (1651467) 190826 14:34:49 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 190826 14:34:49 Executing FLUSH TABLES WITH READ LOCK... 190826 14:34:49 Starting to backup non-InnoDB tables and files 190826 14:34:49 [01] Copying ./mysql/db.opt to /tmp/incr/incr4/mysql/db.opt 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/db.frm to /tmp/incr/incr4/mysql/db.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/db.MYI to /tmp/incr/incr4/mysql/db.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/db.MYD to /tmp/incr/incr4/mysql/db.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/host.frm to /tmp/incr/incr4/mysql/host.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/host.MYI to /tmp/incr/incr4/mysql/host.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/host.MYD to /tmp/incr/incr4/mysql/host.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/user.frm to /tmp/incr/incr4/mysql/user.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/user.MYI to /tmp/incr/incr4/mysql/user.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/user.MYD to /tmp/incr/incr4/mysql/user.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/roles_mapping.frm to /tmp/incr/incr4/mysql/roles_mapping.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/roles_mapping.MYI to /tmp/incr/incr4/mysql/roles_mapping.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/roles_mapping.MYD to /tmp/incr/incr4/mysql/roles_mapping.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/func.frm to /tmp/incr/incr4/mysql/func.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/func.MYI to /tmp/incr/incr4/mysql/func.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/func.MYD to /tmp/incr/incr4/mysql/func.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/plugin.frm to /tmp/incr/incr4/mysql/plugin.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/plugin.MYI to /tmp/incr/incr4/mysql/plugin.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/plugin.MYD to /tmp/incr/incr4/mysql/plugin.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/servers.frm to /tmp/incr/incr4/mysql/servers.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/servers.MYI to /tmp/incr/incr4/mysql/servers.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/servers.MYD to /tmp/incr/incr4/mysql/servers.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/tables_priv.frm to /tmp/incr/incr4/mysql/tables_priv.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/tables_priv.MYI to /tmp/incr/incr4/mysql/tables_priv.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/tables_priv.MYD to /tmp/incr/incr4/mysql/tables_priv.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/columns_priv.frm to /tmp/incr/incr4/mysql/columns_priv.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/columns_priv.MYI to /tmp/incr/incr4/mysql/columns_priv.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/columns_priv.MYD to /tmp/incr/incr4/mysql/columns_priv.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_topic.frm to /tmp/incr/incr4/mysql/help_topic.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_topic.MYI to /tmp/incr/incr4/mysql/help_topic.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_topic.MYD to /tmp/incr/incr4/mysql/help_topic.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_category.frm to /tmp/incr/incr4/mysql/help_category.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_category.MYI to /tmp/incr/incr4/mysql/help_category.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_category.MYD to /tmp/incr/incr4/mysql/help_category.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_relation.frm to /tmp/incr/incr4/mysql/help_relation.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_relation.MYI to /tmp/incr/incr4/mysql/help_relation.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_relation.MYD to /tmp/incr/incr4/mysql/help_relation.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_keyword.frm to /tmp/incr/incr4/mysql/help_keyword.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_keyword.MYI to /tmp/incr/incr4/mysql/help_keyword.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/help_keyword.MYD to /tmp/incr/incr4/mysql/help_keyword.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_name.frm to /tmp/incr/incr4/mysql/time_zone_name.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_name.MYI to /tmp/incr/incr4/mysql/time_zone_name.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_name.MYD to /tmp/incr/incr4/mysql/time_zone_name.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone.frm to /tmp/incr/incr4/mysql/time_zone.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone.MYI to /tmp/incr/incr4/mysql/time_zone.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone.MYD to /tmp/incr/incr4/mysql/time_zone.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition.frm to /tmp/incr/incr4/mysql/time_zone_transition.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition.MYI to /tmp/incr/incr4/mysql/time_zone_transition.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition.MYD to /tmp/incr/incr4/mysql/time_zone_transition.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.frm to /tmp/incr/incr4/mysql/time_zone_transition_type.frm 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.MYI to /tmp/incr/incr4/mysql/time_zone_transition_type.MYI 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_transition_type.MYD to /tmp/incr/incr4/mysql/time_zone_transition_type.MYD 190826 14:34:49 [01] ...done 190826 14:34:49 [01] Copying ./mysql/time_zone_leap_second.frm to /tmp/incr/incr4/mysql/time_zone_leap_second.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/time_zone_leap_second.MYI to /tmp/incr/incr4/mysql/time_zone_leap_second.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/time_zone_leap_second.MYD to /tmp/incr/incr4/mysql/time_zone_leap_second.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proc.frm to /tmp/incr/incr4/mysql/proc.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proc.MYI to /tmp/incr/incr4/mysql/proc.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proc.MYD to /tmp/incr/incr4/mysql/proc.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/procs_priv.frm to /tmp/incr/incr4/mysql/procs_priv.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/procs_priv.MYI to /tmp/incr/incr4/mysql/procs_priv.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/procs_priv.MYD to /tmp/incr/incr4/mysql/procs_priv.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/general_log.frm to /tmp/incr/incr4/mysql/general_log.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/general_log.CSM to /tmp/incr/incr4/mysql/general_log.CSM 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/general_log.CSV to /tmp/incr/incr4/mysql/general_log.CSV 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/slow_log.frm to /tmp/incr/incr4/mysql/slow_log.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/slow_log.CSM to /tmp/incr/incr4/mysql/slow_log.CSM 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/slow_log.CSV to /tmp/incr/incr4/mysql/slow_log.CSV 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/event.frm to /tmp/incr/incr4/mysql/event.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/event.MYI to /tmp/incr/incr4/mysql/event.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/event.MYD to /tmp/incr/incr4/mysql/event.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/innodb_table_stats.frm to /tmp/incr/incr4/mysql/innodb_table_stats.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/innodb_index_stats.frm to /tmp/incr/incr4/mysql/innodb_index_stats.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proxies_priv.frm to /tmp/incr/incr4/mysql/proxies_priv.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proxies_priv.MYI to /tmp/incr/incr4/mysql/proxies_priv.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/proxies_priv.MYD to /tmp/incr/incr4/mysql/proxies_priv.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/table_stats.frm to /tmp/incr/incr4/mysql/table_stats.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/table_stats.MYI to /tmp/incr/incr4/mysql/table_stats.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/table_stats.MYD to /tmp/incr/incr4/mysql/table_stats.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/column_stats.frm to /tmp/incr/incr4/mysql/column_stats.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/column_stats.MYI to /tmp/incr/incr4/mysql/column_stats.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/column_stats.MYD to /tmp/incr/incr4/mysql/column_stats.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/index_stats.frm to /tmp/incr/incr4/mysql/index_stats.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/index_stats.MYI to /tmp/incr/incr4/mysql/index_stats.MYI 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/index_stats.MYD to /tmp/incr/incr4/mysql/index_stats.MYD 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./mysql/gtid_slave_pos.frm to /tmp/incr/incr4/mysql/gtid_slave_pos.frm 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./test/db.opt to /tmp/incr/incr4/test/db.opt 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./performance_schema/db.opt to /tmp/incr/incr4/performance_schema/db.opt 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./full/db.opt to /tmp/incr/incr4/full/db.opt 190826 14:34:50 [01] ...done 190826 14:34:50 [01] Copying ./full/incr.frm to /tmp/incr/incr4/full/incr.frm 190826 14:34:50 [01] ...done 190826 14:34:50 Finished backing up non-InnoDB tables and files 190826 14:34:50 [00] Writing /tmp/incr/incr4/xtrabackup_binlog_info 190826 14:34:50 [00] ...done 190826 14:34:50 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '1651458' xtrabackup: Stopping log copying thread. .190826 14:34:50 >> log scanned up to (1651467) 190826 14:34:50 Executing UNLOCK TABLES 190826 14:34:50 All tables unlocked 190826 14:34:50 [00] Copying ib_buffer_pool to /tmp/incr/incr4/ib_buffer_pool 190826 14:34:50 [00] ...done 190826 14:34:50 Backup created in directory '/tmp/incr/incr4/' MySQL binlog position: filename 'mysqlbin.000001', position '1681', GTID of the last change '0-1-7' 190826 14:34:50 [00] Writing /tmp/incr/incr4/backup-my.cnf 190826 14:34:50 [00] ...done 190826 14:34:50 [00] Writing /tmp/incr/incr4/xtrabackup_info 190826 14:34:50 [00] ...done xtrabackup: Transaction log of lsn (1651458) to (1651467) was copied. 190826 14:34:50 completed OK! [root@rec tmp]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 26 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> insert into full.incr(tag) values("第5次增备后"); Query OK, 1 row affected (0.30 sec) MariaDB [(none)]> exit Bye [root@rec tmp]# innobackupex --apply-log --redo-only /tmp/fullbak/ xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:35:30 innobackupex: Starting the apply-log operation IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK!". innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) xtrabackup: cd to /tmp/fullbak/ xtrabackup: This target seems to be not prepared yet. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1648463) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1648463 InnoDB: Doing recovery: scanned up to log sequence number 1648472 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: xtrabackup: Last MySQL binlog file position 1322, file name ./mysqlbin.000002 InnoDB: xtrabackup: Last MySQL binlog file position 1322, file name ./mysqlbin.000002 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1648481 InnoDB: Number of pools: 1 190826 14:35:31 completed OK! [root@rec tmp]# innobackupex --apply-log --redo-only /tmp/fullbak/ --incremental-dir=/tmp/incr/incr1 xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:06 innobackupex: Starting the apply-log operation IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK!". innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1648463 is enabled. xtrabackup: cd to /tmp/fullbak/ xtrabackup: This target seems to be already prepared with --apply-log-only. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1648874) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr1/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: page size for /tmp/incr/incr1//ibdata1.delta is 16384 bytes space id is 0 Applying /tmp/incr/incr1//ibdata1.delta to ./ibdata1... xtrabackup: page size for /tmp/incr/incr1//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2 Applying /tmp/incr/incr1//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd... xtrabackup: page size for /tmp/incr/incr1//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3 Applying /tmp/incr/incr1//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd... xtrabackup: page size for /tmp/incr/incr1//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1 Applying /tmp/incr/incr1//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd... xtrabackup: page size for /tmp/incr/incr1//full/incr.ibd.delta is 16384 bytes space id is 6 Applying /tmp/incr/incr1//full/incr.ibd.delta to ./full/incr.ibd... xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr1/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1648874 InnoDB: Doing recovery: scanned up to log sequence number 1648883 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: xtrabackup: Last MySQL binlog file position 1018, file name ./mysqlbin.000001 InnoDB: xtrabackup: Last MySQL binlog file position 1018, file name ./mysqlbin.000001 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1648892 InnoDB: Number of pools: 1 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.opt to ./mysql/db.opt 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.frm to ./mysql/db.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.MYI to ./mysql/db.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/db.MYD to ./mysql/db.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.frm to ./mysql/host.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.MYI to ./mysql/host.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/host.MYD to ./mysql/host.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.frm to ./mysql/user.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.MYI to ./mysql/user.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/user.MYD to ./mysql/user.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.frm to ./mysql/func.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.MYI to ./mysql/func.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/func.MYD to ./mysql/func.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.frm to ./mysql/plugin.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.MYI to ./mysql/plugin.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/plugin.MYD to ./mysql/plugin.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.frm to ./mysql/servers.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.MYI to ./mysql/servers.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/servers.MYD to ./mysql/servers.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.frm to ./mysql/tables_priv.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.frm to ./mysql/columns_priv.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.frm to ./mysql/help_topic.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.MYI to ./mysql/help_topic.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_topic.MYD to ./mysql/help_topic.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.frm to ./mysql/help_category.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.MYI to ./mysql/help_category.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_category.MYD to ./mysql/help_category.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.frm to ./mysql/help_relation.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.MYI to ./mysql/help_relation.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_relation.MYD to ./mysql/help_relation.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.frm to ./mysql/help_keyword.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.frm to ./mysql/time_zone.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.MYI to ./mysql/time_zone.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone.MYD to ./mysql/time_zone.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.frm to ./mysql/proc.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.MYI to ./mysql/proc.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proc.MYD to ./mysql/proc.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.frm to ./mysql/procs_priv.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.frm to ./mysql/general_log.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.CSM to ./mysql/general_log.CSM 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/general_log.CSV to ./mysql/general_log.CSV 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.frm to ./mysql/slow_log.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.CSM to ./mysql/slow_log.CSM 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/slow_log.CSV to ./mysql/slow_log.CSV 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.frm to ./mysql/event.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.MYI to ./mysql/event.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/event.MYD to ./mysql/event.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.frm to ./mysql/table_stats.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.MYI to ./mysql/table_stats.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/table_stats.MYD to ./mysql/table_stats.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.frm to ./mysql/column_stats.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.MYI to ./mysql/column_stats.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/column_stats.MYD to ./mysql/column_stats.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.frm to ./mysql/index_stats.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.MYI to ./mysql/index_stats.MYI 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/index_stats.MYD to ./mysql/index_stats.MYD 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/full/db.opt to ./full/db.opt 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/full/incr.frm to ./full/incr.frm 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/test/db.opt to ./test/db.opt 190826 14:36:09 [01] ...done 190826 14:36:09 [01] Copying /tmp/incr/incr1/performance_schema/db.opt to ./performance_schema/db.opt 190826 14:36:09 [01] ...done 190826 14:36:09 [00] Copying /tmp/incr/incr1//xtrabackup_binlog_info to ./xtrabackup_binlog_info 190826 14:36:09 [00] ...done 190826 14:36:09 [00] Copying /tmp/incr/incr1//xtrabackup_info to ./xtrabackup_info 190826 14:36:09 [00] ...done 190826 14:36:09 completed OK! [root@rec tmp]# innobackupex --apply-log --redo-only /tmp/fullbak/ --incremental-dir=/tmp/incr/incr2 xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:12 innobackupex: Starting the apply-log operation IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK!". innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1648874 is enabled. xtrabackup: cd to /tmp/fullbak/ xtrabackup: This target seems to be already prepared with --apply-log-only. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1649247) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr2/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: page size for /tmp/incr/incr2//ibdata1.delta is 16384 bytes space id is 0 Applying /tmp/incr/incr2//ibdata1.delta to ./ibdata1... xtrabackup: page size for /tmp/incr/incr2//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3 Applying /tmp/incr/incr2//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd... xtrabackup: page size for /tmp/incr/incr2//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2 Applying /tmp/incr/incr2//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd... xtrabackup: page size for /tmp/incr/incr2//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1 Applying /tmp/incr/incr2//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd... xtrabackup: page size for /tmp/incr/incr2//full/incr.ibd.delta is 16384 bytes space id is 6 Applying /tmp/incr/incr2//full/incr.ibd.delta to ./full/incr.ibd... xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr2/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1649247 InnoDB: Doing recovery: scanned up to log sequence number 1649256 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: xtrabackup: Last MySQL binlog file position 1239, file name ./mysqlbin.000001 InnoDB: xtrabackup: Last MySQL binlog file position 1239, file name ./mysqlbin.000001 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1649265 InnoDB: Number of pools: 1 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.opt to ./mysql/db.opt 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.frm to ./mysql/db.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.MYI to ./mysql/db.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/db.MYD to ./mysql/db.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.frm to ./mysql/host.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.MYI to ./mysql/host.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/host.MYD to ./mysql/host.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.frm to ./mysql/user.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.MYI to ./mysql/user.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/user.MYD to ./mysql/user.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.frm to ./mysql/func.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.MYI to ./mysql/func.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/func.MYD to ./mysql/func.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.frm to ./mysql/plugin.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.MYI to ./mysql/plugin.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/plugin.MYD to ./mysql/plugin.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.frm to ./mysql/servers.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.MYI to ./mysql/servers.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/servers.MYD to ./mysql/servers.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.frm to ./mysql/tables_priv.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.frm to ./mysql/columns_priv.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.frm to ./mysql/help_topic.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.MYI to ./mysql/help_topic.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_topic.MYD to ./mysql/help_topic.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.frm to ./mysql/help_category.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.MYI to ./mysql/help_category.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_category.MYD to ./mysql/help_category.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.frm to ./mysql/help_relation.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.MYI to ./mysql/help_relation.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_relation.MYD to ./mysql/help_relation.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.frm to ./mysql/help_keyword.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm 190826 14:36:14 [01] ...done 190826 14:36:14 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI 190826 14:36:14 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.frm to ./mysql/time_zone.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.MYI to ./mysql/time_zone.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone.MYD to ./mysql/time_zone.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.frm to ./mysql/proc.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.MYI to ./mysql/proc.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proc.MYD to ./mysql/proc.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.frm to ./mysql/procs_priv.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.frm to ./mysql/general_log.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.CSM to ./mysql/general_log.CSM 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/general_log.CSV to ./mysql/general_log.CSV 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.frm to ./mysql/slow_log.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.CSM to ./mysql/slow_log.CSM 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/slow_log.CSV to ./mysql/slow_log.CSV 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.frm to ./mysql/event.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.MYI to ./mysql/event.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/event.MYD to ./mysql/event.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.frm to ./mysql/table_stats.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.MYI to ./mysql/table_stats.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/table_stats.MYD to ./mysql/table_stats.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.frm to ./mysql/column_stats.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.MYI to ./mysql/column_stats.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/column_stats.MYD to ./mysql/column_stats.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.frm to ./mysql/index_stats.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.MYI to ./mysql/index_stats.MYI 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/index_stats.MYD to ./mysql/index_stats.MYD 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/full/db.opt to ./full/db.opt 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/full/incr.frm to ./full/incr.frm 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/test/db.opt to ./test/db.opt 190826 14:36:15 [01] ...done 190826 14:36:15 [01] Copying /tmp/incr/incr2/performance_schema/db.opt to ./performance_schema/db.opt 190826 14:36:15 [01] ...done 190826 14:36:15 [00] Copying /tmp/incr/incr2//xtrabackup_binlog_info to ./xtrabackup_binlog_info 190826 14:36:15 [00] ...done 190826 14:36:15 [00] Copying /tmp/incr/incr2//xtrabackup_info to ./xtrabackup_info 190826 14:36:15 [00] ...done 190826 14:36:15 completed OK! [root@rec tmp]# innobackupex --apply-log --redo-only /tmp/fullbak/ --incremental-dir=/tmp/incr/incr3 xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: 190826 14:36:19 innobackupex: Starting the apply-log operation IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK!". innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) incremental backup from 1649247 is enabled. xtrabackup: cd to /tmp/fullbak/ xtrabackup: This target seems to be already prepared with --apply-log-only. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1650352) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr3/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0 xtrabackup: page size for /tmp/incr/incr3//ibdata1.delta is 16384 bytes space id is 0 Applying /tmp/incr/incr3//ibdata1.delta to ./ibdata1... xtrabackup: page size for /tmp/incr/incr3//mysql/innodb_table_stats.ibd.delta is 16384 bytes space id is 1 Applying /tmp/incr/incr3//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd... xtrabackup: page size for /tmp/incr/incr3//mysql/gtid_slave_pos.ibd.delta is 16384 bytes space id is 3 Applying /tmp/incr/incr3//mysql/gtid_slave_pos.ibd.delta to ./mysql/gtid_slave_pos.ibd... xtrabackup: page size for /tmp/incr/incr3//mysql/innodb_index_stats.ibd.delta is 16384 bytes space id is 2 Applying /tmp/incr/incr3//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd... xtrabackup: page size for /tmp/incr/incr3//full/incr.ibd.delta is 16384 bytes space id is 6 Applying /tmp/incr/incr3//full/incr.ibd.delta to ./full/incr.ibd... xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /tmp/incr/incr3/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1650352 InnoDB: Doing recovery: scanned up to log sequence number 1650361 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: xtrabackup: Last MySQL binlog file position 1460, file name ./mysqlbin.000001 InnoDB: xtrabackup: Last MySQL binlog file position 1460, file name ./mysqlbin.000001 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 1650370 InnoDB: Number of pools: 1 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.opt to ./mysql/db.opt 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.frm to ./mysql/db.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.MYI to ./mysql/db.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/db.MYD to ./mysql/db.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.frm to ./mysql/host.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.MYI to ./mysql/host.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/host.MYD to ./mysql/host.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.frm to ./mysql/user.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.MYI to ./mysql/user.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/user.MYD to ./mysql/user.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.frm to ./mysql/roles_mapping.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.MYI to ./mysql/roles_mapping.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/roles_mapping.MYD to ./mysql/roles_mapping.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.frm to ./mysql/func.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.MYI to ./mysql/func.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/func.MYD to ./mysql/func.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.frm to ./mysql/plugin.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.MYI to ./mysql/plugin.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/plugin.MYD to ./mysql/plugin.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.frm to ./mysql/servers.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.MYI to ./mysql/servers.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/servers.MYD to ./mysql/servers.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.frm to ./mysql/tables_priv.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.MYI to ./mysql/tables_priv.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/tables_priv.MYD to ./mysql/tables_priv.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.frm to ./mysql/columns_priv.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.MYI to ./mysql/columns_priv.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/columns_priv.MYD to ./mysql/columns_priv.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.frm to ./mysql/help_topic.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.MYI to ./mysql/help_topic.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_topic.MYD to ./mysql/help_topic.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.frm to ./mysql/help_category.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.MYI to ./mysql/help_category.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_category.MYD to ./mysql/help_category.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.frm to ./mysql/help_relation.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.MYI to ./mysql/help_relation.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_relation.MYD to ./mysql/help_relation.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.frm to ./mysql/help_keyword.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.MYI to ./mysql/help_keyword.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/help_keyword.MYD to ./mysql/help_keyword.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.frm to ./mysql/time_zone_name.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.MYI to ./mysql/time_zone_name.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_name.MYD to ./mysql/time_zone_name.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.frm to ./mysql/time_zone.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.MYI to ./mysql/time_zone.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone.MYD to ./mysql/time_zone.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.frm to ./mysql/time_zone_transition.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.MYI to ./mysql/time_zone_transition.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition.MYD to ./mysql/time_zone_transition.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.frm to ./mysql/time_zone_transition_type.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.MYI to ./mysql/time_zone_transition_type.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_transition_type.MYD to ./mysql/time_zone_transition_type.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.frm to ./mysql/time_zone_leap_second.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.MYI to ./mysql/time_zone_leap_second.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/time_zone_leap_second.MYD to ./mysql/time_zone_leap_second.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.frm to ./mysql/proc.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.MYI to ./mysql/proc.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proc.MYD to ./mysql/proc.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.frm to ./mysql/procs_priv.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.MYI to ./mysql/procs_priv.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/procs_priv.MYD to ./mysql/procs_priv.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.frm to ./mysql/general_log.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.CSM to ./mysql/general_log.CSM 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/general_log.CSV to ./mysql/general_log.CSV 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.frm to ./mysql/slow_log.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.CSM to ./mysql/slow_log.CSM 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/slow_log.CSV to ./mysql/slow_log.CSV 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.frm to ./mysql/event.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.MYI to ./mysql/event.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/event.MYD to ./mysql/event.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/innodb_table_stats.frm to ./mysql/innodb_table_stats.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/innodb_index_stats.frm to ./mysql/innodb_index_stats.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.frm to ./mysql/proxies_priv.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.MYI to ./mysql/proxies_priv.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/proxies_priv.MYD to ./mysql/proxies_priv.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.frm to ./mysql/table_stats.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.MYI to ./mysql/table_stats.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/table_stats.MYD to ./mysql/table_stats.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.frm to ./mysql/column_stats.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.MYI to ./mysql/column_stats.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/column_stats.MYD to ./mysql/column_stats.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.frm to ./mysql/index_stats.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.MYI to ./mysql/index_stats.MYI 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/index_stats.MYD to ./mysql/index_stats.MYD 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/mysql/gtid_slave_pos.frm to ./mysql/gtid_slave_pos.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/full/db.opt to ./full/db.opt 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/full/incr.frm to ./full/incr.frm 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/test/db.opt to ./test/db.opt 190826 14:36:21 [01] ...done 190826 14:36:21 [01] Copying /tmp/incr/incr3/performance_schema/db.opt to ./performance_schema/db.opt 190826 14:36:21 [01] ...done 190826 14:36:21 [00] Copying /tmp/incr/incr3//xtrabackup_binlog_info to ./xtrabackup_binlog_info 190826 14:36:21 [00] ...done 190826 14:36:21 [00] Copying /tmp/incr/incr3//xtrabackup_info to ./xtrabackup_info 190826 14:36:21 [00] ...done 190826 14:36:21 completed OK! [root@rec tmp]# /etc/init.d/mysql stop Stopping mysql (via systemctl): [ 确定 ] [root@rec tmp]# cd /var/lib/ [root@rec lib]# ll 总用量 24 drwxr-xr-x. 4 root root 32 8月 23 15:43 AccountsService drwxr-xr-x. 2 root root 26 8月 26 09:58 alsa drwxr-xr-x. 2 root root 4096 8月 23 15:55 alternatives drwx------. 3 root root 18 8月 23 16:04 authconfig drwxr-xr-x. 2 root root 6 9月 12 2017 bluetooth drwxr-xr-x. 2 root root 6 11月 2 2018 boltd drwxr-xr-x. 5 root root 46 8月 23 15:44 certmonger drwxr-xr-x. 2 chrony chrony 19 8月 26 14:08 chrony drwxr-xr-x. 3 root root 17 8月 23 15:41 color drwxr-xr-x. 4 colord colord 67 8月 23 16:27 colord drwxr-xr-x. 2 root root 24 8月 23 16:27 dbus drwxr-xr-x. 2 root root 6 5月 15 2018 dhclient drwxr-xr-x. 2 root root 6 10月 31 2018 dnsmasq drwxr-xr-x. 3 root root 34 8月 23 15:45 flatpak drwxr-xr-x. 2 root root 6 10月 31 2018 fprint drwxr-xr-x. 3 root root 39 8月 23 16:31 fwupd drwxr-xr-x. 2 root root 6 11月 9 2018 fwupdate drwxr-xr-x. 2 root root 6 4月 11 2018 games drwxrwx--T. 7 gdm gdm 97 8月 26 09:51 gdm drwxr-xr-x. 2 geoclue geoclue 6 10月 31 2018 geoclue drwxr-xr-x. 4 root root 55 8月 26 09:50 gssproxy drwxr-xr-x. 2 root root 6 10月 31 2018 hyperv drwxr-xr-x. 2 root root 6 11月 3 2018 initramfs drwxr-xr-x. 4 root root 35 8月 23 15:37 ipa-client drwxr-xr-x. 8 root root 90 8月 23 15:43 iscsi drwxr-xr-x. 9 root root 106 8月 23 15:44 libvirt drwxr-xr-x. 2 root root 6 11月 6 2016 lldpad drwxr-xr-x. 2 root root 30 8月 26 10:44 logrotate drwx------. 2 root root 6 8月 23 15:42 machines drwxr-xr-x. 2 root root 37 8月 23 16:26 misc drwxr-x---. 2 root slocate 24 8月 26 10:44 mlocate drwxr-xr-x. 6 mysql mysql 4096 8月 26 14:36 mysql drwxr-xr-x. 17 mysql mysql 4096 8月 26 14:00 mysql.bak1 drwxr-xr-x. 6 mysql mysql 4096 8月 26 14:21 mysql.bak2 drwxr-xr-x. 4 root root 45 8月 23 15:41 net-snmp drwx------. 2 root root 4096 8月 26 09:55 NetworkManager drwxr-xr-x. 5 root root 105 8月 23 15:44 nfs drwxr-xr-x. 2 ntp ntp 6 4月 13 2018 ntp drwxr-xr-x. 2 root root 6 11月 6 2016 os-prober drwxr-xr-x. 2 root root 29 8月 26 09:56 PackageKit drwxr-xr-x. 2 root root 27 8月 23 15:43 plymouth drwxr-x---. 3 root polkitd 28 8月 23 15:42 polkit-1 drwx------. 2 postfix root 25 8月 23 16:26 postfix drwx------. 2 pulse pulse 6 4月 13 2018 pulse drwx------. 2 rpc rpc 6 10月 31 2018 rpcbind drwxr-xr-x. 2 root root 4096 8月 26 09:55 rpm drwxr-xr-x. 3 root root 19 8月 23 15:55 rpm-state drwx------. 2 root root 29 8月 26 14:36 rsyslog drwxr-xr-x. 4 root root 33 8月 23 15:43 samba drwxr-xr-x. 2 root root 6 11月 3 2018 selinux drwx------. 2 setroubleshoot setroubleshoot 71 8月 23 16:52 setroubleshoot drwxr-xr-x. 10 root root 120 8月 23 15:45 sss drwxr-xr-x. 4 root root 35 8月 23 15:43 stateless drwxr-xr-x. 5 root root 70 8月 23 16:26 systemd drwx------. 2 tss tss 6 8月 4 2017 tpm drwxr-xr-x. 2 root root 6 11月 5 2018 tuned drwx------. 2 root root 6 11月 3 2018 udisks2 drwxr-xr-x. 2 unbound unbound 22 8月 23 15:44 unbound drwxr-xr-x. 2 root root 127 8月 26 10:01 upower drwxr-xr-x. 2 root root 109 8月 26 09:50 VBoxGuestAdditions drwxr-xr-x. 2 root root 29 8月 26 09:55 xkb drwxr-xr-x. 6 root root 80 8月 26 10:30 yum [root@rec lib]# rm -rf mysql [root@rec lib]# mkdir -p mysql [root@rec lib]# innobackupex --defaults-file=/etc/my.cnf --copy-back /tmp/fullbak/ xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --log_bin=mysqlbin xtrabackup: recognized client arguments: 190826 14:37:23 innobackupex: Starting the copy-back operation IMPORTANT: Please check that the copy-back run completes successfully. At the end of a successful copy-back run innobackupex prints "completed OK!". innobackupex version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a) 190826 14:37:23 [01] Copying ibdata1 to /var/lib/mysql/ibdata1 190826 14:37:23 [01] ...done 190826 14:37:24 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/host.frm to /var/lib/mysql/mysql/host.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/host.MYI to /var/lib/mysql/mysql/host.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/host.MYD to /var/lib/mysql/mysql/host.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/roles_mapping.MYI to /var/lib/mysql/mysql/roles_mapping.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/roles_mapping.MYD to /var/lib/mysql/mysql/roles_mapping.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/table_stats.MYI to /var/lib/mysql/mysql/table_stats.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/table_stats.MYD to /var/lib/mysql/mysql/table_stats.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/column_stats.MYI to /var/lib/mysql/mysql/column_stats.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/column_stats.MYD to /var/lib/mysql/mysql/column_stats.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/index_stats.MYI to /var/lib/mysql/mysql/index_stats.MYI 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/index_stats.MYD to /var/lib/mysql/mysql/index_stats.MYD 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./full/incr.ibd to /var/lib/mysql/full/incr.ibd 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./full/db.opt to /var/lib/mysql/full/db.opt 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./full/incr.frm to /var/lib/mysql/full/incr.frm 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./xtrabackup_master_key_id to /var/lib/mysql/xtrabackup_master_key_id 190826 14:37:24 [01] ...done 190826 14:37:24 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info 190826 14:37:24 [01] ...done 190826 14:37:24 completed OK! [root@rec lib]# chown mysql.mysql -R mysql [root@rec lib]# /etc/init.d/mysql start Starting mysql (via systemctl): [ 确定 ] [root@rec lib]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select * from full.incr; +----+------------------+ | id | tag | +----+------------------+ | 1 | 第1次增备后 | | 2 | 第2次增备后 | | 3 | 第3次增备后 | +----+------------------+ 3 rows in set (0.00 sec) MariaDB [(none)]> exit Bye [root@rec lib]# cd /tmp/incr/incr3/ [root@rec incr3]# ll 总用量 8412 -rw-r-----. 1 root root 438 8月 26 14:34 backup-my.cnf drwxr-x---. 2 root root 79 8月 26 14:34 full -rw-r-----. 1 root root 942 8月 26 14:34 ib_buffer_pool -rw-r-----. 1 root root 196608 8月 26 14:34 ibdata1.delta -rw-r-----. 1 root root 44 8月 26 14:34 ibdata1.meta drwxr-x---. 2 root root 4096 8月 26 14:34 mysql drwxr-x---. 2 root root 20 8月 26 14:34 performance_schema drwxr-x---. 2 root root 20 8月 26 14:34 test -rw-r-----. 1 root root 27 8月 26 14:34 xtrabackup_binlog_info -rw-r-----. 1 root root 139 8月 26 14:34 xtrabackup_checkpoints -rw-r-----. 1 root root 587 8月 26 14:34 xtrabackup_info -rw-r-----. 1 root root 8388608 8月 26 14:36 xtrabackup_logfile [root@rec incr3]# cat xtrabackup_info uuid = 7eb52f1e-c7cb-11e9-ac43-0800279bc167 name = tool_name = innobackupex tool_command = --user=root --no-timestamp --parallel=4 --incremental-basedir=/tmp/incr/incr2/ --incremental /tmp/incr/incr3 tool_version = 2.4.15 ibbackup_version = 2.4.15 server_version = 10.2.26-MariaDB-log start_time = 2019-08-26 14:34:00 end_time = 2019-08-26 14:34:02 lock_time = 0 binlog_pos = filename 'mysqlbin.000001', position '1460', GTID of the last change '0-1-6' innodb_from_lsn = 1649247 innodb_to_lsn = 1650352 partial = N incremental = Y format = file compact = N compressed = N encrypted = N [root@rec incr3]# exit 登出
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
