innobackupex不同备份方式的记录明细(二)
data0/backup/mysql/2013-03-28_10-10-45
130328 10:10:45 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:10:45 innobackupex: Connected to database with mysql child process (pid=3742)
130328 10:10:49 innobackupex: Connection to database server closed
130328 10:10:49 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/data0/backup/mysql/2013-03-28_10-10-45
innobackupex: Waiting for ibbackup (pid=3754) to suspend
innobackupex: Suspend file '/data0/backup/mysql/2013-03-28_10-10-45/xtrabackup_suspended'
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: Target instance is assumed as followings.
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
130328 10:10:49 InnoDB: Using
Linux native AIO
130328 10:10:50 InnoDB: Warning: allocated tablespace 2, old maximum was 0
>> log scanned up to (893330831)
>> log scanned up to (893330831)
>> log scanned up to (893330831)
130328 10:11:03 innobackupex: Continuing after ibbackup has suspended
130328 10:11:03 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:11:04 innobackupex: Connected to database with mysql child process (pid=3770)
>> log scanned up to (893330831)
130328 10:11:08 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/usr/local/mysql/data'
innobackupex: Backing up file '/usr/local/mysql/data/inno/mm.frm'
innobackupex: Backing up file '/usr/local/mysql/data/inno/t.frm'
innobackupex: Backing up files '/usr/local/mysql/data/test/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (19 files)
130328 10:11:08 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
innobackupex: Resuming ibbackup
>> log scanned up to (893330831)
130328 10:11:09 innobackupex: Connection to database server closed
innobackupex: Backup created in directory '/data0/backup/mysql/2013-03-28_10-10-45'
130328 10:11:09 innobackupex: completed OK!
[root@Slave02 tmp]#
压缩备份；
[root@Slave02 inno]# innobackupex --database="inno test" --user=root --password
=root --no-lock --defaults-file=/etc/my.cnf --stream=tar /data0/backup/mysql
2>/tmp/mysqlbackup.log|zip>/data0/backup/mysql/mike.tar.gz
adding: - (deflated 63%)
You have new mail in /var/spool/mail/root
[root@Slave02 inno]#
[root@Slave02 mysql]# ls
2013-03-28_10-10-45 mike.tar.gz stderr stdout xtrabackup_binary
[root@Slave02 mysql]# ll
total 176004
drwxr-xr-x 4 root root 4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root 180012554 Mar 28 11:03 mike.tar.gz
-rw-r--r-- 1 root root 83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root