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!
[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: www.percona. com/xb/ p
http://
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=xtrabacku p' (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 msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/xtrabacku p_suspended_ 2'
innobackupex: Waiting for ibbackup (pid=19414) to suspend
innobackupex: Suspend file '/ssd/msb/
xtrabackup_55 version 2.1.7 for Percona Server 5.5.35 Linux (x86_64) (revision id: 721) msb_5_5_ 340/data data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 5242880 msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/ibdata1 msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ sbtest1. ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t2.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ t1.ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/test/ trx.ibd 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 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 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 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 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 schema/ _named_ scripts. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ _named_ scripts. ibd schema/ _script_ statements. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ _script_ statements. ibd schema/ _waits. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ _waits. ibd schema/ help_content. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ help_content. ibd schema/ metadata. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ metadata. ibd schema/ numbers. ibd to /ssd/msb/ msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/common_ schema/ numbers. ibd msb_5_5_ 340/bkp/ local/2014- 01-30_19- 04-57/xtrabacku p_suspended_ 2' with pid '19414'
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /ssd/msb/
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (11822949064)
140130 19:04:57 InnoDB: Warning: allocated tablespace 10, old maximum was 9
[01] Copying ./ibdata1 to /ssd/msb/
[01] ...done
[01] Copying ./test/sbtest1.ibd to /ssd/msb/
>> log scanned up to (11822949064)
>> log scanned up to (11822949064)
[01] ...done
[01] Copying ./test/t.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/t2.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/t1.ibd to /ssd/msb/
[01] ...done
[01] Copying ./test/trx.ibd to /ssd/msb/
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
[01] Copying ./common_
[01] ...done
>> log scanned up to (11822949064)
xtrabackup: Creating suspend file '/ssd/msb/
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 msb_5_5_ 340/data' msb_5_5_ 340/data/ test/sbtest1. frm' msb_5_5_ 340/data/ test/t. frm' msb_5_5_ 340/data/ test/t2. frm' msb_5_5_ 340/data/ test/t1. frm' msb_5_5_ 340/data/ test/trx. frm'
innobackupex: in subdirectories of '/ssd/msb/
innobackupex: Backing up file '/ssd/msb/
innobackupex: Backing up file '/ssd/msb/
>> log scanned up to (11822949064)
innobackupex: Backing up file '/ssd/msb/
innobackupex: Backing up file '/ssd/msb/
innobackupex: Backing up file '/ssd/msb/
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/xtrabacku p_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!