InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources: http://www.percona.com/xb/p 141210 03:03:16 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'sstuser' (using password: YES). 141210 03:03:16 innobackupex: Connected to MySQL server 141210 03:03:16 innobackupex: Executing a version check against the server... 141210 03:03:16 innobackupex: Done. 141210 03:03:16 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!". innobackupex: Using server version 5.6.21-70.1-56-log innobackupex: Created backup directory /tmp 141210 03:03:16 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --extra-lsndir='/tmp' --stream=tar innobackupex: Waiting for ibbackup (pid=9680) to suspend innobackupex: Suspend file '/tmp/xtrabackup_suspended_2' xtrabackup version 2.2.6 based on MySQL server 5.6.21 Linux (x86_64) (revision id: ) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: open files limit requested 0, set to 17994 xtrabackup: using the following InnoDB configuration: 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 = 3 xtrabackup: innodb_log_file_size = 268435456 >> log scanned up to (1626686) xtrabackup: Generating a list of tablespaces [01] Streaming ./ibdata1 [01] ...done [01] Streaming ./mysql/slave_worker_info.ibd [01] ...done [01] Streaming ./mysql/innodb_table_stats.ibd [01] ...done [01] Streaming ./mysql/innodb_index_stats.ibd [01] ...done [01] Streaming ./mysql/slave_relay_log_info.ibd [01] ...done [01] Streaming ./mysql/slave_master_info.ibd [01] ...done >> log scanned up to (1626686) xtrabackup: Creating suspend file '/tmp/xtrabackup_suspended_2' with pid '9680' 141210 03:03:18 innobackupex: Continuing after ibbackup has suspended 141210 03:03:18 innobackupex: Executing LOCK TABLES FOR BACKUP... 141210 03:03:18 innobackupex: Backup tables lock acquired 141210 03:03:18 innobackupex: Starting to backup non-InnoDB tables and files innobackupex: in subdirectories of '/var/lib/mysql/' innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files) >> log scanned up to (1626686) innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files) 141210 03:03:18 innobackupex: Finished backing up non-InnoDB tables and files 141210 03:03:18 innobackupex: Executing LOCK BINLOG FOR BACKUP... 141210 03:03:18 innobackupex: Executing FLUSH ENGINE LOGS... 141210 03:03:18 innobackupex: Waiting for log copying to finish xtrabackup: The latest check point (for incremental): '1626686' xtrabackup: Stopping log copying thread. .>> log scanned up to (1626686) xtrabackup: Creating suspend file '/tmp/xtrabackup_log_copied' with pid '9680' xtrabackup: Transaction log of lsn (1626686) to (1626686) was copied. 141210 03:03:19 innobackupex: Executing UNLOCK BINLOG 141210 03:03:19 innobackupex: Executing UNLOCK TABLES 141210 03:03:19 innobackupex: All tables unlocked innobackupex: Backup created in directory '/tmp' innobackupex: MySQL binlog position: filename 'mysql-bin.000005', position 619, GTID of the last change '' 141210 03:03:19 innobackupex: Connection to database server closed innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream. 141210 03:03:19 innobackupex: completed OK!