innobackup做了什么?

原创 2018年04月16日 14:51:55
--全量备份
[root@localhost /]# innobackupex  --user=root --password=xxx --socket=/opt/lampp/var/mysql/mysql.sock /opt/lampp/var/backup180416 
12:12:36 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!".

180416 12:12:37  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/opt/lampp/var/mysql/mysql.sock' as 'root'  (using password: YES).
180416 12:12:37  version_check Connected to MySQL server
180416 12:12:37  version_check Executing a version check against the server...

# A software update is available:
180416 12:12:42  version_check Done.
180416 12:12:42 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /opt/lampp/var/mysql/mysql.sock
Using server version 10.1.25-MariaDB
innobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().               //启动xtrabackup
xtrabackup: cd to /opt/lampp/var/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /opt/lampp/var/mysql/
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = /opt/lampp/var/mysql/
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
180416 12:12:42 >> log scanned up to (42193264)  
xtrabackup: Generating a list of tablespaces
180416 12:12:42 [01] Copying /opt/lampp/var/mysql/ibdata1 to /opt/lampp/var/backup/2018-04-16_12-12-36/ibdata1
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/film_actor.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_actor.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_3.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_3.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_6.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_6.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_1.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_1.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/film_category.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_category.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/FTS_0000000000000034_BEING_DELETED.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_BEING_DELETED.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/rental.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/rental.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/category.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/category.ibd
180416 12:12:42 [01]        ...done
180416 12:12:42 [01] Copying ./sakila/payment.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/payment.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/address.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/address.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/staff.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/staff.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_2.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_2.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_DELETED.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_DELETED.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_4.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_4.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film_text.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_text.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_CONFIG.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_CONFIG.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/language.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/language.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_BEING_DELETED_CACHE.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_BEING_DELETED_CACHE.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_5.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_000000000000004e_INDEX_5.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/customer.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/customer.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/inventory.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/inventory.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/city_demo.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/city_demo.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/city.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/city.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/actor.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/actor.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/country.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/country.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/store.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/store.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/FTS_0000000000000034_DELETED_CACHE.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/FTS_0000000000000034_DELETED_CACHE.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/innodb_index_stats.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/innodb_index_stats.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/innodb_table_stats.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/innodb_table_stats.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/gtid_slave_pos.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/gtid_slave_pos.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__relation.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__relation.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__column_info.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__column_info.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__favorite.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__favorite.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__table_coords.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_coords.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__bookmark.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__bookmark.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__table_uiprefs.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_uiprefs.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__table_info.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_info.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__recent.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__recent.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__pdf_pages.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__pdf_pages.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__history.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__history.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__export_templates.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__export_templates.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__navigationhiding.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__navigationhiding.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__tracking.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__tracking.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__userconfig.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__userconfig.ibd
180416 12:12:43 >> log scanned up to (42193264)
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__central_columns.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__central_columns.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__usergroups.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__usergroups.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__designer_settings.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__designer_settings.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__users.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__users.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__savedsearches.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__savedsearches.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./test/pseudohash.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/test/pseudohash.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./test/st1.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st1.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./test/st.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./userdb/user.ibd to /opt/lampp/var/backup/2018-04-16_12-12-36/userdb/user.ibd
180416 12:12:43 [01]        ...done
180416 12:12:43 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
180416 12:12:43 Executing FLUSH TABLES WITH READ LOCK...         //锁表
180416 12:12:43 Starting to backup non-InnoDB tables and files   //备份非inodb表和文件
180416 12:12:43 [01] Copying ./sakila/film_actor.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_actor.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/actor.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/actor.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/staff_list.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/staff_list.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/payment.TRG to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/payment.TRG
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/upd_film.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/upd_film.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film_category.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_category.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/country.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/country.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/sales_by_film_category.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/sales_by_film_category.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/category.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/category.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/rental.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/rental.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/customer_list.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/customer_list.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/customer.TRG to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/customer.TRG
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/address.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/address.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film_text.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_text.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/actor_info.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/actor_info.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/rental.TRG to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/rental.TRG
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/store.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/store.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/nicer_but_slower_film_list.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/nicer_but_slower_film_list.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/city.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/city.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/db.opt to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/db.opt
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/city_demo.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/city_demo.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/payment_date.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/payment_date.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/sales_by_store.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/sales_by_store.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/inventory.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/inventory.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/ins_film.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/ins_film.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/language.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/language.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/del_film.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/del_film.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/customer.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/customer.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/staff.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/staff.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film.TRG to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film.TRG
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/film_list.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/film_list.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/customer_create_date.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/customer_create_date.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/rental_date.TRN to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/rental_date.TRN
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./sakila/payment.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/sakila/payment.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/roles_mapping.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/roles_mapping.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/table_stats.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/table_stats.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/db.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/db.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/plugin.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/plugin.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition_type.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition_type.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/func.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/func.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/procs_priv.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/procs_priv.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proc.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proc.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/columns_priv.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/columns_priv.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/tables_priv.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/tables_priv.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_topic.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_topic.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_relation.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_relation.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/user.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/user.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/slow_log.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/slow_log.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_name.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_name.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/table_stats.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/table_stats.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_keyword.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_keyword.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/general_log.CSM to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/general_log.CSM
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/host.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/host.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/host.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/host.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition_type.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition_type.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proxies_priv.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proxies_priv.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/user.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/user.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/innodb_index_stats.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/innodb_index_stats.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/db.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/db.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/host.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/host.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/func.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/func.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proxies_priv.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proxies_priv.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/column_stats.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/column_stats.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/columns_priv.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/columns_priv.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/func.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/func.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_leap_second.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_leap_second.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/user.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/user.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_keyword.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_keyword.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_name.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_name.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/gtid_slave_pos.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/gtid_slave_pos.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proc.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proc.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/event.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/event.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/innodb_table_stats.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/innodb_table_stats.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/plugin.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/plugin.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_category.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_category.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/column_stats.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/column_stats.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/event.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/event.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proxies_priv.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proxies_priv.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_category.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_category.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/tables_priv.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/tables_priv.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/index_stats.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/index_stats.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/event.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/event.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_keyword.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_keyword.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/columns_priv.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/columns_priv.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_topic.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_topic.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/servers.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/servers.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/servers.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/servers.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_transition_type.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_transition_type.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/procs_priv.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/procs_priv.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/general_log.CSV to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/general_log.CSV
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_topic.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_topic.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/slow_log.CSV to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/slow_log.CSV
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/proc.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/proc.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/column_stats.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/column_stats.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_category.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_category.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/tables_priv.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/tables_priv.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_relation.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_relation.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/slow_log.CSM to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/slow_log.CSM
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/db.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/db.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/help_relation.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/help_relation.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/roles_mapping.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/roles_mapping.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_name.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_name.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_leap_second.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_leap_second.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/index_stats.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/index_stats.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/plugin.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/plugin.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/index_stats.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/index_stats.MYI
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/procs_priv.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/procs_priv.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/servers.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/servers.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone_leap_second.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone_leap_second.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/table_stats.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/table_stats.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/general_log.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/general_log.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/time_zone.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/time_zone.MYD
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./mysql/roles_mapping.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/mysql/roles_mapping.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__usergroups.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__usergroups.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__navigationhiding.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__navigationhiding.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__designer_settings.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__designer_settings.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__tracking.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__tracking.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__savedsearches.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__savedsearches.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__recent.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__recent.frm
180416 12:12:43 [01]        ...done
180416 12:12:43 [01] Copying ./phpmyadmin/pma__relation.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__relation.frm
180416 12:12:43 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__pdf_pages.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__pdf_pages.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__central_columns.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__central_columns.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__table_uiprefs.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_uiprefs.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__favorite.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__favorite.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__export_templates.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__export_templates.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__table_coords.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_coords.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__bookmark.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__bookmark.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__column_info.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__column_info.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/db.opt to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/db.opt
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__userconfig.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__userconfig.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__table_info.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__table_info.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__history.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__history.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./phpmyadmin/pma__users.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/phpmyadmin/pma__users.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/st_myisam.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st_myisam.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/st_myisam.MYI to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st_myisam.MYI
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/pseudohash.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/test/pseudohash.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/st_myisam.MYD to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st_myisam.MYD
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/st.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./test/st1.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/test/st1.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./performance_schema/db.opt to /opt/lampp/var/backup/2018-04-16_12-12-36/performance_schema/db.opt
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./userdb/user.frm to /opt/lampp/var/backup/2018-04-16_12-12-36/userdb/user.frm
180416 12:12:44 [01]        ...done
180416 12:12:44 [01] Copying ./userdb/db.opt to /opt/lampp/var/backup/2018-04-16_12-12-36/userdb/db.opt
180416 12:12:44 [01]        ...done
180416 12:12:44 Finished backing up non-InnoDB tables and files
180416 12:12:44 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '42193264'
xtrabackup: Stopping log copying thread.
.180416 12:12:44 >> log scanned up to (42193264)

