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
140827 11:49:49 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/home/nilnandan.joshi/sandboxes/msb_10_0_13/my.sandbox.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql_sandbox10013.sock' as 'root' (using password: YES).
140827 11:49:49 innobackupex: Connected to MySQL server
140827 11:49:49 innobackupex: Executing a version check against the server...
140827 11:49:49 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 10.0.13-MariaDB
innobackupex: Created backup directory /home/nilnandan.joshi/backup/2014-08-27_11-49-49
140827 11:49:49 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/nilnandan.joshi/sandboxes/msb_10_0_13/my.sandbox.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/home/nilnandan.joshi/backup/2014-08-27_11-49-49 --tmpdir=/home/nilnandan.joshi/sandboxes/msb_10_0_13/tmp --extra-lsndir='/home/nilnandan.joshi/sandboxes/msb_10_0_13/tmp'
innobackupex: Waiting for ibbackup (pid=13538) to suspend
innobackupex: Suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_suspended_2'
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/nilnandan.joshi/sandboxes/msb_10_0_13/data
xtrabackup: open files limit requested 0, set to 1024
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 = 50331648
>> log scanned up to (1616918)
[01] Copying ./ibdata1 to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/ibdata1
[01] ...done
[01] Copying ./mysql/innodb_table_stats.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/innodb_table_stats.ibd
[01] ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/innodb_index_stats.ibd
[01] ...done
[01] Copying ./mysql/gtid_slave_pos.ibd to /home/nilnandan.joshi/backup/2014-08-27_11-49-49/mysql/gtid_slave_pos.ibd
[01] ...done
>> log scanned up to (1616918)
xtrabackup: Creating suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_suspended_2' with pid '13539'
140827 11:49:51 innobackupex: Continuing after ibbackup has suspended
140827 11:49:51 innobackupex: Executing FLUSH TABLES WITH READ LOCK...
>> log scanned up to (1616918)
140827 11:49:51 innobackupex: All tables locked and flushed to disk
140827 11:49:51 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data'
innobackupex: Backing up files '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (84 files)
innobackupex: Backing up files '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files)
innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/db.opt'
innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.frm'
innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.MAI'
innobackupex: Backing up file '/home/nilnandan.joshi/sandboxes/msb_10_0_13/data/nil/nil_test.MAD'
140827 11:49:51 innobackupex: Finished backing up non-InnoDB tables and files
140827 11:49:51 innobackupex: Executing FLUSH ENGINE LOGS...
140827 11:49:51 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '1616918'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1616918)
xtrabackup: Creating suspend file '/home/nilnandan.joshi/backup/2014-08-27_11-49-49/xtrabackup_log_copied' with pid '13539'
xtrabackup: Transaction log of lsn (1616918) to (1616918) was copied.
140827 11:49:52 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/home/nilnandan.joshi/backup/2014-08-27_11-49-49'
140827 11:49:52 innobackupex: Connection to database server closed
140827 11:49:52 innobackupex: completed OK!
nilnandan.joshi@Perconallc-Support:~/sandboxes/msb_10_0_13$
nilnandan.joshi@Perconallc-Support:~$ cd backup/
nilnandan.joshi@Perconallc-Support:~/backup/2014-08-27_11-49-49$ ls -al
total 12316
drwxr-xr-x 6 root root 4096 Aug 27 11:49 .
drwxr-xr-x 5 nilnandan.joshi admin 100 Aug 27 11:49 ..
-rw-r--r-- 1 root root 357 Aug 27 11:49 backup-my.cnf
-rw-r----- 1 root root 12582912 Aug 27 11:49 ibdata1
drwx------ 2 root root 4096 Aug 27 11:49 mysql
drwxr-xr-x 2 root root 96 Aug 27 11:49 nil
drwxr-xr-x 2 root root 4096 Aug 27 11:49 performance_schema
drwxr-xr-x 2 root root 10 Aug 27 11:49 test
-rw-r----- 1 root root 89 Aug 27 11:49 xtrabackup_checkpoints
-rw-r--r-- 1 root root 648 Aug 27 11:49 xtrabackup_info
-rw-r----- 1 root root 2560 Aug 27 11:49 xtrabackup_logfile
nilnandan.joshi@Perconallc-Support:~/backup/2014-08-27_11-49-49$
Verified with MariaDB 10,
mysql> show create table nil_test \G ******* ******* ****** 1. row ******* ******* ******* ******
*******
Table: nil_test
Create Table: CREATE TABLE `nil_test` (
`id` int(11) DEFAULT NULL,
`name` varchar(10) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
1 row in set (0.00 sec)
nilnandan. joshi@Perconall c-Support: ~/sandboxes/ msb_10_ 0_13/data$ ls -al 013.pid joshi@Perconall c-Support: ~/sandboxes/ msb_10_ 0_13/data$
total 241692
drwx------ 6 nilnandan.joshi admin 4096 Aug 27 11:10 .
drwxr-xr-x 4 nilnandan.joshi admin 4096 Aug 27 11:09 ..
-rw-rw---- 1 nilnandan.joshi admin 68362240 Aug 27 11:13 aria_log.00000001
-rw-rw---- 1 nilnandan.joshi admin 52 Aug 27 11:13 aria_log_control
-rw-rw---- 1 nilnandan.joshi admin 12582912 Aug 27 11:09 ibdata1
-rw-rw---- 1 nilnandan.joshi admin 50331648 Aug 27 11:09 ib_logfile0
-rw-rw---- 1 nilnandan.joshi admin 50331648 Aug 27 11:09 ib_logfile1
-rw-r----- 1 nilnandan.joshi admin 1643 Aug 27 11:09 msandbox.err
-rw-rw---- 1 nilnandan.joshi admin 0 Aug 27 11:09 multi-master.info
drwx------ 2 nilnandan.joshi admin 4096 Aug 27 11:09 mysql
-rw-rw---- 1 nilnandan.joshi admin 6 Aug 27 11:09 mysql_sandbox10
drwx------ 2 nilnandan.joshi admin 96 Aug 27 11:11 nil
drwx------ 2 nilnandan.joshi admin 4096 Aug 27 11:09 performance_schema
drwx------ 2 nilnandan.joshi admin 10 Aug 27 11:09 test
nilnandan.
nilnandan. joshi@Perconall c-Support: ~/sandboxes/ msb_10_ 0_13$ sudo innobackupex --defaults- file=/home/ nilnandan. joshi/sandboxes /msb_10_ 0_13/my. sandbox. cnf --user=root --password=msandbox --socket= /tmp/mysql_ sandbox10013. sock /home/nilnandan .joshi/ backup
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://
140827 11:49:49 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql: ;mysql_ read_default_ file=/home/ nilnandan. joshi/sandboxes /msb_10_ 0_13/my. sandbox. cnf;mysql_ read_default_ group=xtrabacku p;mysql_ socket= /tmp/mysql_ sandbox10013. sock' as 'root' (using password: YES).
140827 11:49:49 innobackupex: Connected to MySQL server
140827 11:49:49 innobackupex: Executing a version check against the server...
140827 11:49:49 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 10.0.13-MariaDB
innobackupex: Created backup directory /home/nilnandan .joshi/ backup/ 2014-08- 27_11-49- 49
140827 11:49:49 innobackupex: Starting ibbackup with command: xtrabackup --defaults- file="/ home/nilnandan. joshi/sandboxes /msb_10_ 0_13/my. sandbox. cnf" --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/home/ nilnandan. joshi/backup/ 2014-08- 27_11-49- 49 --tmpdir= /home/nilnandan .joshi/ sandboxes/ msb_10_ 0_13/tmp --extra- lsndir= '/home/ nilnandan. joshi/sandboxes /msb_10_ 0_13/tmp' nilnandan. joshi/backup/ 2014-08- 27_11-49- 49/xtrabackup_ suspended_ 2'
innobackupex: Waiting for ibbackup (pid=13538) to suspend
innobackupex: Suspend file '/home/
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: ) .joshi/ sandboxes/ msb_10_ 0_13/data data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 50331648 .joshi/ backup/ 2014-08- 27_11-49- 49/ibdata1 innodb_ table_stats. ibd to /home/nilnandan .joshi/ backup/ 2014-08- 27_11-49- 49/mysql/ innodb_ table_stats. ibd innodb_ index_stats. ibd to /home/nilnandan .joshi/ backup/ 2014-08- 27_11-49- 49/mysql/ innodb_ index_stats. ibd gtid_slave_ pos.ibd to /home/nilnandan .joshi/ backup/ 2014-08- 27_11-49- 49/mysql/ gtid_slave_ pos.ibd nilnandan. joshi/backup/ 2014-08- 27_11-49- 49/xtrabackup_ suspended_ 2' with pid '13539'
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/nilnandan
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (1616918)
[01] Copying ./ibdata1 to /home/nilnandan
[01] ...done
[01] Copying ./mysql/
[01] ...done
[01] Copying ./mysql/
[01] ...done
[01] Copying ./mysql/
[01] ...done
>> log scanned up to (1616918)
xtrabackup: Creating suspend file '/home/
140827 11:49:51 innobackupex: Continuing after ibbackup has suspended
140827 11:49:51 innobackupex: Executing FLUSH TABLES WITH READ LOCK...
>> log scanned up to (1616918)
140827 11:49:51 innobackupex: All tables locked and flushed to disk
140827 11:49:51 innobackupex: Starting to backup non-InnoDB tables and files nilnandan. joshi/sandboxes /msb_10_ 0_13/data' nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ mysql/* .{frm,isl, MYD,MYI, MAD,MAI, MRG,TRG, TRN,ARM, ARZ,CSM, CSV,opt, par}' (84 files) nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ performance_ schema/ *.{frm, isl,MYD, MYI,MAD, MAI,MRG, TRG,TRN, ARM,ARZ, CSM,CSV, opt,par} ' (53 files) nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ nil/db. opt' nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ nil/nil_ test.frm' nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ nil/nil_ test.MAI' nilnandan. joshi/sandboxes /msb_10_ 0_13/data/ nil/nil_ test.MAD'
innobackupex: in subdirectories of '/home/
innobackupex: Backing up files '/home/
innobackupex: Backing up files '/home/
innobackupex: Backing up file '/home/
innobackupex: Backing up file '/home/
innobackupex: Backing up file '/home/
innobackupex: Backing up file '/home/
140827 11:49:51 innobackupex: Finished backing up non-InnoDB tables and files
140827 11:49:51 innobackupex: Executing FLUSH ENGINE LOGS...
140827 11:49:51 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '1616918'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1616918)
xtrabackup: Creating suspend file '/home/ nilnandan. joshi/backup/ 2014-08- 27_11-49- 49/xtrabackup_ log_copied' with pid '13539'
xtrabackup: Transaction log of lsn (1616918) to (1616918) was copied.
140827 11:49:52 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/home/ nilnandan. joshi/backup/ 2014-08- 27_11-49- 49' joshi@Perconall c-Support: ~/sandboxes/ msb_10_ 0_13$
140827 11:49:52 innobackupex: Connection to database server closed
140827 11:49:52 innobackupex: completed OK!
nilnandan.
nilnandan. joshi@Perconall c-Support: ~$ cd backup/ joshi@Perconall c-Support: ~/backup/ 2014-08- 27_11-49- 49$ ls -al checkpoints joshi@Perconall c-Support: ~/backup/ 2014-08- 27_11-49- 49$
nilnandan.
total 12316
drwxr-xr-x 6 root root 4096 Aug 27 11:49 .
drwxr-xr-x 5 nilnandan.joshi admin 100 Aug 27 11:49 ..
-rw-r--r-- 1 root root 357 Aug 27 11:49 backup-my.cnf
-rw-r----- 1 root root 12582912 Aug 27 11:49 ibdata1
drwx------ 2 root root 4096 Aug 27 11:49 mysql
drwxr-xr-x 2 root root 96 Aug 27 11:49 nil
drwxr-xr-x 2 root root 4096 Aug 27 11:49 performance_schema
drwxr-xr-x 2 root root 10 Aug 27 11:49 test
-rw-r----- 1 root root 89 Aug 27 11:49 xtrabackup_
-rw-r--r-- 1 root root 648 Aug 27 11:49 xtrabackup_info
-rw-r----- 1 root root 2560 Aug 27 11:49 xtrabackup_logfile
nilnandan.