[root@hostname mysql]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.28 Distributed by The IUS Community Project

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database xtrabackup_test;
Query OK, 1 row affected (0.01 sec)

mysql> use xtrabackup_test;
Database changed
mysql> create table dummy_table (c1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[root@hostname mysql]# innobackupex /tmp/

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.

130205 10:44:45  innobackupex: Starting mysql with options:  --unbuffered --
130205 10:44:45  innobackupex: Connected to database with mysql child process (pid=27541)
130205 10:44:51  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 (i686) 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 /tmp/2013-02-05_10-44-51
130205 10:44:51  innobackupex: Starting mysql with options:  --unbuffered --
130205 10:44:51  innobackupex: Connected to database with mysql child process (pid=27567)
130205 10:44:53  innobackupex: Connection to database server closed

130205 10:44:53  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2013-02-05_10-44-51
innobackupex: Waiting for ibbackup (pid=27574) to suspend
innobackupex: Suspend file '/tmp/2013-02-05_10-44-51/xtrabackup_suspended'

xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
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
>> log scanned up to (1608274)
[01] Copying ./ibdata1 to /tmp/2013-02-05_10-44-51/ibdata1
[01]        ...done
[01] Copying ./xtrabackup_test/dummy_table.ibd to /tmp/2013-02-05_10-44-51/./xtrabackup_test/dummy_table.ibd
[01]        ...done

130205 10:44:55  innobackupex: Continuing after ibbackup has suspended
130205 10:44:55  innobackupex: Starting mysql with options:  --unbuffered --
130205 10:44:55  innobackupex: Connected to database with mysql child process (pid=27588)
130205 10:44:57  innobackupex: Starting to lock all tables...
>> log scanned up to (1608274)
>> log scanned up to (1608274)
130205 10:45:07  innobackupex: All tables locked and flushed to disk

130205 10:45:07  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/xtrabackup_test/dummy_table.frm'
innobackupex: Backing up file '/var/lib/mysql/xtrabackup_test/db.opt'
innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)
innobackupex: Backing up files '/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
130205 10:45:08  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): '1608274'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1608274)

xtrabackup: Transaction log of lsn (1608274) to (1608274) was copied.
130205 10:45:10  innobackupex: All tables unlocked
130205 10:45:10  innobackupex: Connection to database server closed

innobackupex: Backup created in directory '/tmp/2013-02-05_10-44-51'
innobackupex: MySQL binlog position: filename '', position
130205 10:45:10  innobackupex: completed OK!
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]# ls -alh /tmp/2013-02-05_10-4
2013-02-05_10-43-00/ 2013-02-05_10-44-51/
[root@hostname mysql]# ls -alh /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
-rw------- 1 root root 96K Feb  5 10:44 /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]# innobackupex --apply-log /tmp/2013-02-05_10-44-51/

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!".



130205 10:46:03  innobackupex: Starting ibbackup with command: xtrabackup_55  --defaults-file="/tmp/2013-02-05_10-44-51/backup-my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/tmp/2013-02-05_10-44-51

xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
xtrabackup: cd to /tmp/2013-02-05_10-44-51
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1608274)
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
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
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
130205 10:46:03 InnoDB: The InnoDB memory heap is disabled
130205 10:46:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130205 10:46:03 InnoDB: Compressed tables use zlib 1.2.3
130205 10:46:03 InnoDB: Initializing buffer pool, size = 100.0M
130205 10:46:03 InnoDB: Completed initialization of buffer pool
130205 10:46:03 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!
130205 10:46:03  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
130205 10:46:03  InnoDB: Waiting for the background threads to start
130205 10:46:04 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1608274

[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
130205 10:46:04  InnoDB: Starting shutdown...
130205 10:46:08  InnoDB: Shutdown completed; log sequence number 1609488

130205 10:46:08  innobackupex: Restarting xtrabackup with command: xtrabackup_55  --defaults-file="/tmp/2013-02-05_10-44-51/backup-my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/tmp/2013-02-05_10-44-51
for creating ib_logfile*

xtrabackup_55 version 2.0.4 for Percona Server 5.5.16 Linux (i686) (revision id: 484)
xtrabackup: cd to /tmp/2013-02-05_10-44-51
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
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 = 2
xtrabackup:   innodb_log_file_size = 5242880
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 = 2
xtrabackup:   innodb_log_file_size = 5242880
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
130205 10:46:08 InnoDB: The InnoDB memory heap is disabled
130205 10:46:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130205 10:46:08 InnoDB: Compressed tables use zlib 1.2.3
130205 10:46:08 InnoDB: Initializing buffer pool, size = 100.0M
130205 10:46:08 InnoDB: Completed initialization of buffer pool
130205 10:46:08  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130205 10:46:08  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130205 10:46:08 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!
130205 10:46:08  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
130205 10:46:08  InnoDB: Waiting for the background threads to start
130205 10:46:09 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1609740

[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
130205 10:46:09  InnoDB: Starting shutdown...
130205 10:46:13  InnoDB: Shutdown completed; log sequence number 1609740
130205 10:46:13  innobackupex: completed OK!
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]#
[root@hostname mysql]# ls -alh /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
-rw------- 1 root root 1.0M Feb  5 10:46 /tmp/2013-02-05_10-44-51/xtrabackup_test/dummy_table.ibd
[root@hostname mysql]#