MySQL Compressed Backup(九)
nned up to (3406079293)
xtrabackup: Creating suspend file '/tmp/xtrabackup_suspended_2' with pid '4648'
131104 00:23:02 innobackupex: Continuing after ibbackup has suspended
131104 00:23:02 innobackupex: Starting to lock all tables...
131104 00:23:02 innobackupex: All tables locked and flushed to disk
131104 00:23:02 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/data/mysql5.5'
innobackupex: Backing up file '/data/mysql5.5/zwc/t2.frm'
innobackupex: Backing up file '/data/mysql5.5/zwc/db.opt'
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.MYI'
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.MYD'
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
>> log scanned up to (3406079293)
innobackupex: Backing up file '/data/mysql5.5/zwc/t1.frm'
innobackupex: Backing up files '/data/mysql5.5/common_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (95 files)
>
> log scanned up to (3406079293)
innobackupex: Backing up files '/data/mysql5.5/mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (78 files)
innobackupex: Backing up files '/data/mysql5.5/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
131104 00:23:30 innobackupex: Finished backing up non-InnoDB tables and files
131104 00:23:30 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '3406079293'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (3406079293)
xtrabackup: Creating suspend file '/tmp/xtrabackup_log_copied' with pid '4648'
xtrabackup: Transaction log of lsn (3406079293) to (3406079293) was copied.
131104 00:23:31 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/backup'
innobackupex: MySQL binlog position: filename 'ZWC-TEST.000015', position 20185
131104 00:23:31 innobackupex: Connection to database server closed
innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.
131104 00:23:31 innobackupex: completed OK!
real 1m2.854s
user 0m45.188s
sys 0m9.802s
[root@test backup]#
[root@test backup]#
[root@test backup]# ls -lh /backup/xtra_compressed.tar.gz
-rw-r--r-- 1 root root 255M Nov 4 00:23 /backup/xtra_compressed.tar.gz
[root@test tmp]# tar xvfzi xtra_compressed.tar.gz
Uncompressed need add "-i" parameter