180416 12:12:44 Executing UNLOCK TABLES
180416 12:12:44 All tables unlocked
180416 12:12:44 Backup created in directory '/opt/lampp/var/backup/2018-04-16_12-12-36'
180416 12:12:44 [00] Writing backup-my.cnf
180416 12:12:44 [00]        ...done
180416 12:12:44 [00] Writing xtrabackup_info
180416 12:12:44 [00]        ...done
xtrabackup: Transaction log of lsn (42193264) to (42193264) was copied.
180416 12:12:44 completed OK!
[root@localhost 2018-04-16_12-12-36]# ls
backup-my.cnf  mysql               phpmyadmin  test    xtrabackup_checkpoints  xtrabackup_logfile
ibdata1        performance_schema  sakila      userdb  xtrabackup_info
[root@localhost 2018-04-16_12-12-36]# pwd
/opt/lampp/var/backup/2018-04-16_12-12-36
--停止数据库
[root@localhost ~]# mysqladmin -uroot -p521 shutdown -S /opt/lampp/var/mysql/mysql.sock
--apply-log 日志
[root@localhost backup]# innobackupex  --defaults-file=/opt/lampp/mysql/my.cnf  --user=root --password=xxx --socket=/opt/lampp/var/mysql/mysql.sock --apply-log  /opt/lampp/var/backup/2018-04-16_12-12-36
180416 14:46:32 innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".

innobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
xtrabackup: cd to /opt/lampp/var/backup/2018-04-16_12-12-36
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(42193264)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 2097152
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 2097152
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.8
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: The log sequence numbers 1762753 and 1762753 in ibdata files do not match the log sequence number 42193264 in the ib_logfiles!
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages 
InnoDB: from the doublewrite buffer...
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.24 started; log sequence number 42193264

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 42194727
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.8
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Setting log file ./ib_logfile101 size to 5 MB
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=42194727
InnoDB: Highest supported file format is Barracuda.
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.24 started; log sequence number 42194956
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 42194966
180416 14:46:35 completed OK!
[root@localhost 2018-04-16_12-12-36]# cat xtrabackup_checkpoints
backup_type = full-prepared
from_lsn = 0
to_lsn = 42193264
last_lsn = 42193264
compact = 0
recover_binlog_info = 0
[root@localhost data]# innobackupex  --defaults-file=/opt/lampp/etc/my.cnf  --user=root --password=521 --socket=/opt/lampp/var/mysql/mysql.sock --copy-back  /opt/lampp/var/backup/2018-04-16_12-12-36
180416 15:40:11 innobackupex: Starting the copy-back operation

IMPORTANT: Please check that the copy-back run completes successfully.
           At the end of a successful copy-back run innobackupex
           prints "completed OK!".

innobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
180416 15:40:11 [01] Copying ib_logfile0 to /opt/lampp/var/mysql/ib_logfile0
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ib_logfile1 to /opt/lampp/var/mysql/ib_logfile1
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ibdata1 to /opt/lampp/var/mysql/ibdata1
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_actor.ibd to /opt/lampp/var/data/sakila/film_actor.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_3.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_3.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_actor.frm to /opt/lampp/var/data/sakila/film_actor.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/actor.frm to /opt/lampp/var/data/sakila/actor.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/staff_list.frm to /opt/lampp/var/data/sakila/staff_list.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_6.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_6.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/payment.TRG to /opt/lampp/var/data/sakila/payment.TRG
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_1.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_1.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/upd_film.TRN to /opt/lampp/var/data/sakila/upd_film.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_category.frm to /opt/lampp/var/data/sakila/film_category.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_category.ibd to /opt/lampp/var/data/sakila/film_category.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/country.frm to /opt/lampp/var/data/sakila/country.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/sales_by_film_category.frm to /opt/lampp/var/data/sakila/sales_by_film_category.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_BEING_DELETED.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_BEING_DELETED.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/category.frm to /opt/lampp/var/data/sakila/category.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/rental.ibd to /opt/lampp/var/data/sakila/rental.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/rental.frm to /opt/lampp/var/data/sakila/rental.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/category.ibd to /opt/lampp/var/data/sakila/category.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/payment.ibd to /opt/lampp/var/data/sakila/payment.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/customer_list.frm to /opt/lampp/var/data/sakila/customer_list.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/address.ibd to /opt/lampp/var/data/sakila/address.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/staff.ibd to /opt/lampp/var/data/sakila/staff.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_2.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_2.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/customer.TRG to /opt/lampp/var/data/sakila/customer.TRG
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_DELETED.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_DELETED.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/address.frm to /opt/lampp/var/data/sakila/address.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_4.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_4.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_text.ibd to /opt/lampp/var/data/sakila/film_text.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_CONFIG.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_CONFIG.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/language.ibd to /opt/lampp/var/data/sakila/language.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_BEING_DELETED_CACHE.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_BEING_DELETED_CACHE.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_text.frm to /opt/lampp/var/data/sakila/film_text.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/actor_info.frm to /opt/lampp/var/data/sakila/actor_info.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/rental.TRG to /opt/lampp/var/data/sakila/rental.TRG
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/store.frm to /opt/lampp/var/data/sakila/store.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/nicer_but_slower_film_list.frm to /opt/lampp/var/data/sakila/nicer_but_slower_film_list.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/city.frm to /opt/lampp/var/data/sakila/city.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_000000000000004e_INDEX_5.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_000000000000004e_INDEX_5.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film.frm to /opt/lampp/var/data/sakila/film.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/db.opt to /opt/lampp/var/data/sakila/db.opt
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/city_demo.frm to /opt/lampp/var/data/sakila/city_demo.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/payment_date.TRN to /opt/lampp/var/data/sakila/payment_date.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/sales_by_store.frm to /opt/lampp/var/data/sakila/sales_by_store.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/customer.ibd to /opt/lampp/var/data/sakila/customer.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/inventory.ibd to /opt/lampp/var/data/sakila/inventory.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/inventory.frm to /opt/lampp/var/data/sakila/inventory.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/city_demo.ibd to /opt/lampp/var/data/sakila/city_demo.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/ins_film.TRN to /opt/lampp/var/data/sakila/ins_film.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film.ibd to /opt/lampp/var/data/sakila/film.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/city.ibd to /opt/lampp/var/data/sakila/city.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/actor.ibd to /opt/lampp/var/data/sakila/actor.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/language.frm to /opt/lampp/var/data/sakila/language.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/del_film.TRN to /opt/lampp/var/data/sakila/del_film.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/customer.frm to /opt/lampp/var/data/sakila/customer.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/country.ibd to /opt/lampp/var/data/sakila/country.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/staff.frm to /opt/lampp/var/data/sakila/staff.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film.TRG to /opt/lampp/var/data/sakila/film.TRG
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/film_list.frm to /opt/lampp/var/data/sakila/film_list.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/customer_create_date.TRN to /opt/lampp/var/data/sakila/customer_create_date.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/rental_date.TRN to /opt/lampp/var/data/sakila/rental_date.TRN
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/store.ibd to /opt/lampp/var/data/sakila/store.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/FTS_0000000000000034_DELETED_CACHE.ibd to /opt/lampp/var/data/sakila/FTS_0000000000000034_DELETED_CACHE.ibd
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./sakila/payment.frm to /opt/lampp/var/data/sakila/payment.frm
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./mysql/roles_mapping.MYD to /opt/lampp/var/data/mysql/roles_mapping.MYD
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./mysql/table_stats.MYI to /opt/lampp/var/data/mysql/table_stats.MYI
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./mysql/db.MYI to /opt/lampp/var/data/mysql/db.MYI
180416 15:40:12 [01]        ...done
180416 15:40:12 [01] Copying ./mysql/plugin.frm to /opt/lampp/var/data/mysql/plugin.frm
180416 15:40:12 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition_type.frm to /opt/lampp/var/data/mysql/time_zone_transition_type.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/func.MYD to /opt/lampp/var/data/mysql/func.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/procs_priv.MYD to /opt/lampp/var/data/mysql/procs_priv.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proc.MYI to /opt/lampp/var/data/mysql/proc.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/columns_priv.MYI to /opt/lampp/var/data/mysql/columns_priv.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/tables_priv.frm to /opt/lampp/var/data/mysql/tables_priv.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_topic.MYD to /opt/lampp/var/data/mysql/help_topic.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_relation.frm to /opt/lampp/var/data/mysql/help_relation.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/user.MYI to /opt/lampp/var/data/mysql/user.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/slow_log.frm to /opt/lampp/var/data/mysql/slow_log.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_name.MYI to /opt/lampp/var/data/mysql/time_zone_name.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/table_stats.frm to /opt/lampp/var/data/mysql/table_stats.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_keyword.MYI to /opt/lampp/var/data/mysql/help_keyword.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/general_log.CSM to /opt/lampp/var/data/mysql/general_log.CSM
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/host.MYD to /opt/lampp/var/data/mysql/host.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone.frm to /opt/lampp/var/data/mysql/time_zone.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/host.frm to /opt/lampp/var/data/mysql/host.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition_type.MYD to /opt/lampp/var/data/mysql/time_zone_transition_type.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proxies_priv.MYD to /opt/lampp/var/data/mysql/proxies_priv.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/user.frm to /opt/lampp/var/data/mysql/user.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/innodb_index_stats.frm to /opt/lampp/var/data/mysql/innodb_index_stats.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/db.MYD to /opt/lampp/var/data/mysql/db.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/host.MYI to /opt/lampp/var/data/mysql/host.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/innodb_index_stats.ibd to /opt/lampp/var/data/mysql/innodb_index_stats.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/func.frm to /opt/lampp/var/data/mysql/func.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proxies_priv.frm to /opt/lampp/var/data/mysql/proxies_priv.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/column_stats.frm to /opt/lampp/var/data/mysql/column_stats.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/columns_priv.MYD to /opt/lampp/var/data/mysql/columns_priv.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/func.MYI to /opt/lampp/var/data/mysql/func.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_leap_second.frm to /opt/lampp/var/data/mysql/time_zone_leap_second.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/user.MYD to /opt/lampp/var/data/mysql/user.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_keyword.MYD to /opt/lampp/var/data/mysql/help_keyword.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_name.MYD to /opt/lampp/var/data/mysql/time_zone_name.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/gtid_slave_pos.frm to /opt/lampp/var/data/mysql/gtid_slave_pos.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition.MYD to /opt/lampp/var/data/mysql/time_zone_transition.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proc.MYD to /opt/lampp/var/data/mysql/proc.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/event.MYI to /opt/lampp/var/data/mysql/event.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition.MYI to /opt/lampp/var/data/mysql/time_zone_transition.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/innodb_table_stats.frm to /opt/lampp/var/data/mysql/innodb_table_stats.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/plugin.MYD to /opt/lampp/var/data/mysql/plugin.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_category.frm to /opt/lampp/var/data/mysql/help_category.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/column_stats.MYI to /opt/lampp/var/data/mysql/column_stats.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/event.MYD to /opt/lampp/var/data/mysql/event.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone.MYI to /opt/lampp/var/data/mysql/time_zone.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proxies_priv.MYI to /opt/lampp/var/data/mysql/proxies_priv.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_category.MYD to /opt/lampp/var/data/mysql/help_category.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/tables_priv.MYI to /opt/lampp/var/data/mysql/tables_priv.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/index_stats.MYD to /opt/lampp/var/data/mysql/index_stats.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/event.frm to /opt/lampp/var/data/mysql/event.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_keyword.frm to /opt/lampp/var/data/mysql/help_keyword.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/columns_priv.frm to /opt/lampp/var/data/mysql/columns_priv.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_topic.MYI to /opt/lampp/var/data/mysql/help_topic.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition.frm to /opt/lampp/var/data/mysql/time_zone_transition.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/servers.MYI to /opt/lampp/var/data/mysql/servers.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/servers.MYD to /opt/lampp/var/data/mysql/servers.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_transition_type.MYI to /opt/lampp/var/data/mysql/time_zone_transition_type.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/innodb_table_stats.ibd to /opt/lampp/var/data/mysql/innodb_table_stats.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/procs_priv.MYI to /opt/lampp/var/data/mysql/procs_priv.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/general_log.CSV to /opt/lampp/var/data/mysql/general_log.CSV
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_topic.frm to /opt/lampp/var/data/mysql/help_topic.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/slow_log.CSV to /opt/lampp/var/data/mysql/slow_log.CSV
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/proc.frm to /opt/lampp/var/data/mysql/proc.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/column_stats.MYD to /opt/lampp/var/data/mysql/column_stats.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_category.MYI to /opt/lampp/var/data/mysql/help_category.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/tables_priv.MYD to /opt/lampp/var/data/mysql/tables_priv.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_relation.MYD to /opt/lampp/var/data/mysql/help_relation.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/slow_log.CSM to /opt/lampp/var/data/mysql/slow_log.CSM
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/db.frm to /opt/lampp/var/data/mysql/db.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/gtid_slave_pos.ibd to /opt/lampp/var/data/mysql/gtid_slave_pos.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/help_relation.MYI to /opt/lampp/var/data/mysql/help_relation.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/roles_mapping.MYI to /opt/lampp/var/data/mysql/roles_mapping.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_name.frm to /opt/lampp/var/data/mysql/time_zone_name.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_leap_second.MYI to /opt/lampp/var/data/mysql/time_zone_leap_second.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/index_stats.frm to /opt/lampp/var/data/mysql/index_stats.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/plugin.MYI to /opt/lampp/var/data/mysql/plugin.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/index_stats.MYI to /opt/lampp/var/data/mysql/index_stats.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/procs_priv.frm to /opt/lampp/var/data/mysql/procs_priv.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/servers.frm to /opt/lampp/var/data/mysql/servers.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone_leap_second.MYD to /opt/lampp/var/data/mysql/time_zone_leap_second.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/table_stats.MYD to /opt/lampp/var/data/mysql/table_stats.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/general_log.frm to /opt/lampp/var/data/mysql/general_log.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/time_zone.MYD to /opt/lampp/var/data/mysql/time_zone.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./mysql/roles_mapping.frm to /opt/lampp/var/data/mysql/roles_mapping.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./xtrabackup_info to /opt/lampp/var/data/xtrabackup_info
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__usergroups.frm to /opt/lampp/var/data/phpmyadmin/pma__usergroups.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__relation.ibd to /opt/lampp/var/data/phpmyadmin/pma__relation.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__column_info.ibd to /opt/lampp/var/data/phpmyadmin/pma__column_info.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__navigationhiding.frm to /opt/lampp/var/data/phpmyadmin/pma__navigationhiding.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__designer_settings.frm to /opt/lampp/var/data/phpmyadmin/pma__designer_settings.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__favorite.ibd to /opt/lampp/var/data/phpmyadmin/pma__favorite.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_coords.ibd to /opt/lampp/var/data/phpmyadmin/pma__table_coords.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__tracking.frm to /opt/lampp/var/data/phpmyadmin/pma__tracking.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__savedsearches.frm to /opt/lampp/var/data/phpmyadmin/pma__savedsearches.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__recent.frm to /opt/lampp/var/data/phpmyadmin/pma__recent.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__relation.frm to /opt/lampp/var/data/phpmyadmin/pma__relation.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__bookmark.ibd to /opt/lampp/var/data/phpmyadmin/pma__bookmark.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_uiprefs.ibd to /opt/lampp/var/data/phpmyadmin/pma__table_uiprefs.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__pdf_pages.frm to /opt/lampp/var/data/phpmyadmin/pma__pdf_pages.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__central_columns.frm to /opt/lampp/var/data/phpmyadmin/pma__central_columns.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_info.ibd to /opt/lampp/var/data/phpmyadmin/pma__table_info.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_uiprefs.frm to /opt/lampp/var/data/phpmyadmin/pma__table_uiprefs.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__recent.ibd to /opt/lampp/var/data/phpmyadmin/pma__recent.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__pdf_pages.ibd to /opt/lampp/var/data/phpmyadmin/pma__pdf_pages.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__history.ibd to /opt/lampp/var/data/phpmyadmin/pma__history.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__favorite.frm to /opt/lampp/var/data/phpmyadmin/pma__favorite.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__export_templates.frm to /opt/lampp/var/data/phpmyadmin/pma__export_templates.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_coords.frm to /opt/lampp/var/data/phpmyadmin/pma__table_coords.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__export_templates.ibd to /opt/lampp/var/data/phpmyadmin/pma__export_templates.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__bookmark.frm to /opt/lampp/var/data/phpmyadmin/pma__bookmark.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__column_info.frm to /opt/lampp/var/data/phpmyadmin/pma__column_info.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/db.opt to /opt/lampp/var/data/phpmyadmin/db.opt
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__navigationhiding.ibd to /opt/lampp/var/data/phpmyadmin/pma__navigationhiding.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__tracking.ibd to /opt/lampp/var/data/phpmyadmin/pma__tracking.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__userconfig.ibd to /opt/lampp/var/data/phpmyadmin/pma__userconfig.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__central_columns.ibd to /opt/lampp/var/data/phpmyadmin/pma__central_columns.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__userconfig.frm to /opt/lampp/var/data/phpmyadmin/pma__userconfig.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__usergroups.ibd to /opt/lampp/var/data/phpmyadmin/pma__usergroups.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__designer_settings.ibd to /opt/lampp/var/data/phpmyadmin/pma__designer_settings.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__users.ibd to /opt/lampp/var/data/phpmyadmin/pma__users.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__table_info.frm to /opt/lampp/var/data/phpmyadmin/pma__table_info.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__savedsearches.ibd to /opt/lampp/var/data/phpmyadmin/pma__savedsearches.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__history.frm to /opt/lampp/var/data/phpmyadmin/pma__history.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./phpmyadmin/pma__users.frm to /opt/lampp/var/data/phpmyadmin/pma__users.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/pseudohash.ibd to /opt/lampp/var/data/test/pseudohash.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st_myisam.frm to /opt/lampp/var/data/test/st_myisam.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st1.ibd to /opt/lampp/var/data/test/st1.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st.ibd to /opt/lampp/var/data/test/st.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st_myisam.MYI to /opt/lampp/var/data/test/st_myisam.MYI
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/pseudohash.frm to /opt/lampp/var/data/test/pseudohash.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st_myisam.MYD to /opt/lampp/var/data/test/st_myisam.MYD
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st.frm to /opt/lampp/var/data/test/st.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./test/st1.frm to /opt/lampp/var/data/test/st1.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./performance_schema/db.opt to /opt/lampp/var/data/performance_schema/db.opt
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./userdb/user.frm to /opt/lampp/var/data/userdb/user.frm
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./userdb/user.ibd to /opt/lampp/var/data/userdb/user.ibd
180416 15:40:13 [01]        ...done
180416 15:40:13 [01] Copying ./userdb/db.opt to /opt/lampp/var/data/userdb/db.opt
180416 15:40:13 [01]        ...done
180416 15:40:13 completed OK!




