full mysql backup with xbackup.sh wrapper

gistfile1.txt

root@lucid64:~/mootools# ./xbackup.sh full
Backup type: full
Backup job started: Tue May  7 18:01:40 PDT 2013
Running full backup /backup//bkps/2013-05-07_18_01_40
Checking disk space ... (data: 29516) (disk: 75403716)

Xtrabackup started: Tue May  7 18:01:40 PDT 2013

Backing up with: /usr/bin/innobackupex  --no-timestamp /backup//bkps/2013-05-07_18_01_40

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130507 18:01:40  innobackupex: Starting mysql with options:  --unbuffered --
130507 18:01:40  innobackupex: Connected to database with mysql child process (pid=942)
130507 18:01:46  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.5.28, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /backup/bkps/2013-05-07_18_01_40
130507 18:01:46  innobackupex: Starting mysql with options:  --unbuffered --
130507 18:01:46  innobackupex: Connected to database with mysql child process (pid=971)
130507 18:01:48  innobackupex: Connection to database server closed

130507 18:01:48  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/backup/bkps/2013-05-07_18_01_40
innobackupex: Waiting for ibbackup (pid=980) to suspend
innobackupex: Suspend file '/backup/bkps/2013-05-07_18_01_40/xtrabackup_suspended'

xtrabackup_55 version 2.0.3 for Percona Server 5.5.16 Linux (x86_64) (revision id: undefined)
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 = 5242880
130507 18:01:48 InnoDB: Using Linux native AIO
>> log scanned up to (1608865)
[01] Copying ./ibdata1 to /backup/bkps/2013-05-07_18_01_40/ibdata1
[01]        ...done

130507 18:01:50  innobackupex: Continuing after ibbackup has suspended
130507 18:01:50  innobackupex: Starting mysql with options:  --unbuffered --
130507 18:01:50  innobackupex: Connected to database with mysql child process (pid=995)
130507 18:01:52  innobackupex: Starting to lock all tables...
>> log scanned up to (1608865)
>> log scanned up to (1608865)
130507 18:02:02  innobackupex: All tables locked and flushed to disk

130507 18:02:02  innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up file '/var/lib/mysql/test/db.opt'
innobackupex: Backing up file '/var/lib/mysql/test/test.frm'
innobackupex: Backing up file '/var/lib/mysql/test/t2.frm'
innobackupex: Backing up file '/var/lib/mysql/percona/db.opt'
innobackupex: Backing up file '/var/lib/mysql/percona/backups.frm'
innobackupex: Backing up files '/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)
130507 18:02:03  innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files

innobackupex: Resuming ibbackup

xtrabackup: The latest check point (for incremental): '1608865'
xtrabackup: Stopping log copying thread.
..>> log scanned up to (1608865)

xtrabackup: Transaction log of lsn (1608865) to (1608865) was copied.
130507 18:02:05  innobackupex: All tables unlocked
130507 18:02:05  innobackupex: Connection to database server closed

innobackupex: Backup created in directory '/backup/bkps/2013-05-07_18_01_40'
innobackupex: MySQL binlog position: filename '1.000001', position 795
130507 18:02:05  innobackupex: completed OK!

Xtrabackup finished: Tue May  7 18:02:05 PDT 2013


Syncing binary log snapshots
 ... done
Apply log started: Tue May  7 18:02:05 PDT 2013
Preparing base backup with /usr/bin/innobackupex  --use-memory=1G --apply-log --redo-only /backup//bkps/P_2013-05-07_18_01_40

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".



130507 18:02:05  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/backup/bkps/P_2013-05-07_18_01_40/backup-my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/backup/bkps/P_2013-05-07_18_01_40 --apply-log-only --use-memory=1G

xtrabackup_55 version 2.0.3 for Percona Server 5.5.16 Linux (x86_64) (revision id: undefined)
xtrabackup: cd to /backup/bkps/P_2013-05-07_18_01_40
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1608865)
xtrabackup: Temporary instance for recovery is set 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 = 1
xtrabackup:   innodb_log_file_size = 2097152
130507 18:02:05 InnoDB: Using Linux native AIO
xtrabackup: Temporary instance for recovery is set 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 = 1
xtrabackup:   innodb_log_file_size = 2097152
130507 18:02:05 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 1073741824 bytes for buffer pool (set by --use-memory parameter)
130507 18:02:05 InnoDB: The InnoDB memory heap is disabled
130507 18:02:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130507 18:02:05 InnoDB: Compressed tables use zlib 1.2.3
130507 18:02:05 InnoDB: Using Linux native AIO
130507 18:02:05 InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
130507 18:02:05 InnoDB: Initializing buffer pool, size = 1.0G
130507 18:02:06 InnoDB: Completed initialization of buffer pool
130507 18:02:06 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130507 18:02:06  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
130507 18:02:06  InnoDB: Starting shutdown...
130507 18:02:06  InnoDB: Shutdown completed; log sequence number 1608865
130507 18:02:06  innobackupex: completed OK!

Apply log finished: Tue May  7 18:02:06 PDT 2013

Cleaning up previous backup files:
 ... done

Backup size: 19M
Remaining space on backup on device: 72G
Logfile: /backup//bkps/2013-05-07_18_01_40.log