溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
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進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
