mariabackup performed by non-root user 'foo4': give to user 'foo4' sudo access edit the /etc/sudoers file and grant sudo access to users in the group wheel [root@t4w6 ~]# sudo usermod -aG wheel foo4 [foo4@t4w6 ~]$ sudo chmod +s /usr/bin/mariabackup [foo4@t4w6 ~]$ sudo chmod g+r /var/lib/mysql/ibdata1 Login as user 'foo4' and perform mariabackup login as: foo4 foo4@t4w6's password: Last login: Wed Apr 11 13:37:25 2018 [foo4@t4w6 ~]$ mariabackup -u root -p1 --backup 180411 13:41:49 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set Using server version 10.3.5-MariaDB mariabackup based on MariaDB server 10.3.5-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-04-11 13:41:49 0 [Note] InnoDB: Number of pools: 1 180411 13:41:49 >> log scanned up to (51002181432) mariabackup: Generating a list of tablespaces 2018-04-11 13:41:49 0 [Warning] InnoDB: Allocated tablespace ID 127 for md_15252/BRc273a13dfd, old maximum was 0 180411 13:41:49 [01] Copying ./ibdata1 to /home/foo4/xtrabackup_backupfiles/ibdata1 180411 13:41:50 >> log scanned up to (51002181432) 180411 13:42:08 [01] ...done 180411 13:42:08 [01] Copying ./md_15252/BRc273a13dfd.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/BRc273a13dfd.ibd 180411 13:42:08 [01] ...done 180411 13:42:08 [01] Copying ./md_15252/CA9176ed2945.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/CA9176ed2945.ibd 180411 13:42:11 [01] ...done 180411 13:42:11 [01] Copying ./md_15252/CA24ade621e4.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/CA24ade621e4.ibd 180411 13:42:11 [01] ...done 180411 13:42:12 [01] Copying ./md_15252/DAc955f09819.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/DAc955f09819.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./md_15252/DAebf122c2a3.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/DAebf122c2a3.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./md_15252/OP3605a09ed5.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/OP3605a09ed5.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./md_15252/PR03645fd534.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/PR03645fd534.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./md_15252/VA13db63946f.ibd to /home/foo4/xtrabackup_backupfiles/md_15252/VA13db63946f.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./rr/r1.ibd to /home/foo4/xtrabackup_backupfiles/rr/r1.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./rr/rr.ibd to /home/foo4/xtrabackup_backupfiles/rr/rr.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./fff/ff.ibd to /home/foo4/xtrabackup_backupfiles/fff/ff.ibd 180411 13:42:12 [01] ...done 180411 13:42:12 [01] Copying ./ff1/ff1.ibd to /home/foo4/xtrabackup_backupfiles/ff1/ff1.ibd 180411 13:42:37 [01] ...done 180411 13:42:38 [01] Copying ./tpcc/CUSTOMER.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/CUSTOMER.ibd 180411 13:42:39 [01] ...done 180411 13:42:39 [01] Copying ./tpcc/DISTRICT.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/DISTRICT.ibd 180411 13:42:39 [01] ...done 180411 13:42:39 [01] Copying ./tpcc/HISTORY.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/HISTORY.ibd 180411 13:42:39 [01] ...done 180411 13:42:39 [01] Copying ./tpcc/ITEM.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/ITEM.ibd 180411 13:42:39 [01] ...done 180411 13:42:40 [01] Copying ./tpcc/NEW_ORDER.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/NEW_ORDER.ibd 180411 13:42:40 [01] ...done 180411 13:42:40 [01] Copying ./tpcc/OORDER.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/OORDER.ibd 180411 13:42:40 [01] ...done 180411 13:42:40 [01] Copying ./tpcc/ORDER_LINE.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/ORDER_LINE.ibd 180411 13:42:41 [01] ...done 180411 13:42:41 [01] Copying ./tpcc/STOCK.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/STOCK.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpcc/WAREHOUSE.ibd to /home/foo4/xtrabackup_backupfiles/tpcc/WAREHOUSE.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./fi/people.ibd to /home/foo4/xtrabackup_backupfiles/fi/people.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./resourcestresser/cputable.ibd to /home/foo4/xtrabackup_backupfiles/resourcestresser/cputable.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./resourcestresser/iotable.ibd to /home/foo4/xtrabackup_backupfiles/resourcestresser/iotable.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./resourcestresser/iotablesmallrow.ibd to /home/foo4/xtrabackup_backupfiles/resourcestresser/iotablesmallrow.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./resourcestresser/locktable.ibd to /home/foo4/xtrabackup_backupfiles/resourcestresser/locktable.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/nation.ibd to /home/foo4/xtrabackup_backupfiles/tpch/nation.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/region.ibd to /home/foo4/xtrabackup_backupfiles/tpch/region.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/part.ibd to /home/foo4/xtrabackup_backupfiles/tpch/part.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/supplier.ibd to /home/foo4/xtrabackup_backupfiles/tpch/supplier.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/partsupp.ibd to /home/foo4/xtrabackup_backupfiles/tpch/partsupp.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/customer.ibd to /home/foo4/xtrabackup_backupfiles/tpch/customer.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/orders.ibd to /home/foo4/xtrabackup_backupfiles/tpch/orders.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./tpch/lineitem.ibd to /home/foo4/xtrabackup_backupfiles/tpch/lineitem.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./mysql/innodb_table_stats.ibd to /home/foo4/xtrabackup_backupfiles/mysql/innodb_table_stats.ibd 180411 13:42:43 [01] ...done 180411 13:42:43 [01] Copying ./mysql/innodb_index_stats.ibd to /home/foo4/xtrabackup_backupfiles/mysql/innodb_index_stats.ibd 180411 13:42:43 [01] ...done 180411 13:42:44 [01] Copying ./mysql/gtid_slave_pos.ibd to /home/foo4/xtrabackup_backupfiles/mysql/gtid_slave_pos.ibd 180411 13:42:44 [01] ...done 180411 13:42:44 [01] Copying ./mysql/transaction_registry.ibd to /home/foo4/xtrabackup_backupfiles/mysql/transaction_registry.ibd 180411 13:42:44 [01] ...done 180411 13:42:44 [01] Copying ./boxoffice_mdb/dim_date.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_date.ibd 180411 13:42:44 [01] ...done 180411 13:42:44 [01] Copying ./boxoffice_mdb/dim_person.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_person.ibd 180411 13:42:44 [01] ...done 180411 13:42:44 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_showtime.ibd 180411 13:42:46 [01] ...done 180411 13:42:46 [01] Copying ./boxoffice_mdb/dim_theater.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_theater.ibd 180411 13:42:46 [01] ...done 180411 13:42:46 [01] Copying ./boxoffice_mdb/dim_theater_mdc.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_theater_mdc.ibd 180411 13:42:46 [01] ...done 180411 13:42:46 [01] Copying ./boxoffice_mdb/dim_ticket_type.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_ticket_type.ibd 180411 13:42:46 [01] ...done 180411 13:42:46 [01] Copying ./boxoffice_mdb/dim_title.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_title.ibd 180411 13:42:46 [01] ...done 180411 13:42:46 [01] Copying ./boxoffice_mdb/fact_crew.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/fact_crew.ibd 180411 13:42:46 [01] ...done 180411 13:42:47 [01] Copying ./boxoffice_mdb/fact_tickets.ibd to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/fact_tickets.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./ff/f1.ibd to /home/foo4/xtrabackup_backupfiles/ff/f1.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./foo/1.ibd to /home/foo4/xtrabackup_backupfiles/foo/1.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./foo/dtest3.ibd to /home/foo4/xtrabackup_backupfiles/foo/dtest3.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./foo/dtest30.ibd to /home/foo4/xtrabackup_backupfiles/foo/dtest30.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./foo/table1.ibd to /home/foo4/xtrabackup_backupfiles/foo/table1.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./foo/table2.ibd to /home/foo4/xtrabackup_backupfiles/foo/table2.ibd 180411 13:42:52 [01] ...done 180411 13:42:52 [01] Copying ./sbtest/sbtest1.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest1.ibd 180411 13:42:53 [01] ...done 180411 13:42:54 [01] Copying ./sbtest/sbtest10.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest10.ibd 180411 13:42:55 [01] ...done 180411 13:42:55 [01] Copying ./sbtest/sbtest2.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest2.ibd 180411 13:42:56 [01] ...done 180411 13:42:56 [01] Copying ./sbtest/sbtest3.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest3.ibd 180411 13:42:57 [01] ...done 180411 13:42:57 [01] Copying ./sbtest/sbtest4.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest4.ibd 180411 13:42:58 [01] ...done 180411 13:42:59 [01] Copying ./sbtest/sbtest5.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest5.ibd 180411 13:43:00 [01] ...done 180411 13:43:00 [01] Copying ./sbtest/sbtest6.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest6.ibd 180411 13:43:01 [01] ...done 180411 13:43:01 [01] Copying ./sbtest/sbtest7.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest7.ibd 180411 13:43:02 [01] ...done 180411 13:43:02 [01] Copying ./sbtest/sbtest8.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest8.ibd 180411 13:43:03 [01] ...done 180411 13:43:03 [01] Copying ./sbtest/sbtest9.ibd to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest9.ibd 180411 13:43:05 [01] ...done 180411 13:43:05 [01] Copying ./mysqlslap/ff1.ibd to /home/foo4/xtrabackup_backupfiles/mysqlslap/ff1.ibd 180411 13:43:05 [01] ...done 180411 13:43:05 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 180411 13:43:05 Executing FLUSH TABLES WITH READ LOCK... 180411 13:43:06 Starting to backup non-InnoDB tables and files 180411 13:43:06 [01] Copying ./md_15252/db.opt to /home/foo4/xtrabackup_backupfiles/md_15252/db.opt 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/BRc273a13dfd.frm to /home/foo4/xtrabackup_backupfiles/md_15252/BRc273a13dfd.frm 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/CA9176ed2945.frm to /home/foo4/xtrabackup_backupfiles/md_15252/CA9176ed2945.frm 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/CA24ade621e4.frm to /home/foo4/xtrabackup_backupfiles/md_15252/CA24ade621e4.frm 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/DAc955f09819.frm to /home/foo4/xtrabackup_backupfiles/md_15252/DAc955f09819.frm 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/DAebf122c2a3.frm to /home/foo4/xtrabackup_backupfiles/md_15252/DAebf122c2a3.frm 180411 13:43:06 [01] ...done 180411 13:43:06 [01] Copying ./md_15252/OP3605a09ed5.frm to /home/foo4/xtrabackup_backupfiles/md_15252/OP3605a09ed5.frm 180411 13:43:06 [01] ...done 180411 13:43:07 [01] Copying ./md_15252/PR03645fd534.frm to /home/foo4/xtrabackup_backupfiles/md_15252/PR03645fd534.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./md_15252/VA13db63946f.frm to /home/foo4/xtrabackup_backupfiles/md_15252/VA13db63946f.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./rr/db.opt to /home/foo4/xtrabackup_backupfiles/rr/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./rr/r1.frm to /home/foo4/xtrabackup_backupfiles/rr/r1.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./rr/rr.frm to /home/foo4/xtrabackup_backupfiles/rr/rr.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./fff/db.opt to /home/foo4/xtrabackup_backupfiles/fff/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./fff/ff.frm to /home/foo4/xtrabackup_backupfiles/fff/ff.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ff1/db.opt to /home/foo4/xtrabackup_backupfiles/ff1/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ff1/ff1.frm to /home/foo4/xtrabackup_backupfiles/ff1/ff1.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./performance_schema/db.opt to /home/foo4/xtrabackup_backupfiles/performance_schema/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpch1/db.opt to /home/foo4/xtrabackup_backupfiles/tpch1/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./test/db.opt to /home/foo4/xtrabackup_backupfiles/test/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ffr/db.opt to /home/foo4/xtrabackup_backupfiles/ffr/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ffr/f.MYI to /home/foo4/xtrabackup_backupfiles/ffr/f.MYI 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ffr/f.MYD to /home/foo4/xtrabackup_backupfiles/ffr/f.MYD 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./ffr/f.frm to /home/foo4/xtrabackup_backupfiles/ffr/f.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/db.opt to /home/foo4/xtrabackup_backupfiles/tpcc/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/CUSTOMER.frm to /home/foo4/xtrabackup_backupfiles/tpcc/CUSTOMER.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/DISTRICT.frm to /home/foo4/xtrabackup_backupfiles/tpcc/DISTRICT.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/HISTORY.frm to /home/foo4/xtrabackup_backupfiles/tpcc/HISTORY.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/ITEM.frm to /home/foo4/xtrabackup_backupfiles/tpcc/ITEM.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/NEW_ORDER.frm to /home/foo4/xtrabackup_backupfiles/tpcc/NEW_ORDER.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/OORDER.frm to /home/foo4/xtrabackup_backupfiles/tpcc/OORDER.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/ORDER_LINE.frm to /home/foo4/xtrabackup_backupfiles/tpcc/ORDER_LINE.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/STOCK.frm to /home/foo4/xtrabackup_backupfiles/tpcc/STOCK.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./tpcc/WAREHOUSE.frm to /home/foo4/xtrabackup_backupfiles/tpcc/WAREHOUSE.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./fi/db.opt to /home/foo4/xtrabackup_backupfiles/fi/db.opt 180411 13:43:07 [01] ...done 180411 13:43:07 [01] Copying ./fi/people.frm to /home/foo4/xtrabackup_backupfiles/fi/people.frm 180411 13:43:07 [01] ...done 180411 13:43:07 [00] Writing b/db.opt 180411 13:43:07 [00] ...done 180411 13:43:08 [01] Copying ./resourcestresser/db.opt to /home/foo4/xtrabackup_backupfiles/resourcestresser/db.opt 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./resourcestresser/cputable.frm to /home/foo4/xtrabackup_backupfiles/resourcestresser/cputable.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./resourcestresser/iotable.frm to /home/foo4/xtrabackup_backupfiles/resourcestresser/iotable.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./resourcestresser/iotablesmallrow.frm to /home/foo4/xtrabackup_backupfiles/resourcestresser/iotablesmallrow.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./resourcestresser/locktable.frm to /home/foo4/xtrabackup_backupfiles/resourcestresser/locktable.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/db.opt to /home/foo4/xtrabackup_backupfiles/tpch/db.opt 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/nation.frm to /home/foo4/xtrabackup_backupfiles/tpch/nation.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/region.frm to /home/foo4/xtrabackup_backupfiles/tpch/region.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/part.frm to /home/foo4/xtrabackup_backupfiles/tpch/part.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/supplier.frm to /home/foo4/xtrabackup_backupfiles/tpch/supplier.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/partsupp.frm to /home/foo4/xtrabackup_backupfiles/tpch/partsupp.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/customer.frm to /home/foo4/xtrabackup_backupfiles/tpch/customer.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/orders.frm to /home/foo4/xtrabackup_backupfiles/tpch/orders.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./tpch/lineitem.frm to /home/foo4/xtrabackup_backupfiles/tpch/lineitem.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/func.MYI to /home/foo4/xtrabackup_backupfiles/mysql/func.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/func.MYD to /home/foo4/xtrabackup_backupfiles/mysql/func.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/proc.MYI to /home/foo4/xtrabackup_backupfiles/mysql/proc.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/host.MYI to /home/foo4/xtrabackup_backupfiles/mysql/host.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/host.MYD to /home/foo4/xtrabackup_backupfiles/mysql/host.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/tables_priv.frm to /home/foo4/xtrabackup_backupfiles/mysql/tables_priv.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/proc.MYD to /home/foo4/xtrabackup_backupfiles/mysql/proc.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/roles_mapping.frm to /home/foo4/xtrabackup_backupfiles/mysql/roles_mapping.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/roles_mapping.MYI to /home/foo4/xtrabackup_backupfiles/mysql/roles_mapping.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/roles_mapping.MYD to /home/foo4/xtrabackup_backupfiles/mysql/roles_mapping.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/db.frm to /home/foo4/xtrabackup_backupfiles/mysql/db.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/plugin.MYI to /home/foo4/xtrabackup_backupfiles/mysql/plugin.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/plugin.MYD to /home/foo4/xtrabackup_backupfiles/mysql/plugin.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/procs_priv.frm to /home/foo4/xtrabackup_backupfiles/mysql/procs_priv.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/servers.frm to /home/foo4/xtrabackup_backupfiles/mysql/servers.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/servers.MYI to /home/foo4/xtrabackup_backupfiles/mysql/servers.MYI 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/servers.MYD to /home/foo4/xtrabackup_backupfiles/mysql/servers.MYD 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/proc.frm to /home/foo4/xtrabackup_backupfiles/mysql/proc.frm 180411 13:43:08 [01] ...done 180411 13:43:08 [01] Copying ./mysql/user.MYI to /home/foo4/xtrabackup_backupfiles/mysql/user.MYI 180411 13:43:08 [01] ...done 180411 13:43:09 [01] Copying ./mysql/columns_priv.MYI to /home/foo4/xtrabackup_backupfiles/mysql/columns_priv.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/columns_priv.MYD to /home/foo4/xtrabackup_backupfiles/mysql/columns_priv.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/columns_priv.frm to /home/foo4/xtrabackup_backupfiles/mysql/columns_priv.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/event.MYD to /home/foo4/xtrabackup_backupfiles/mysql/event.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_topic.frm to /home/foo4/xtrabackup_backupfiles/mysql/help_topic.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_topic.MYI to /home/foo4/xtrabackup_backupfiles/mysql/help_topic.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_topic.MYD to /home/foo4/xtrabackup_backupfiles/mysql/help_topic.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_category.frm to /home/foo4/xtrabackup_backupfiles/mysql/help_category.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_category.MYI to /home/foo4/xtrabackup_backupfiles/mysql/help_category.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_category.MYD to /home/foo4/xtrabackup_backupfiles/mysql/help_category.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_relation.frm to /home/foo4/xtrabackup_backupfiles/mysql/help_relation.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_relation.MYI to /home/foo4/xtrabackup_backupfiles/mysql/help_relation.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_relation.MYD to /home/foo4/xtrabackup_backupfiles/mysql/help_relation.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_keyword.frm to /home/foo4/xtrabackup_backupfiles/mysql/help_keyword.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_keyword.MYI to /home/foo4/xtrabackup_backupfiles/mysql/help_keyword.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/help_keyword.MYD to /home/foo4/xtrabackup_backupfiles/mysql/help_keyword.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_name.frm to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_name.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_name.MYI to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_name.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_name.MYD to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_name.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone.frm to /home/foo4/xtrabackup_backupfiles/mysql/time_zone.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone.MYI to /home/foo4/xtrabackup_backupfiles/mysql/time_zone.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone.MYD to /home/foo4/xtrabackup_backupfiles/mysql/time_zone.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition.frm to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition.MYI to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition.MYD to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition.MYD 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition_type.frm to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition_type.frm 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition_type.MYI to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition_type.MYI 180411 13:43:09 [01] ...done 180411 13:43:09 [01] Copying ./mysql/time_zone_transition_type.MYD to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_transition_type.MYD 180411 13:43:09 [01] ...done 180411 13:43:10 [01] Copying ./mysql/time_zone_leap_second.frm to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_leap_second.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/time_zone_leap_second.MYI to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_leap_second.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/time_zone_leap_second.MYD to /home/foo4/xtrabackup_backupfiles/mysql/time_zone_leap_second.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/db.MYI to /home/foo4/xtrabackup_backupfiles/mysql/db.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/db.MYD to /home/foo4/xtrabackup_backupfiles/mysql/db.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/user.frm to /home/foo4/xtrabackup_backupfiles/mysql/user.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/procs_priv.MYI to /home/foo4/xtrabackup_backupfiles/mysql/procs_priv.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/event.frm to /home/foo4/xtrabackup_backupfiles/mysql/event.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/general_log.frm to /home/foo4/xtrabackup_backupfiles/mysql/general_log.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/general_log.CSM to /home/foo4/xtrabackup_backupfiles/mysql/general_log.CSM 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/general_log.CSV to /home/foo4/xtrabackup_backupfiles/mysql/general_log.CSV 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/slow_log.frm to /home/foo4/xtrabackup_backupfiles/mysql/slow_log.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/slow_log.CSM to /home/foo4/xtrabackup_backupfiles/mysql/slow_log.CSM 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/slow_log.CSV to /home/foo4/xtrabackup_backupfiles/mysql/slow_log.CSV 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/user.MYD to /home/foo4/xtrabackup_backupfiles/mysql/user.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/innodb_table_stats.frm to /home/foo4/xtrabackup_backupfiles/mysql/innodb_table_stats.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/innodb_index_stats.frm to /home/foo4/xtrabackup_backupfiles/mysql/innodb_index_stats.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/tables_priv.MYI to /home/foo4/xtrabackup_backupfiles/mysql/tables_priv.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/func.frm to /home/foo4/xtrabackup_backupfiles/mysql/func.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/proxies_priv.frm to /home/foo4/xtrabackup_backupfiles/mysql/proxies_priv.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/proxies_priv.MYI to /home/foo4/xtrabackup_backupfiles/mysql/proxies_priv.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/proxies_priv.MYD to /home/foo4/xtrabackup_backupfiles/mysql/proxies_priv.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/table_stats.frm to /home/foo4/xtrabackup_backupfiles/mysql/table_stats.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/table_stats.MYI to /home/foo4/xtrabackup_backupfiles/mysql/table_stats.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/table_stats.MYD to /home/foo4/xtrabackup_backupfiles/mysql/table_stats.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/column_stats.frm to /home/foo4/xtrabackup_backupfiles/mysql/column_stats.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/column_stats.MYI to /home/foo4/xtrabackup_backupfiles/mysql/column_stats.MYI 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/column_stats.MYD to /home/foo4/xtrabackup_backupfiles/mysql/column_stats.MYD 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/index_stats.frm to /home/foo4/xtrabackup_backupfiles/mysql/index_stats.frm 180411 13:43:10 [01] ...done 180411 13:43:10 [01] Copying ./mysql/index_stats.MYI to /home/foo4/xtrabackup_backupfiles/mysql/index_stats.MYI 180411 13:43:10 [01] ...done 180411 13:43:11 [01] Copying ./mysql/index_stats.MYD to /home/foo4/xtrabackup_backupfiles/mysql/index_stats.MYD 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/gtid_slave_pos.frm to /home/foo4/xtrabackup_backupfiles/mysql/gtid_slave_pos.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/transaction_registry.frm to /home/foo4/xtrabackup_backupfiles/mysql/transaction_registry.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/host.frm to /home/foo4/xtrabackup_backupfiles/mysql/host.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/event.MYI to /home/foo4/xtrabackup_backupfiles/mysql/event.MYI 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/plugin.frm to /home/foo4/xtrabackup_backupfiles/mysql/plugin.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/tables_priv.MYD to /home/foo4/xtrabackup_backupfiles/mysql/tables_priv.MYD 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./mysql/procs_priv.MYD to /home/foo4/xtrabackup_backupfiles/mysql/procs_priv.MYD 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/db.opt to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/db.opt 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_date.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_date.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_person.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_person.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_showtime.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_theater.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_theater.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_theater_mdc.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_theater_mdc.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_ticket_type.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_ticket_type.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/dim_title.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/dim_title.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/fact_crew.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/fact_crew.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /home/foo4/xtrabackup_backupfiles/boxoffice_mdb/fact_tickets.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./ff/db.opt to /home/foo4/xtrabackup_backupfiles/ff/db.opt 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./ff/f1.frm to /home/foo4/xtrabackup_backupfiles/ff/f1.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/1.frm to /home/foo4/xtrabackup_backupfiles/foo/1.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/db.opt to /home/foo4/xtrabackup_backupfiles/foo/db.opt 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/dtest3.frm to /home/foo4/xtrabackup_backupfiles/foo/dtest3.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/dtest30.frm to /home/foo4/xtrabackup_backupfiles/foo/dtest30.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/table1.frm to /home/foo4/xtrabackup_backupfiles/foo/table1.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./foo/table2.frm to /home/foo4/xtrabackup_backupfiles/foo/table2.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./sbtest/db.opt to /home/foo4/xtrabackup_backupfiles/sbtest/db.opt 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./sbtest/sbtest1.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest1.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./sbtest/sbtest10.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest10.frm 180411 13:43:11 [01] ...done 180411 13:43:11 [01] Copying ./sbtest/sbtest2.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest2.frm 180411 13:43:11 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest3.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest3.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest4.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest4.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest5.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest5.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest6.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest6.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest7.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest7.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest8.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest8.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./sbtest/sbtest9.frm to /home/foo4/xtrabackup_backupfiles/sbtest/sbtest9.frm 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./mysqlslap/db.opt to /home/foo4/xtrabackup_backupfiles/mysqlslap/db.opt 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying ./mysqlslap/ff1.frm to /home/foo4/xtrabackup_backupfiles/mysqlslap/ff1.frm 180411 13:43:12 [01] ...done 180411 13:43:12 Finished backing up non-InnoDB tables and files 180411 13:43:12 [01] Copying aria_log.00000001 to /home/foo4/xtrabackup_backupfiles/aria_log.00000001 180411 13:43:12 [01] ...done 180411 13:43:12 [01] Copying aria_log_control to /home/foo4/xtrabackup_backupfiles/aria_log_control 180411 13:43:12 [01] ...done 180411 13:43:12 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... mariabackup: The latest check point (for incremental): '51002181423' mariabackup: Stopping log copying thread. 2018-04-11 13:43:12 0 [Note] InnoDB: Read redo log up to LSN=51002181632 180411 13:43:12 >> log scanned up to (51002181432) 180411 13:43:12 Executing UNLOCK TABLES 180411 13:43:12 All tables unlocked 180411 13:43:12 [00] Copying ib_buffer_pool to /home/foo4/xtrabackup_backupfiles/ib_buffer_pool 180411 13:43:12 [00] ...done 180411 13:43:12 Backup created in directory '/home/foo4/xtrabackup_backupfiles/' 180411 13:43:12 [00] Writing backup-my.cnf 180411 13:43:12 [00] ...done 180411 13:43:12 [00] Writing xtrabackup_info 180411 13:43:12 [00] ...done mariabackup: Redo log (from LSN 51002181423 to 51002181432) was copied. 180411 13:43:12 completed OK! [foo4@t4w6 ~]$