Below the result of full and incremental backup: innobackupex --user=root /backup_mysql/
140428 10:08:56 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –
140428 10:08:56 innobackupex: Connected to database with mysql child process (pid=9152)
140428 10:09:02 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints “completed OK!”.
innobackupex: Using mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved.
140428 10:09:04 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/backup_mysql/2014-04-28_10-09-02 --tmpdir=/cache
innobackupex: Waiting for ibbackup (pid=9181) to suspend
innobackupex: Suspend file ‘/backup_mysql/2014-04-28_10-09-02/xtrabackup_suspended’
xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 587)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
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 = 536870912
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYD’
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.frm’
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/db.opt’
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYI’
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYD’
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/postfix/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (40 files)
innobackupex: Backing up files '/var/lib/mysql/radiusdb/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (28 files)
innobackupex: Backing up files ‘/var/lib/mysql/phpbb_optimist/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (193 files)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/mysql/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (69 files)
innobackupex: Backing up files '/var/lib/mysql/wordpress/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (118 files)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/meganet_new/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)
innobackupex: Backing up files '/var/lib/mysql/meganet/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/bacula/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)
log scanned up to (44556)
innobackupex: Backing up file ‘/var/lib/mysql/bweb/db.opt’
innobackupex: Backing up files ‘/var/lib/mysql/redmine/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files)
innobackupex: Backing up files '/var/lib/mysql/loganalyzer/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (34 files)
innobackupex: Backing up file ‘/var/lib/mysql/lego/db.opt’
innobackupex: Backing up files ‘/var/lib/mysql/zabbix/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (325 files)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/roundcube_flux/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (49 files)
innobackupex: Backing up files '/var/lib/mysql/mailscanner/.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (43 files)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
log scanned up to (44556)
innobackupex: Backing up files ‘/var/lib/mysql/ipplan/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)
log scanned up to (44556)
140428 10:11:28 innobackupex: Finished backing up non-InnoDB tables and files
xtrabackup: Creating suspend file ‘/backup_mysql/2014-04-28_10-09-02/xtrabackup_suspended’ with pid ‘9181’
xtrabackup: Transaction log of lsn (44556) to (44556) was copied.
140428 10:11:32 innobackupex: All tables unlocked
140428 10:11:32 innobackupex: Waiting for ibbackup (pid=9181) to finish
140428 10:11:32 innobackupex: Connection to database server closed