InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
...
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
...
innobackupex: in subdirectories of '/var/lib/mysql'
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)
>> log scanned up to (3171230103)
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)
innobackupex: Backing up file '/var/lib/mysql/dbtest/db.opt'
innobackupex: Backing up file '/var/lib/mysql/dbtest/sbtest.frm'
innobackupex: Backing up files '/var/lib/mysql/test/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (10 files)
140723 08:58:33 innobackupex: Finished backing up non-InnoDB tables and files
140723 08:58:33 innobackupex: Executing FLUSH ENGINE LOGS...
140723 08:58:33 innobackupex: Waiting for log copying to finish
>> log scanned up to (3171230103)
xtrabackup: The latest check point (for incremental): '3171230103'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (3171230103)
xtrabackup: Creating suspend file '/home/nilnandan/backup/2014-07-23_08-57-58/xtrabackup_log_copied' with pid '3297'
xtrabackup: Transaction log of lsn (3171230103) to (3171230103) was copied.
140723 08:58:34 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/home/nilnandan/backup/2014-07-23_08-57-58'
140723 08:58:34 innobackupex: Connection to database server closed
140723 08:58:34 innobackupex: completed OK!
nilnandan@nilnandan-Dell-XPS:~$
Easy to reproducible.
nilnandan@ nilnandan- Dell-XPS: ~$ mysql --socket= /tmp/mysql_ sandbox5615. sock -e "select @@datadir" ------- ------- ------- ------- ------- ---+ ------- ------- ------- ------- ------- ---+ /sandboxes/ msb_5_6_ 15/data/ | ------- ------- ------- ------- ------- ---+
+------
| @@datadir |
+------
| /home/nilnandan
+------
nilnandan@ nilnandan- Dell-XPS: ~$ sudo innobackupex --socket= /tmp/mysql_ sandbox5615. sock /home/nilnandan /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.
... mysql/mysql/ *.{frm, isl,MYD, MYI,MAD, MAI,MRG, TRG,TRN, ARM,ARZ, CSM,CSV, opt,par} ' (74 files) mysql/performan ce_schema/ *.{frm, isl,MYD, MYI,MAD, MAI,MRG, TRG,TRN, ARM,ARZ, CSM,CSV, opt,par} ' (53 files) mysql/dbtest/ db.opt' mysql/dbtest/ sbtest. frm' mysql/test/ *.{frm, isl,MYD, MYI,MAD, MAI,MRG, TRG,TRN, ARM,ARZ, CSM,CSV, opt,par} ' (10 files)
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
...
innobackupex: in subdirectories of '/var/lib/mysql'
innobackupex: Backing up files '/var/lib/
>> log scanned up to (3171230103)
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up files '/var/lib/
140723 08:58:33 innobackupex: Finished backing up non-InnoDB tables and files
140723 08:58:33 innobackupex: Executing FLUSH ENGINE LOGS...
140723 08:58:33 innobackupex: Waiting for log copying to finish
>> log scanned up to (3171230103)
xtrabackup: The latest check point (for incremental): '3171230103'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (3171230103)
xtrabackup: Creating suspend file '/home/ nilnandan/ backup/ 2014-07- 23_08-57- 58/xtrabackup_ log_copied' with pid '3297'
xtrabackup: Transaction log of lsn (3171230103) to (3171230103) was copied.
140723 08:58:34 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/home/ nilnandan/ backup/ 2014-07- 23_08-57- 58' nilnandan- Dell-XPS: ~$
140723 08:58:34 innobackupex: Connection to database server closed
140723 08:58:34 innobackupex: completed OK!
nilnandan@