版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/jing_flower/article/details/79960595

什么是 Javascript 设计模式

随着 javascript ES6/7 的发布,很多老版本的设计模式的实现,今天来看是错误的,将被彻底颠覆。即便简单的单例模式,也将被重写,焕发新的生命。
  • 2017年06月29日 11:23

innobackup 备份还原原理和操作

详细内容参见网址:http://www.jb51.net/article/41570.htm   优势: 1、快速可靠的进行完全备份 2、在备份的过程中不会影响到事务 3、支持数据流、网络传...
  • donghaixiaolongwang
  • donghaixiaolongwang
  • 2017-03-06 17:13:35
  • 575

percona之innobackup备份数据库

percona之innobackup备份数据库
  • crj_9527
  • crj_9527
  • 2016-04-08 11:07:41
  • 872

mysql备份利器 Innobackup 大数据备份还原

MySQL备份利器 innobackup 大数据备份还原大数据的备份和恢复,始终是个难点,当MySQL超过10个G,那么备份整个过程变得非常难熬,而且也不利于数据备份和恢复。这时候,刚好出现一款备份M...
  • wanglei_storage
  • wanglei_storage
  • 2015-10-26 22:03:24
  • 3209

Innobackup mysql 多实例环境搭建主从同步

Innobackup mysql 多实例主从同步环境搭建该实验是在mysql多实例环境下做的;如果需要部署 mysql 多实例环境,则移步:mysql 多实例案例实战: http://blog.csd...
  • wanglei_storage
  • wanglei_storage
  • 2016-04-19 17:26:59
  • 6668

