Backing up the InnoDB engine's database using Xtrabackup

The InnoDB engine database can be backed up using mysqldump, and if the table is large dozens of g or even hundreds of G, the display with mysqldump backup will be very slow. Then use Xtrabackup to quickly back up the InnoDB database online.
InnoDB has a commercial InnoDB hotbackup, which enables online hot-provisioning of the InnoDB engine's tables. and Percona produced Xtrabackup, is a innodb hotbackup an open source alternative, can be online to the INNODB/XTRADB engine of the table for physical backup. Innobackupex is a reference to InnoDB Hotbackup's innoback script modification, mainly to facilitate the backup of InnoDB and MyISAM engine tables, and to include some of the options used, such as – Slave-info can record backup recovery, as slave need some information, according to this information, can easily use Backup to redo slave.
Updated as follows:
http://www.percona.com/mysql/xtrabackup/0.7/
Install the following:
Tar zxf xtrabackup-0.7.tar.gz
CD xtrabackup-0.7
./configure
Make
Never make the install but follow the steps below.
CD innobase/xtrabackup/
Make
Make install

Then, you will install two tools in your/usr/bin directory: xtrabackup,innobackupex-1.5.1

The xtrabackup can back up the INNODB data table without locking, but the tool cannot manipulate MyISAM.
innobackupex-1.5.1 is a script wrapper that can handle both InnoDB and MyISAM, but requires a read lock when processing MyISAM.

/usr/bin/xtrabackup--backup--target-dir=/backup/mysqlbackup Here the Target-dir is to be backed up to the directory, this tool does not specify the database name, All databases of the INNODB engine are backed up by default.
When the backup is over, you will see a library of InnoDB engines under Target-dir, but it is strange that there is no backup. frm file, this is not the case, you need to manually copy one copy.


As for recovery, copy back is OK.

Backing up the InnoDB engine's database using Xtrabackup