Comment 2 for bug 1343722

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Easy to reproducible.

nilnandan@nilnandan-Dell-XPS:~$ mysql --socket=/tmp/mysql_sandbox5615.sock -e "select @@datadir"
+--------------------------------------------+
| @@datadir |
+--------------------------------------------+
| /home/nilnandan/sandboxes/msb_5_6_15/data/ |
+--------------------------------------------+

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.

...
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:~$