# mariabackup -u root -p1 --backup  --rsync=avrP --target-dir=/var/mariadb/backup005
Warning: mariabackup: ignoring option '--rsync' due to invalid value 'avrP'
180221 20:14:56 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Using server version 10.2.13-MariaDB
mariabackup based on MariaDB server 10.2.13-MariaDB Linux (x86_64)
mariabackup: uses posix_fadvise().
mariabackup: cd to /var/lib/mysql/
mariabackup: open files limit requested 0, set to 1024
mariabackup: using the following InnoDB configuration:
mariabackup:   innodb_data_home_dir = .
mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
mariabackup:   innodb_log_group_home_dir = ./
2018-02-21 20:14:56 139827414505600 [Note] InnoDB: Number of pools: 1
180221 20:14:56 >> log scanned up to (3320086732)
mariabackup: Generating a list of tablespaces
2018-02-21 20:14:56 139827414505600 [Warning] InnoDB: Allocated tablespace ID 16 for sbtest/sbtest1, old maximum was 0
180221 20:14:56 [01] Copying ./ibdata1 to /var/mariadb/backup005/ibdata1
180221 20:14:57 >> log scanned up to (3320086732)
180221 20:14:58 [01]        ...done
180221 20:14:58 [01] Copying ./sbtest/sbtest1.ibd to /var/mariadb/backup005/sbtest/sbtest1.ibd
180221 20:15:14 [01]        ...done
180221 20:15:14 [01] Copying ./mysql/innodb_table_stats.ibd to /var/mariadb/backup005/mysql/innodb_table_stats.ibd
180221 20:15:14 [01]        ...done
180221 20:15:14 [01] Copying ./mysql/innodb_index_stats.ibd to /var/mariadb/backup005/mysql/innodb_index_stats.ibd
180221 20:15:14 [01]        ...done
180221 20:15:14 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/mariadb/backup005/mysql/gtid_slave_pos.ibd
180221 20:15:14 [01]        ...done
180221 20:15:14 [01] Copying ./foo/testconv.ibd to /var/mariadb/backup005/foo/testconv.ibd
180221 20:15:14 [01]        ...done
180221 20:15:15 [01] Copying ./foo/account.ibd to /var/mariadb/backup005/foo/account.ibd
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./foo/counter.ibd to /var/mariadb/backup005/foo/counter.ibd
180221 20:15:15 [01]        ...done
180221 20:15:15 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
180221 20:15:15 Executing FLUSH TABLES WITH READ LOCK...
180221 20:15:15 Starting to backup non-InnoDB tables and files
180221 20:15:15 [01] Copying ./sbtest/db.opt to /var/mariadb/backup005/sbtest/db.opt
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./sbtest/sbtest1.frm to /var/mariadb/backup005/sbtest/sbtest1.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/db.frm to /var/mariadb/backup005/mysql/db.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/db.MYI to /var/mariadb/backup005/mysql/db.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/db.MYD to /var/mariadb/backup005/mysql/db.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/host.frm to /var/mariadb/backup005/mysql/host.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/host.MYI to /var/mariadb/backup005/mysql/host.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/host.MYD to /var/mariadb/backup005/mysql/host.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/user.frm to /var/mariadb/backup005/mysql/user.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/user.MYI to /var/mariadb/backup005/mysql/user.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/user.MYD to /var/mariadb/backup005/mysql/user.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/roles_mapping.frm to /var/mariadb/backup005/mysql/roles_mapping.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/roles_mapping.MYI to /var/mariadb/backup005/mysql/roles_mapping.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/roles_mapping.MYD to /var/mariadb/backup005/mysql/roles_mapping.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/func.frm to /var/mariadb/backup005/mysql/func.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/func.MYI to /var/mariadb/backup005/mysql/func.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/func.MYD to /var/mariadb/backup005/mysql/func.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/plugin.frm to /var/mariadb/backup005/mysql/plugin.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/plugin.MYI to /var/mariadb/backup005/mysql/plugin.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/plugin.MYD to /var/mariadb/backup005/mysql/plugin.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/servers.frm to /var/mariadb/backup005/mysql/servers.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/servers.MYI to /var/mariadb/backup005/mysql/servers.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/servers.MYD to /var/mariadb/backup005/mysql/servers.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/tables_priv.frm to /var/mariadb/backup005/mysql/tables_priv.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/tables_priv.MYI to /var/mariadb/backup005/mysql/tables_priv.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/tables_priv.MYD to /var/mariadb/backup005/mysql/tables_priv.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/columns_priv.frm to /var/mariadb/backup005/mysql/columns_priv.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/columns_priv.MYI to /var/mariadb/backup005/mysql/columns_priv.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/columns_priv.MYD to /var/mariadb/backup005/mysql/columns_priv.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_topic.frm to /var/mariadb/backup005/mysql/help_topic.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_topic.MYI to /var/mariadb/backup005/mysql/help_topic.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_topic.MYD to /var/mariadb/backup005/mysql/help_topic.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_category.frm to /var/mariadb/backup005/mysql/help_category.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_category.MYI to /var/mariadb/backup005/mysql/help_category.MYI
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_category.MYD to /var/mariadb/backup005/mysql/help_category.MYD
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_relation.frm to /var/mariadb/backup005/mysql/help_relation.frm
180221 20:15:15 [01]        ...done
180221 20:15:15 [01] Copying ./mysql/help_relation.MYI to /var/mariadb/backup005/mysql/help_relation.MYI
180221 20:15:15 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/help_relation.MYD to /var/mariadb/backup005/mysql/help_relation.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/help_keyword.frm to /var/mariadb/backup005/mysql/help_keyword.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/help_keyword.MYI to /var/mariadb/backup005/mysql/help_keyword.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/help_keyword.MYD to /var/mariadb/backup005/mysql/help_keyword.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_name.frm to /var/mariadb/backup005/mysql/time_zone_name.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_name.MYI to /var/mariadb/backup005/mysql/time_zone_name.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_name.MYD to /var/mariadb/backup005/mysql/time_zone_name.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone.frm to /var/mariadb/backup005/mysql/time_zone.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone.MYI to /var/mariadb/backup005/mysql/time_zone.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone.MYD to /var/mariadb/backup005/mysql/time_zone.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition.frm to /var/mariadb/backup005/mysql/time_zone_transition.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition.MYI to /var/mariadb/backup005/mysql/time_zone_transition.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition.MYD to /var/mariadb/backup005/mysql/time_zone_transition.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition_type.frm to /var/mariadb/backup005/mysql/time_zone_transition_type.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/mariadb/backup005/mysql/time_zone_transition_type.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/mariadb/backup005/mysql/time_zone_transition_type.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_leap_second.frm to /var/mariadb/backup005/mysql/time_zone_leap_second.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/mariadb/backup005/mysql/time_zone_leap_second.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/mariadb/backup005/mysql/time_zone_leap_second.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proc.frm to /var/mariadb/backup005/mysql/proc.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proc.MYI to /var/mariadb/backup005/mysql/proc.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proc.MYD to /var/mariadb/backup005/mysql/proc.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/procs_priv.frm to /var/mariadb/backup005/mysql/procs_priv.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/procs_priv.MYI to /var/mariadb/backup005/mysql/procs_priv.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/procs_priv.MYD to /var/mariadb/backup005/mysql/procs_priv.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/general_log.frm to /var/mariadb/backup005/mysql/general_log.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/general_log.CSM to /var/mariadb/backup005/mysql/general_log.CSM
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/general_log.CSV to /var/mariadb/backup005/mysql/general_log.CSV
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/slow_log.frm to /var/mariadb/backup005/mysql/slow_log.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/slow_log.CSM to /var/mariadb/backup005/mysql/slow_log.CSM
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/slow_log.CSV to /var/mariadb/backup005/mysql/slow_log.CSV
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/event.frm to /var/mariadb/backup005/mysql/event.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/event.MYI to /var/mariadb/backup005/mysql/event.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/event.MYD to /var/mariadb/backup005/mysql/event.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/innodb_table_stats.frm to /var/mariadb/backup005/mysql/innodb_table_stats.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/innodb_index_stats.frm to /var/mariadb/backup005/mysql/innodb_index_stats.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proxies_priv.frm to /var/mariadb/backup005/mysql/proxies_priv.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proxies_priv.MYI to /var/mariadb/backup005/mysql/proxies_priv.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/proxies_priv.MYD to /var/mariadb/backup005/mysql/proxies_priv.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/table_stats.frm to /var/mariadb/backup005/mysql/table_stats.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/table_stats.MYI to /var/mariadb/backup005/mysql/table_stats.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/table_stats.MYD to /var/mariadb/backup005/mysql/table_stats.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/column_stats.frm to /var/mariadb/backup005/mysql/column_stats.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/column_stats.MYI to /var/mariadb/backup005/mysql/column_stats.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/column_stats.MYD to /var/mariadb/backup005/mysql/column_stats.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/index_stats.frm to /var/mariadb/backup005/mysql/index_stats.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/index_stats.MYI to /var/mariadb/backup005/mysql/index_stats.MYI
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/index_stats.MYD to /var/mariadb/backup005/mysql/index_stats.MYD
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./mysql/gtid_slave_pos.frm to /var/mariadb/backup005/mysql/gtid_slave_pos.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./foo/db.opt to /var/mariadb/backup005/foo/db.opt
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./foo/testconv.frm to /var/mariadb/backup005/foo/testconv.frm
180221 20:15:16 [01]        ...done
180221 20:15:16 [01] Copying ./foo/account.frm to /var/mariadb/backup005/foo/account.frm
180221 20:15:16 [01]        ...done
180221 20:15:17 [01] Copying ./foo/counter.frm to /var/mariadb/backup005/foo/counter.frm
180221 20:15:17 [01]        ...done
180221 20:15:17 [01] Copying ./test/db.opt to /var/mariadb/backup005/test/db.opt
180221 20:15:17 [01]        ...done
180221 20:15:17 [01] Copying ./performance_schema/db.opt to /var/mariadb/backup005/performance_schema/db.opt
180221 20:15:17 [01]        ...done
180221 20:15:17 Finished backing up non-InnoDB tables and files
180221 20:15:17 [01] Copying aria_log_control to /var/mariadb/backup005/aria_log_control
180221 20:15:17 [01]        ...done
180221 20:15:17 [01] Copying aria_log.00000001 to /var/mariadb/backup005/aria_log.00000001
180221 20:15:17 [01]        ...done
180221 20:15:17 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
mariabackup: The latest check point (for incremental): '3320086723'
mariabackup: Stopping log copying thread.

2018-02-21 20:15:17 139827414505600 [Note] InnoDB: Read redo log up to LSN=3320087040
180221 20:15:17 >> log scanned up to (3320086732)
180221 20:15:17 Executing UNLOCK TABLES
180221 20:15:17 All tables unlocked
180221 20:15:17 [00] Copying ib_buffer_pool to /var/mariadb/backup005/ib_buffer_pool
180221 20:15:17 [00]        ...done
180221 20:15:17 Backup created in directory '/var/mariadb/backup005/'
180221 20:15:17 [00] Writing backup-my.cnf
180221 20:15:17 [00]        ...done
180221 20:15:17 [00] Writing xtrabackup_info
180221 20:15:17 [00]        ...done
mariabackup: Redo log (from LSN 3320086723 to 3320086732) was copied.
180221 20:15:17 completed OK!