Comment 1 for bug 1274766

Revision history for this message
Jervin R (revin) wrote :

[revin@forge msb_5_5_340]$ innobackupex --defaults-file="/ssd/msb/msb_5_5_340/my.sandbox.cnf" --databases="test" /ssd/msb/msb_5_5_340/bkp/local/

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

140130 19:04:57 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/ssd/msb/msb_5_5_340/my.sandbox.cnf;mysql_read_default_group=xtrabackup' (using password: NO).
140130 19:04:57 innobackupex: Connected to MySQL server
140130 19:04:57 innobackupex: Executing a version check against the server...
140130 19:04:57 innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql server version 5.5.34-rel32.0-log

innobackupex: Created backup directory /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57

140130 19:04:57 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/ssd/msb/msb_5_5_340/my.sandbox.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57 --tmpdir=/ssd/msb/msb_5_5_340/tmp
innobackupex: Waiting for ibbackup (pid=19414) to suspend
innobackupex: Suspend file '/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/xtrabackup_suspended_2'

xtrabackup_55 version 2.1.7 for Percona Server 5.5.35 Linux (x86_64) (revision id: 721)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /ssd/msb/msb_5_5_340/data
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 = 2
xtrabackup: innodb_log_file_size = 5242880
>> log scanned up to (11822949064)
140130 19:04:57 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying ./ibdata1 to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/ibdata1
[01] ...done
[01] Copying ./test/sbtest1.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/sbtest1.ibd
>> log scanned up to (11822949064)
>> log scanned up to (11822949064)
[01] ...done
[01] Copying ./test/t.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t.ibd
[01] ...done
[01] Copying ./test/t2.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t2.ibd
[01] ...done
[01] Copying ./test/t1.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/t1.ibd
[01] ...done
[01] Copying ./test/trx.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/test/trx.ibd
[01] ...done
[01] Copying ./common_schema/_global_qs_variables.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_global_qs_variables.ibd
[01] ...done
[01] Copying ./common_schema/_global_script_report_data.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_global_script_report_data.ibd
[01] ...done
[01] Copying ./common_schema/_global_split_column_names_table.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_global_split_column_names_table.ibd
[01] ...done
[01] Copying ./common_schema/_global_sql_tokens.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_global_sql_tokens.ibd
[01] ...done
[01] Copying ./common_schema/_known_thread_states.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_known_thread_states.ibd
[01] ...done
[01] Copying ./common_schema/_named_scripts.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_named_scripts.ibd
[01] ...done
[01] Copying ./common_schema/_script_statements.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_script_statements.ibd
[01] ...done
[01] Copying ./common_schema/_waits.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/_waits.ibd
[01] ...done
[01] Copying ./common_schema/help_content.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/help_content.ibd
[01] ...done
[01] Copying ./common_schema/metadata.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/metadata.ibd
[01] ...done
[01] Copying ./common_schema/numbers.ibd to /ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/common_schema/numbers.ibd
[01] ...done
>> log scanned up to (11822949064)
xtrabackup: Creating suspend file '/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/xtrabackup_suspended_2' with pid '19414'

140130 19:05:01 innobackupex: Continuing after ibbackup has suspended
140130 19:05:01 innobackupex: Starting to lock all tables...
140130 19:05:01 innobackupex: All tables locked and flushed to disk

140130 19:05:01 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/ssd/msb/msb_5_5_340/data'
innobackupex: Backing up file '/ssd/msb/msb_5_5_340/data/test/sbtest1.frm'
innobackupex: Backing up file '/ssd/msb/msb_5_5_340/data/test/t.frm'
>> log scanned up to (11822949064)
innobackupex: Backing up file '/ssd/msb/msb_5_5_340/data/test/t2.frm'
innobackupex: Backing up file '/ssd/msb/msb_5_5_340/data/test/t1.frm'
innobackupex: Backing up file '/ssd/msb/msb_5_5_340/data/test/trx.frm'
140130 19:05:01 innobackupex: Finished backing up non-InnoDB tables and files

140130 19:05:01 innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '11822949064'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (11822949064)

xtrabackup: Creating suspend file '/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57/xtrabackup_log_copied' with pid '19414'
xtrabackup: Transaction log of lsn (11822949064) to (11822949064) was copied.
140130 19:05:02 innobackupex: All tables unlocked

innobackupex: Backup created in directory '/ssd/msb/msb_5_5_340/bkp/local/2014-01-30_19-04-57'
innobackupex: MySQL binlog position: filename 'mysql-bin.000001', position 107
140130 19:05:02 innobackupex: Connection to database server closed
140130 19:05:02 innobackupex: completed OK!