new操作符做了哪些事情?

var Func=function(){ }; var func=new Func (); new共经过了4个阶段1、创建一个空对象var obj=new Object(); 2、设置原型链...
  • shuidinaozhongyan
  • shuidinaozhongyan
  • 2017-07-13 21:38:58
  • 315

慢查询和innobackup备份导致数据库挂起

现象 短信报警凌晨的备份任务失败;研发说应用挂了,应用都重启过了,貌似还没解决;其他cpu、磁盘空间、日志等指标都正常,没收到报警,疑惑; 排查 凌晨1点开始的备份不成功: >> log ...
  • sdmei
  • sdmei
  • 2017-11-15 10:17:15
  • 48

new一个对象给我们做了什么

new的过程 //创建对象用new关键字。那么这个new到底为我们做了什么呢? 有以下3步 // 1,在内存中开辟一块空间。 // 2, 在开辟的空中中创建对象。 // 3,调用对象...
  • qq_34908844
  • qq_34908844
  • 2017-12-06 11:12:14
  • 208

Tomcat 启动都做了什么?

这里我们在windows 机子作为实验,来看看tomcat 启动的时候都做了什么。startup.bat这个文件java ee 程序员最熟悉不过了,是一个启动tomcat 服务器的批处理文件,这个文件...
  • u012733415
  • u012733415
  • 2016-01-31 13:04:26
  • 293

innobackup备份数据主从同步点确定

在选在innobackup做数据备份时,在从库上做备份有两个文件 ibbackup_binlog_info和 ibbackup_slave_info. 打开他们信息如下: -bash-3.00...
  • z1988316
  • z1988316
  • 2012-09-29 16:02:04
  • 1762
收藏助手
不良信息举报
您举报文章:innobackup做了什么?
举报原因:
原因补充:

(最多只允许输入30个字)