install XtraBackup
download from:
https://www.percona.com/doc/percona-xtrabackup/2.4/installation/yum_repo.html
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL libev numactl
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm
完全备份
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --no-timestamp /root/back/
还原
恢复日志
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --apply-log /root/back/
恢复数据
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --datadir=/data/mysql/ --copy-back /root/back/
innobackuppex 常用用法
#innobackupex <选项>
--use用户名
--password #密码
--database #备份数据库名
--no-timestamp #不用日期命名备份文件存储的子目录
--apply-log恢复日志 #重做已提交的事务,回滚未提交的事务
--copy-back #恢复备份至数据库服务器的数据目录
xtrabackup只能备份innodb和xtradb两种引擎的表,而不能备份myisam引擎的表;
innobackupex是一个封装了xtrabackup的Perl脚本,支持同时备份innodb和myisam,
但在对myisam备份时需要加一个全局的读锁。还有就是myisam不支持增量备份。
支持事务 和 事务回滚 事务日志文件 ibdata1
LSN 日志序列号
ib_logfile0 记录sql命令
ib_logfile1
备份后生成的文件
-rw-r----- 1 root root 425 8月 19 00:50 backup-my.cnf
drwxr-x--- 2 root root 12288 8月 19 00:50 crm
-rw-r----- 1 root root 297 8月 19 00:50 ib_buffer_pool
-rw-r----- 1 root root 12582912 8月 19 00:55 ibdata1
-rw-r----- 1 root root 50331648 8月 19 00:55 ib_logfile0
-rw-r----- 1 root root 50331648 8月 19 00:55 ib_logfile1
-rw-r----- 1 root root 12582912 8月 19 00:55 ibtmp1
drwxr-x--- 2 root root 4096 8月 19 00:50 mysql
drwxr-x--- 2 root root 8192 8月 19 00:50 performance_schema
drwxr-x--- 2 root root 8192 8月 19 00:50 sys
-rw-r----- 1 root root 25 8月 19 00:50 xtrabackup_binlog_info
-rw-r--r-- 1 root root 26 8月 19 00:55 xtrabackup_binlog_pos_innodb
-rw-r----- 1 root root 113 8月 19 00:55 xtrabackup_checkpoints
-rw-r----- 1 root root 539 8月 19 00:50 xtrabackup_info
-rw-r----- 1 root root 8388608 8月 19 00:55 xtrabackup_logfile
### innobackupex还会在备份目录中创建如下文件
cat xtrabackup_checkpoints # 备份配置文件
backup_type = full-backuped #备份类型 (完全或增量)
from_lsn = 0
to_lsn = 2769448 #LSN 日志序列号 范围信息
last_lsn = 2769457
compact = 0
recover_binlog_info = 0
xtrabackup_logfile #后台日志文件
xtrabackup_binlog_info #mysql服务器当前正在使用的二进制日志文件及至备份这一刻为止二进制日志事件的位置。
ibdata1#系统表空间文件
xtrabackup_info#有关此次备份的各种详细信息
backup-my.cnf #执行备份占用的系统资源
增量备份
--incremental 目录名 增量备份
--incremental-basedir=目录名 增量备份是 指定上一次数据存储的目录名
#innobackupex --user root --password abc123 --databases="系统库列表 存储数据库" --incremental 目录名 --incremental-basedir=目录名 --no-timestamp
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --no-timestamp --incremental /new1/ --incremental-basedir=/root/back/
增量恢复
--incremental-dir=目录名
--redo-only 合并日志
1 恢复日志文件
先恢复完全备份
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --apply-log --redo-only /root/back/
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --apply-log --redo-only /root/back/ --incremental-dir=/new1
2 恢复数据
innobackupex --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root --password=123456 --copy-back /root/back/
innobackupex 指令
[root@localhost ~]# innobackupex --help
Open source backup tool for InnoDB and XtraDB
Copyright (C) 2009-2015 Percona LLC and/or its affiliates.
Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved.
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation version 2
of the License.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You can download full text of the license on http://www.gnu.org/licenses/gpl-2.0.txt
innobackupex - Non-blocking backup tool for InnoDB, XtraDB and HailDB databases
SYNOPOSIS
innobackupex [--compress] [--compress-threads=NUMBER-OF-THREADS] [--compress-chunk-size=CHUNK-SIZE]
[--encrypt=ENCRYPTION-ALGORITHM] [--encrypt-threads=NUMBER-OF-THREADS] [--encrypt-chunk-size=CHUNK-SIZE]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--include=REGEXP] [--user=NAME]
[--password=WORD] [--port=PORT] [--socket=SOCKET]
[--no-timestamp] [--ibbackup=IBBACKUP-BINARY]
[--slave-info] [--galera-info] [--stream=tar|xbstream]
[--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME]
[--databases=LIST] [--no-lock]
[--tmpdir=DIRECTORY] [--tables-file=FILE]
[--history=NAME]
[--incremental] [--incremental-basedir]
[--incremental-dir] [--incremental-force-scan] [--incremental-lsn]
[--incremental-history-name=NAME] [--incremental-history-uuid=UUID]
[--close-files] [--compact]
BACKUP-ROOT-DIR
innobackupex --apply-log [--use-memory=B]
[--defaults-file=MY.CNF]
[--export] [--redo-only] [--ibbackup=IBBACKUP-BINARY]
BACKUP-DIR
innobackupex --copy-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex --move-back [--defaults-file=MY.CNF] [--defaults-group=GROUP-NAME] BACKUP-DIR
innobackupex [--decompress] [--decrypt=ENCRYPTION-ALGORITHM]
[--encrypt-key=LITERAL-ENCRYPTION-KEY] | [--encryption-key-file=MY.KEY]
[--parallel=NUMBER-OF-FORKS] BACKUP-DIR
DESCRIPTION
The first command line above makes a hot backup of a MySQL database.
By default it creates a backup directory (named by the current date
and time) in the given backup root directory. With the --no-timestamp
option it does not create a time-stamped backup directory, but it puts
the backup in the given directory (which must not exist). This
command makes a complete backup of all MyISAM and InnoDB tables and
indexes in all databases or in all of the databases specified with the
--databases option. The created backup contains .frm, .MRG, .MYD,
.MYI, .MAD, .MAI, .TRG, .TRN, .ARM, .ARZ, .CSM, CSV, .opt, .par, and
InnoDB data and log files. The MY.CNF options file defines the
location of the database. This command connects to the MySQL server
using the mysql client program, and runs xtrabackup as a child
process.
The --apply-log command prepares a backup for starting a MySQL
server on the backup. This command recovers InnoDB data files as specified
in BACKUP-DIR/backup-my.cnf using BACKUP-DIR/xtrabackup_logfile,
and creates new InnoDB log files as specified in BACKUP-DIR/backup-my.cnf.
The BACKUP-DIR should be the path to a backup directory created by
xtrabackup. This command runs xtrabackup as a child process, but it does not
connect to the database server.
The --copy-back command copies data, index, and log files
from the backup directory back to their original locations.
The MY.CNF options file defines the original location of the database.
The BACKUP-DIR is the path to a backup directory created by xtrabackup.
The --move-back command is similar to --copy-back with the only difference that
it moves files to their original locations rather than copies them. As this
option removes backup files, it must be used with caution. It may be useful in
cases when there is not enough free disk space to copy files.
The --decompress --decrypt command will decrypt and/or decompress a backup made
with the --compress and/or --encrypt options. When decrypting, the encryption
algorithm and key used when the backup was taken MUST be provided via the
specified options. --decrypt and --decompress may be used together at the same
time to completely normalize a previously compressed and encrypted backup. The
--parallel option will allow multiple files to be decrypted and/or decompressed
simultaneously. In order to decompress, the qpress utility MUST be installed
and accessable within the path. This process will remove the original
compressed/encrypted files and leave the results in the same location.
On success the exit code innobackupex is 0. A non-zero exit code
indicates an error.
Usage: [innobackupex [--defaults-file=#] --backup | innobackupex [--defaults-file=#] --prepare] [OPTIONS]
-v, --version print xtrabackup version information
-?, --help This option displays a help screen and exits.
--apply-log Prepare a backup in BACKUP-DIR by applying the
transaction log file named "xtrabackup_logfile" located
in the same directory. Also, create new transaction logs.
The InnoDB configuration is read from the file
"backup-my.cnf".
--redo-only This option should be used when preparing the base full
backup and when merging all incrementals except the last
one. This forces xtrabackup to skip the "rollback" phase
and do a "redo" only. This is necessary if the backup
will have incremental changes applied to it later. See
the xtrabackup documentation for details.
--copy-back Copy all the files in a previously made backup from the
backup directory to their original locations.
--move-back Move all the files in a previously made backup from the
backup directory to the actual datadir location. Use with
caution, as it removes backup files.
--galera-info This options creates the xtrabackup_galera_info file
which contains the local node state at the time of the
backup. Option should be used when performing the backup
of Percona-XtraDB-Cluster. Has no effect when backup
locks are used to create the backup.
--slave-info This option is useful when backing up a replication slave
server. It prints the binary log position and name of the
master server. It also writes this information to the
"xtrabackup_slave_info" file as a "CHANGE MASTER"
command. A new slave for this master can be set up by
starting a slave server on this backup and issuing a
"CHANGE MASTER" command with the binary log position
saved in the "xtrabackup_slave_info" file.
--incremental This option tells xtrabackup to create an incremental
backup, rather than a full one. It is passed to the
xtrabackup child process. When this option is specified,
either --incremental-lsn or --incremental-basedir can
also be given. If neither option is given, option
--incremental-basedir is passed to xtrabackup by default,
set to the first timestamped backup directory in the
backup base directory.
--no-lock Use this option to disable table lock with "FLUSH TABLES
WITH READ LOCK". Use it only if ALL your tables are
InnoDB and you DO NOT CARE about the binary log position
of the backup. This option shouldn't be used if there are
any DDL statements being executed or if any updates are
happening on non-InnoDB tables (this includes the system
MyISAM tables in the mysql database), otherwise it could
lead to an inconsistent backup. If you are considering to
use --no-lock because your backups are failing to acquire
the lock, this could be because of incoming replication
events preventing the lock from succeeding. Please try
using --safe-slave-backup to momentarily stop the
replication slave thread, this may help the backup to
succeed and you then don't need to resort to using this
option.
--safe-slave-backup Stop slave SQL thread and wait to start backup until
Slave_open_temp_tables in "SHOW STATUS" is zero. If there
are no open temporary tables, the backup will take place,
otherwise the SQL thread will be started and stopped
until there are no open temporary tables. The backup will
fail if Slave_open_temp_tables does not become zero after
--safe-slave-backup-timeout seconds. The slave SQL thread
will be restarted when the backup finishes.
--rsync Uses the rsync utility to optimize local file transfers.
When this option is specified, innobackupex uses rsync to
copy all non-InnoDB files instead of spawning a separate
cp for each file, which can be much faster for servers
with a large number of databases or tables. This option
cannot be used together with --stream.
--force-non-empty-directories
This option, when specified, makes --copy-back or
--move-back transfer files to non-empty directories. Note
that no existing files will be overwritten. If
--copy-back or --nove-back has to copy a file from the
backup directory which already exists in the destination
directory, it will still fail with an error.
--no-timestamp This option prevents creation of a time-stamped
subdirectory of the BACKUP-ROOT-DIR given on the command
line. When it is specified, the backup is done in
BACKUP-ROOT-DIR instead.
--no-version-check This option disables the version check which is enabled
by the --version-check option.
--no-backup-locks This option controls if backup locks should be used
instead of FLUSH TABLES WITH READ LOCK on the backup
stage. The option has no effect when backup locks are not
supported by the server. This option is enabled by
default, disable with --no-backup-locks.
--decompress Decompresses all files with the .qp extension in a backup
previously made with the --compress option.
--user=name This option specifies the MySQL username used when
connecting to the server, if that's not the current user.
The option accepts a string argument. See mysql --help
for details.
--host=name This option specifies the host to use when connecting to
the database server with TCP/IP. The option accepts a
string argument. See mysql --help for details.
--port=# This option specifies the port to use when connecting to
the database server with TCP/IP. The option accepts a
string argument. See mysql --help for details.
--password=name This option specifies the password to use when connecting
to the database. It accepts a string argument. See mysql
--help for details.
--socket=name This option specifies the socket to use when connecting
to the local database server with a UNIX domain socket.
The option accepts a string argument. See mysql --help
for details.
--incremental-history-name=name
This option specifies the name of the backup series
stored in the PERCONA_SCHEMA.xtrabackup_history history
record to base an incremental backup on. Xtrabackup will
search the history table looking for the most recent
(highest innodb_to_lsn), successful backup in the series
and take the to_lsn value to use as the starting lsn for
the incremental backup. This will be mutually exclusive
with --incremental-history-uuid, --incremental-basedir
and --incremental-lsn. If no valid lsn can be found (no
series by that name, no successful backups by that name)
xtrabackup will return with an error. It is used with the
--incremental option.
--incremental-history-uuid=name
This option specifies the UUID of the specific history
record stored in the PERCONA_SCHEMA.xtrabackup_history to
base an incremental backup on.
--incremental-history-name, --incremental-basedir and
--incremental-lsn. If no valid lsn can be found (no
success record with that uuid) xtrabackup will return
with an error. It is used with the --incremental option.
--decrypt=name Decrypts all files with the .xbcrypt extension in a
backup previously made with --encrypt option.
--ftwrl-wait-query-type=name
This option specifies which types of queries are allowed
to complete before innobackupex will issue the global
lock. Default is all.
--kill-long-query-type=name
This option specifies which types of queries should be
killed to unblock the global lock. Default is "all".
--history[=name] This option enables the tracking of backup history in the
PERCONA_SCHEMA.xtrabackup_history table. An optional
history series name may be specified that will be placed
with the history record for the current backup being
taken.
--include=name This option is a regular expression to be matched against
table names in databasename.tablename format. It is
passed directly to xtrabackup's --tables option. See the
xtrabackup documentation for details.
--databases=name This option specifies the list of databases that
innobackupex should back up. The option accepts a string
argument or path to file that contains the list of
databases to back up. The list is of the form
"databasename1[.table_name1] databasename2[.table_name2]
. . .". If this option is not specified, all databases
containing MyISAM and InnoDB tables will be backed up.
Please make sure that --databases contains all of the
InnoDB databases and tables, so that all of the
innodb.frm files are also backed up. In case the list is
very long, this can be specified in a file, and the full
path of the file can be specified instead of the list.
(See option --tables-file.)
--kill-long-queries-timeout=#
This option specifies the number of seconds innobackupex
waits between starting FLUSH TABLES WITH READ LOCK and
killing those queries that block it. Default is 0
seconds, which means innobackupex will not attempt to
kill any queries.
--ftwrl-wait-timeout=#
This option specifies time in seconds that innobackupex
should wait for queries that would block FTWRL before
running it. If there are still such queries when the
timeout expires, innobackupex terminates with an error.
Default is 0, in which case innobackupex does not wait
for queries to complete and starts FTWRL immediately.
--ftwrl-wait-threshold=#
This option specifies the query run time threshold which
is used by innobackupex to detect long-running queries
with a non-zero value of --ftwrl-wait-timeout. FTWRL is
not started until such long-running queries exist. This
option has no effect if --ftwrl-wait-timeout is 0.
Default value is 60 seconds.
--debug-sleep-before-unlock=#
This is a debug-only option used by the XtraBackup test
suite.
--safe-slave-backup-timeout=#
How many seconds --safe-slave-backup should wait for
Slave_open_temp_tables to become zero. (default 300)
--close-files Do not keep files opened. This option is passed directly
to xtrabackup. Use at your own risk.
--compact Create a compact backup with all secondary index pages
omitted. This option is passed directly to xtrabackup.
See xtrabackup documentation for details.
--compress[=name] This option instructs xtrabackup to compress backup
copies of InnoDB data files. It is passed directly to the
xtrabackup child process. Try 'xtrabackup --help' for
more details.
--compress-threads=#
This option specifies the number of worker threads that
will be used for parallel compression. It is passed
directly to the xtrabackup child process. Try 'xtrabackup
--help' for more details.
--compress-chunk-size=#
Size of working buffer(s) for compression threads in
bytes. The default value is 64K.
--encrypt=name This option instructs xtrabackup to encrypt backup copies
of InnoDB data files using the algorithm specified in the
ENCRYPTION-ALGORITHM. It is passed directly to the
xtrabackup child process. Try 'xtrabackup --help' for
more details.
--encrypt-key=name This option instructs xtrabackup to use the given
ENCRYPTION-KEY when using the --encrypt or --decrypt
options. During backup it is passed directly to the
xtrabackup child process. Try 'xtrabackup --help' for
more details.
--encrypt-key-file=name
This option instructs xtrabackup to use the encryption
key stored in the given ENCRYPTION-KEY-FILE when using
the --encrypt or --decrypt options.
--encrypt-threads=# This option specifies the number of worker threads that
will be used for parallel encryption. It is passed
directly to the xtrabackup child process. Try 'xtrabackup
--help' for more details.
--encrypt-chunk-size=#
This option specifies the size of the internal working
buffer for each encryption thread, measured in bytes. It
is passed directly to the xtrabackup child process. Try
'xtrabackup --help' for more details.
--export This option is passed directly to xtrabackup's --export
option. It enables exporting individual tables for import
into another server. See the xtrabackup documentation for
details.
--extra-lsndir=name This option specifies the directory in which to save an
extra copy of the "xtrabackup_checkpoints" file. The
option accepts a string argument. It is passed directly
to xtrabackup's --extra-lsndir option. See the xtrabackup
documentation for details.
--incremental-basedir=name
This option specifies the directory containing the full
backup that is the base dataset for the incremental
backup. The option accepts a string argument. It is used
with the --incremental option.
--incremental-dir=name
This option specifies the directory where the incremental
backup will be combined with the full backup to make a
new full backup. The option accepts a string argument.
It is used with the --incremental option.
--incremental-force-scan
This options tells xtrabackup to perform full scan of
data files for taking an incremental backup even if full
changed page bitmap data is available to enable the
backup without the full scan.
--log-copy-interval=#
This option specifies time interval between checks done
by log copying thread in milliseconds.
--incremental-lsn=name
This option specifies the log sequence number (LSN) to
use for the incremental backup. The option accepts a
string argument. It is used with the --incremental
option. It is used instead of specifying
--incremental-basedir. For databases created by MySQL and
Percona Server 5.0-series versions, specify the LSN as
two 32-bit integers in high:low format. For databases
created in 5.1 and later, specify the LSN as a single
64-bit integer.
--parallel=# On backup, this option specifies the number of threads
the xtrabackup child process should use to back up files
concurrently. The option accepts an integer argument. It
is passed directly to xtrabackup's --parallel option. See
the xtrabackup documentation for details.
--rebuild-indexes This option only has effect when used together with the
--apply-log option and is passed directly to xtrabackup.
When used, makes xtrabackup rebuild all secondary indexes
after applying the log. This option is normally used to
prepare compact backups. See the XtraBackup manual for
more information.
--rebuild-threads=# Use this number of threads to rebuild indexes in a
compact backup. Only has effect with --prepare and
--rebuild-indexes.
--stream=name This option specifies the format in which to do the
streamed backup. The option accepts a string argument.
The backup will be done to STDOUT in the specified
format. Currently, the only supported formats are tar and
xbstream. This option is passed directly to xtrabackup's
--stream option.
--tables-file=name This option specifies the file in which there are a list
of names of the form database. The option accepts a
string argument.table, one per line. The option is passed
directly to xtrabackup's --tables-file option.
--throttle=# This option specifies a number of I/O operations (pairs
of read+write) per second. It accepts an integer
argument. It is passed directly to xtrabackup's
--throttle option.
-t, --tmpdir=name This option specifies the location where a temporary
files will be stored. If the option is not specified, the
default is to use the value of tmpdir read from the
server configuration.
--use-memory=# This option accepts a string argument that specifies the
amount of memory in bytes for xtrabackup to use for crash
recovery while preparing a backup. Multiples are
supported providing the unit (e.g. 1MB, 1GB). It is used
only with the option --apply-log. It is passed directly
to xtrabackup's --use-memory option. See the xtrabackup
documentation for details.
备份过程
start xtrabackup_log
copy .ibd;ibdata1
FLUSH TABLES WITH READ LOCK
copy .FRM;MYD;MYI;misc files
Get binary log position
UNLOCK TABLES
stop and copy xtrabackup_log
备份开始时首先会开启一个后台检测进程,实时检测mysql redo的变化,一旦发现redo中有新的日志写入,立刻将日志记入后台日志文件xtrabackup_log中。之后复制innodb的数据文件和系统表空间文件ibdata1,待复制结束后,执行flush tables with read lock操作,复制.frm,MYI,MYD,等文件(执行flush tableswith read lock的目的是为了防止数据表发生DDL操作,并且在这一时刻获得binlog的位置)最后会发出unlock tables,把表设置为可读可写状态,最终停止xtrabackup_log
190818 19:14:02 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!".
Can't locate Digest/MD5.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at - line 693.
BEGIN failed--compilation aborted at - line 693.
190818 19:14:02 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /tmp/mysql.sock
Using server version 5.7.24-log
innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/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
190818 19:14:02 >> log scanned up to (2592084)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
190818 19:14:02 [01] Copying ./ibdata1 to /root/back/2019-08-18_19-14-02/ibdata1
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/plugin.ibd to /root/back/2019-08-18_19-14-02/mysql/plugin.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/servers.ibd to /root/back/2019-08-18_19-14-02/mysql/servers.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/help_topic.ibd to /root/back/2019-08-18_19-14-02/mysql/help_topic.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/help_category.ibd to /root/back/2019-08-18_19-14-02/mysql/help_category.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/help_relation.ibd to /root/back/2019-08-18_19-14-02/mysql/help_relation.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/help_keyword.ibd to /root/back/2019-08-18_19-14-02/mysql/help_keyword.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/time_zone_name.ibd to /root/back/2019-08-18_19-14-02/mysql/time_zone_name.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/time_zone.ibd to /root/back/2019-08-18_19-14-02/mysql/time_zone.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/time_zone_transition.ibd to /root/back/2019-08-18_19-14-02/mysql/time_zone_transition.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/time_zone_transition_type.ibd to /root/back/2019-08-18_19-14-02/mysql/time_zone_transition_type.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/time_zone_leap_second.ibd to /root/back/2019-08-18_19-14-02/mysql/time_zone_leap_second.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/innodb_table_stats.ibd to /root/back/2019-08-18_19-14-02/mysql/innodb_table_stats.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/innodb_index_stats.ibd to /root/back/2019-08-18_19-14-02/mysql/innodb_index_stats.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/slave_relay_log_info.ibd to /root/back/2019-08-18_19-14-02/mysql/slave_relay_log_info.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/slave_master_info.ibd to /root/back/2019-08-18_19-14-02/mysql/slave_master_info.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/slave_worker_info.ibd to /root/back/2019-08-18_19-14-02/mysql/slave_worker_info.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/gtid_executed.ibd to /root/back/2019-08-18_19-14-02/mysql/gtid_executed.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/server_cost.ibd to /root/back/2019-08-18_19-14-02/mysql/server_cost.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./mysql/engine_cost.ibd to /root/back/2019-08-18_19-14-02/mysql/engine_cost.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./sys/sys_config.ibd to /root/back/2019-08-18_19-14-02/sys/sys_config.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./crm/crm_action_log.ibd to /root/back/2019-08-18_19-14-02/crm/crm_action_log.ibd
190818 19:14:02 [01] ...done
190818 19:14:02 [01] Copying ./crm/crm_user.ibd to /root/back/2019-08-18_19-14-02/crm/crm_user.ibd
190818 19:14:02 [01] ...done
190818 19:14:03 >> log scanned up to (2592084)
190818 19:14:03 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
190818 19:14:03 Executing FLUSH TABLES WITH READ LOCK...
190818 19:14:03 Starting to backup non-InnoDB tables and files
190818 19:14:03 [01] Copying ./mysql/db.opt to /root/back/2019-08-18_19-14-02/mysql/db.opt
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/db.frm to /root/back/2019-08-18_19-14-02/mysql/db.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/db.MYI to /root/back/2019-08-18_19-14-02/mysql/db.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/db.MYD to /root/back/2019-08-18_19-14-02/mysql/db.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/user.frm to /root/back/2019-08-18_19-14-02/mysql/user.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/user.MYI to /root/back/2019-08-18_19-14-02/mysql/user.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/user.MYD to /root/back/2019-08-18_19-14-02/mysql/user.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/func.frm to /root/back/2019-08-18_19-14-02/mysql/func.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/func.MYI to /root/back/2019-08-18_19-14-02/mysql/func.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/func.MYD to /root/back/2019-08-18_19-14-02/mysql/func.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/plugin.frm to /root/back/2019-08-18_19-14-02/mysql/plugin.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/servers.frm to /root/back/2019-08-18_19-14-02/mysql/servers.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/tables_priv.frm to /root/back/2019-08-18_19-14-02/mysql/tables_priv.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/tables_priv.MYI to /root/back/2019-08-18_19-14-02/mysql/tables_priv.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/tables_priv.MYD to /root/back/2019-08-18_19-14-02/mysql/tables_priv.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/columns_priv.frm to /root/back/2019-08-18_19-14-02/mysql/columns_priv.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/columns_priv.MYI to /root/back/2019-08-18_19-14-02/mysql/columns_priv.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/columns_priv.MYD to /root/back/2019-08-18_19-14-02/mysql/columns_priv.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/help_topic.frm to /root/back/2019-08-18_19-14-02/mysql/help_topic.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/help_category.frm to /root/back/2019-08-18_19-14-02/mysql/help_category.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/help_relation.frm to /root/back/2019-08-18_19-14-02/mysql/help_relation.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/help_keyword.frm to /root/back/2019-08-18_19-14-02/mysql/help_keyword.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/time_zone_name.frm to /root/back/2019-08-18_19-14-02/mysql/time_zone_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/time_zone.frm to /root/back/2019-08-18_19-14-02/mysql/time_zone.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/time_zone_transition.frm to /root/back/2019-08-18_19-14-02/mysql/time_zone_transition.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/time_zone_transition_type.frm to /root/back/2019-08-18_19-14-02/mysql/time_zone_transition_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/time_zone_leap_second.frm to /root/back/2019-08-18_19-14-02/mysql/time_zone_leap_second.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proc.frm to /root/back/2019-08-18_19-14-02/mysql/proc.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proc.MYI to /root/back/2019-08-18_19-14-02/mysql/proc.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proc.MYD to /root/back/2019-08-18_19-14-02/mysql/proc.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/procs_priv.frm to /root/back/2019-08-18_19-14-02/mysql/procs_priv.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/procs_priv.MYI to /root/back/2019-08-18_19-14-02/mysql/procs_priv.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/procs_priv.MYD to /root/back/2019-08-18_19-14-02/mysql/procs_priv.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/general_log.frm to /root/back/2019-08-18_19-14-02/mysql/general_log.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/general_log.CSM to /root/back/2019-08-18_19-14-02/mysql/general_log.CSM
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/general_log.CSV to /root/back/2019-08-18_19-14-02/mysql/general_log.CSV
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slow_log.frm to /root/back/2019-08-18_19-14-02/mysql/slow_log.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slow_log.CSM to /root/back/2019-08-18_19-14-02/mysql/slow_log.CSM
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slow_log.CSV to /root/back/2019-08-18_19-14-02/mysql/slow_log.CSV
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/event.frm to /root/back/2019-08-18_19-14-02/mysql/event.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/event.MYI to /root/back/2019-08-18_19-14-02/mysql/event.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/event.MYD to /root/back/2019-08-18_19-14-02/mysql/event.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/ndb_binlog_index.frm to /root/back/2019-08-18_19-14-02/mysql/ndb_binlog_index.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/ndb_binlog_index.MYI to /root/back/2019-08-18_19-14-02/mysql/ndb_binlog_index.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/ndb_binlog_index.MYD to /root/back/2019-08-18_19-14-02/mysql/ndb_binlog_index.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/innodb_table_stats.frm to /root/back/2019-08-18_19-14-02/mysql/innodb_table_stats.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/innodb_index_stats.frm to /root/back/2019-08-18_19-14-02/mysql/innodb_index_stats.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slave_relay_log_info.frm to /root/back/2019-08-18_19-14-02/mysql/slave_relay_log_info.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slave_master_info.frm to /root/back/2019-08-18_19-14-02/mysql/slave_master_info.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/slave_worker_info.frm to /root/back/2019-08-18_19-14-02/mysql/slave_worker_info.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/gtid_executed.frm to /root/back/2019-08-18_19-14-02/mysql/gtid_executed.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/server_cost.frm to /root/back/2019-08-18_19-14-02/mysql/server_cost.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/engine_cost.frm to /root/back/2019-08-18_19-14-02/mysql/engine_cost.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proxies_priv.frm to /root/back/2019-08-18_19-14-02/mysql/proxies_priv.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proxies_priv.MYI to /root/back/2019-08-18_19-14-02/mysql/proxies_priv.MYI
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./mysql/proxies_priv.MYD to /root/back/2019-08-18_19-14-02/mysql/proxies_priv.MYD
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/db.opt to /root/back/2019-08-18_19-14-02/sys/db.opt
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/version.frm to /root/back/2019-08-18_19-14-02/sys/version.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/sys_config.frm to /root/back/2019-08-18_19-14-02/sys/sys_config.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statements_with_full_table_scans.frm to /root/back/2019-08-18_19-14-02/sys/statements_with_full_table_scans.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/sys_config_insert_set_user.TRN to /root/back/2019-08-18_19-14-02/sys/sys_config_insert_set_user.TRN
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/processlist.frm to /root/back/2019-08-18_19-14-02/sys/processlist.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/sys_config.TRG to /root/back/2019-08-18_19-14-02/sys/sys_config.TRG
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statements_with_sorting.frm to /root/back/2019-08-18_19-14-02/sys/statements_with_sorting.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/sys_config_update_set_user.TRN to /root/back/2019-08-18_19-14-02/sys/sys_config_update_set_user.TRN
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statements_with_sorting.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statements_with_sorting.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /root/back/2019-08-18_19-14-02/sys/innodb_buffer_stats_by_schema.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_index_statistics.frm to /root/back/2019-08-18_19-14-02/sys/schema_index_statistics.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /root/back/2019-08-18_19-14-02/sys/x@0024innodb_buffer_stats_by_schema.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statements_with_temp_tables.frm to /root/back/2019-08-18_19-14-02/sys/statements_with_temp_tables.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /root/back/2019-08-18_19-14-02/sys/innodb_buffer_stats_by_table.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /root/back/2019-08-18_19-14-02/sys/x@0024ps_schema_table_statistics_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /root/back/2019-08-18_19-14-02/sys/x@0024innodb_buffer_stats_by_table.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary.frm to /root/back/2019-08-18_19-14-02/sys/host_summary.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/innodb_lock_waits.frm to /root/back/2019-08-18_19-14-02/sys/innodb_lock_waits.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /root/back/2019-08-18_19-14-02/sys/x@0024innodb_lock_waits.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/waits_by_user_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/waits_by_user_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_object_overview.frm to /root/back/2019-08-18_19-14-02/sys/schema_object_overview.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary_by_file_io_type.frm to /root/back/2019-08-18_19-14-02/sys/user_summary_by_file_io_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_auto_increment_columns.frm to /root/back/2019-08-18_19-14-02/sys/schema_auto_increment_columns.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary_by_file_io.frm to /root/back/2019-08-18_19-14-02/sys/user_summary_by_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_flattened_keys.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary_by_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_redundant_indexes.frm to /root/back/2019-08-18_19-14-02/sys/schema_redundant_indexes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary_by_statement_type.frm to /root/back/2019-08-18_19-14-02/sys/user_summary_by_statement_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /root/back/2019-08-18_19-14-02/sys/ps_check_lost_instrumentation.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/latest_file_io.frm to /root/back/2019-08-18_19-14-02/sys/latest_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/waits_by_host_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/waits_by_host_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024latest_file_io.frm to /root/back/2019-08-18_19-14-02/sys/x@0024latest_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/waits_global_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/waits_global_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/io_by_thread_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/io_by_thread_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary_by_stages.frm to /root/back/2019-08-18_19-14-02/sys/user_summary_by_stages.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024io_by_thread_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary_by_stages.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /root/back/2019-08-18_19-14-02/sys/io_global_by_file_by_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_index_statistics.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_index_statistics.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024io_global_by_file_by_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary.frm to /root/back/2019-08-18_19-14-02/sys/user_summary.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/io_global_by_file_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/io_global_by_file_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_table_statistics.frm to /root/back/2019-08-18_19-14-02/sys/schema_table_statistics.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024io_global_by_file_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /root/back/2019-08-18_19-14-02/sys/io_global_by_wait_by_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_table_statistics.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_table_statistics.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024io_global_by_wait_by_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary_by_file_io_type.frm to /root/back/2019-08-18_19-14-02/sys/host_summary_by_file_io_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/io_global_by_wait_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /root/back/2019-08-18_19-14-02/sys/schema_table_statistics_with_buffer.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024io_global_by_wait_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary_by_file_io.frm to /root/back/2019-08-18_19-14-02/sys/host_summary_by_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/memory_by_user_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_table_lock_waits.frm to /root/back/2019-08-18_19-14-02/sys/schema_table_lock_waits.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024memory_by_user_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary_by_file_io.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/memory_by_host_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_table_lock_waits.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024memory_by_host_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statement_analysis.frm to /root/back/2019-08-18_19-14-02/sys/statement_analysis.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/memory_by_thread_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statement_analysis.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statement_analysis.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024memory_by_thread_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary_by_statement_type.frm to /root/back/2019-08-18_19-14-02/sys/host_summary_by_statement_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/memory_global_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/memory_global_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /root/back/2019-08-18_19-14-02/sys/statements_with_errors_or_warnings.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /root/back/2019-08-18_19-14-02/sys/x@0024memory_global_by_current_bytes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/metrics.frm to /root/back/2019-08-18_19-14-02/sys/metrics.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/memory_global_total.frm to /root/back/2019-08-18_19-14-02/sys/memory_global_total.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary_by_stages.frm to /root/back/2019-08-18_19-14-02/sys/host_summary_by_stages.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024memory_global_total.frm to /root/back/2019-08-18_19-14-02/sys/x@0024memory_global_total.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/session.frm to /root/back/2019-08-18_19-14-02/sys/session.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_table_statistics_with_buffer.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statements_with_errors_or_warnings.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /root/back/2019-08-18_19-14-02/sys/schema_tables_with_full_table_scans.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/schema_unused_indexes.frm to /root/back/2019-08-18_19-14-02/sys/schema_unused_indexes.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /root/back/2019-08-18_19-14-02/sys/x@0024schema_tables_with_full_table_scans.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary_by_stages.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statements_with_full_table_scans.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /root/back/2019-08-18_19-14-02/sys/x@0024ps_digest_avg_latency_distribution.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /root/back/2019-08-18_19-14-02/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /root/back/2019-08-18_19-14-02/sys/statements_with_runtimes_in_95th_percentile.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /root/back/2019-08-18_19-14-02/sys/x@0024statements_with_temp_tables.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary_by_file_io_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary_by_statement_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/user_summary_by_statement_latency.frm to /root/back/2019-08-18_19-14-02/sys/user_summary_by_statement_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024user_summary_by_statement_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary_by_file_io_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary_by_statement_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/host_summary_by_statement_latency.frm to /root/back/2019-08-18_19-14-02/sys/host_summary_by_statement_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024host_summary_by_statement_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /root/back/2019-08-18_19-14-02/sys/wait_classes_global_by_avg_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024wait_classes_global_by_avg_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/wait_classes_global_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/wait_classes_global_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024wait_classes_global_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024waits_by_user_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024waits_by_host_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /root/back/2019-08-18_19-14-02/sys/x@0024waits_global_by_latency.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024processlist.frm to /root/back/2019-08-18_19-14-02/sys/x@0024processlist.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/x@0024session.frm to /root/back/2019-08-18_19-14-02/sys/x@0024session.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./sys/session_ssl_status.frm to /root/back/2019-08-18_19-14-02/sys/session_ssl_status.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./crm/db.opt to /root/back/2019-08-18_19-14-02/crm/db.opt
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./crm/crm_action_log.frm to /root/back/2019-08-18_19-14-02/crm/crm_action_log.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./crm/crm_user.frm to /root/back/2019-08-18_19-14-02/crm/crm_user.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/db.opt to /root/back/2019-08-18_19-14-02/performance_schema/db.opt
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/cond_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/cond_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_current.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_current.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_history.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_history.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_history_long.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_history_long.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_by_instance.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_by_host_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_by_user_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_by_account_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_by_thread_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_waits_summary_global_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/file_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/file_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/file_summary_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/file_summary_by_instance.frm to /root/back/2019-08-18_19-14-02/performance_schema/file_summary_by_instance.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/socket_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/socket_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /root/back/2019-08-18_19-14-02/performance_schema/socket_summary_by_instance.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/socket_summary_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/host_cache.frm to /root/back/2019-08-18_19-14-02/performance_schema/host_cache.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/mutex_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/mutex_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /root/back/2019-08-18_19-14-02/performance_schema/objects_summary_global_by_type.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/performance_timers.frm to /root/back/2019-08-18_19-14-02/performance_schema/performance_timers.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/rwlock_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/rwlock_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/setup_actors.frm to /root/back/2019-08-18_19-14-02/performance_schema/setup_actors.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/setup_consumers.frm to /root/back/2019-08-18_19-14-02/performance_schema/setup_consumers.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/setup_instruments.frm to /root/back/2019-08-18_19-14-02/performance_schema/setup_instruments.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/setup_objects.frm to /root/back/2019-08-18_19-14-02/performance_schema/setup_objects.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/setup_timers.frm to /root/back/2019-08-18_19-14-02/performance_schema/setup_timers.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /root/back/2019-08-18_19-14-02/performance_schema/table_io_waits_summary_by_index_usage.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /root/back/2019-08-18_19-14-02/performance_schema/table_io_waits_summary_by_table.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /root/back/2019-08-18_19-14-02/performance_schema/table_lock_waits_summary_by_table.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/threads.frm to /root/back/2019-08-18_19-14-02/performance_schema/threads.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_current.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_current.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_history.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_history.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_history_long.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_history_long.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_summary_by_thread_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_summary_by_host_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_summary_by_user_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_summary_by_account_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_stages_summary_global_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_current.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_current.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_history.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_history.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_history_long.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_history_long.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_thread_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_host_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_user_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_account_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_global_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_current.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_current.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_history.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_history.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_history_long.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_history_long.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_summary_by_host_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_summary_by_user_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_summary_by_account_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_transactions_summary_global_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/hosts.frm to /root/back/2019-08-18_19-14-02/performance_schema/hosts.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/users.frm to /root/back/2019-08-18_19-14-02/performance_schema/users.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/accounts.frm to /root/back/2019-08-18_19-14-02/performance_schema/accounts.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/memory_summary_global_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/memory_summary_by_thread_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/memory_summary_by_account_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/memory_summary_by_host_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /root/back/2019-08-18_19-14-02/performance_schema/memory_summary_by_user_by_event_name.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_digest.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /root/back/2019-08-18_19-14-02/performance_schema/events_statements_summary_by_program.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/prepared_statements_instances.frm to /root/back/2019-08-18_19-14-02/performance_schema/prepared_statements_instances.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_connection_configuration.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_connection_configuration.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_group_member_stats.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_group_member_stats.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_group_members.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_group_members.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_connection_status.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_connection_status.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_applier_configuration.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_applier_configuration.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_applier_status.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_applier_status.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_applier_status_by_coordinator.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /root/back/2019-08-18_19-14-02/performance_schema/replication_applier_status_by_worker.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/session_connect_attrs.frm to /root/back/2019-08-18_19-14-02/performance_schema/session_connect_attrs.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /root/back/2019-08-18_19-14-02/performance_schema/session_account_connect_attrs.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/table_handles.frm to /root/back/2019-08-18_19-14-02/performance_schema/table_handles.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/metadata_locks.frm to /root/back/2019-08-18_19-14-02/performance_schema/metadata_locks.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/user_variables_by_thread.frm to /root/back/2019-08-18_19-14-02/performance_schema/user_variables_by_thread.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/variables_by_thread.frm to /root/back/2019-08-18_19-14-02/performance_schema/variables_by_thread.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/global_variables.frm to /root/back/2019-08-18_19-14-02/performance_schema/global_variables.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/session_variables.frm to /root/back/2019-08-18_19-14-02/performance_schema/session_variables.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/status_by_thread.frm to /root/back/2019-08-18_19-14-02/performance_schema/status_by_thread.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/status_by_user.frm to /root/back/2019-08-18_19-14-02/performance_schema/status_by_user.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/status_by_host.frm to /root/back/2019-08-18_19-14-02/performance_schema/status_by_host.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/status_by_account.frm to /root/back/2019-08-18_19-14-02/performance_schema/status_by_account.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/global_status.frm to /root/back/2019-08-18_19-14-02/performance_schema/global_status.frm
190818 19:14:03 [01] ...done
190818 19:14:03 [01] Copying ./performance_schema/session_status.frm to /root/back/2019-08-18_19-14-02/performance_schema/session_status.frm
190818 19:14:03 [01] ...done
190818 19:14:03 Finished backing up non-InnoDB tables and files
190818 19:14:03 [00] Writing xtrabackup_binlog_info
190818 19:14:03 [00] ...done
190818 19:14:03 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '2592075'
xtrabackup: Stopping log copying thread.
.190818 19:14:03 >> log scanned up to (2592084)
190818 19:14:03 Executing UNLOCK TABLES
190818 19:14:03 All tables unlocked
190818 19:14:03 [00] Copying ib_buffer_pool to /root/back/2019-08-18_19-14-02/ib_buffer_pool
190818 19:14:03 [00] ...done
190818 19:14:03 Backup created in directory '/root/back/2019-08-18_19-14-02'
MySQL binlog position: filename 'localhost-bin.000001', position '154'
190818 19:14:03 [00] Writing backup-my.cnf
190818 19:14:03 [00] ...done
190818 19:14:03 [00] Writing xtrabackup_info
190818 19:14:03 [00] ...done
xtrabackup: Transaction log of lsn (2592075) to (2592084) was copied.
190818 19:14:04 completed OK!