XtraBackup全备与增量备份

一、XtraBackup安装下载地址：http://www.percona.com/downloads/XtraBackup/XtraBackup-2.2.8/source/安装步骤：================================How to build XtraBackup on Linux================================Prerequisites-------------
$ yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr bison libtool ncurses5-develCompiling with CMake--------------------$ cmake -DBUILD_CONFIG=xtrabackup_release && make -j4
Installation------------$ make install will install all XtraBackup binaries, the innobackupex script and tests to /usr/local/xtrabackup. You can override this either with “make DESTDIR=... install” or by changing the installation layout with “cmake -DINSTALL_LAYOUT=...”. 如果出现下面报错，需要 yum install crypt* ; yum install libgcrypt*CMake Error at cmake/gcrypt.cmake:25 （MESSAGE）:Cannot find gcrypt.h in /usr/include;/usr/local/include;/opt/local/include.You can use libgcrypt-config --cflags to get the necessary path and pass itto CMake with -DGCRYPT_INCLUDE_PATH=<path>Call Stack （most recent call first）:storage/innobase/xtrabackup/src/CMakeLists.txt:20 （FIND_GCRYPT）CMake Error at cmake/gcrypt.cmake:36 （MESSAGE）:Cannot find libgcrypt shared libraries in/usr/lib;/usr/local/lib;/opt/local/lib.You can use libgcrypt-config--libs to get the necessary path and pass it to CMake with-DGCRYPT_LIB_PATH=<path>Call Stack （most recent call first）:storage/innobase/xtrabackup/src/CMakeLists.txt:20 （FIND_GCRYPT）二、xtrabackup全备测试普通备份（全量备份）
[root@server mysql]# mkdir /data/mysql/databak
[root@server mysql]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --backup --target-dir=/data/mysql/databak/
[root@server mysql]# cp -rp data/test/students.frm databak/test/
注意：xtrabackup只备份数据文件，并不备份数据表结构（.frm），所以这里要手动备份一下，以便xtrabackup恢复的时候使用，如果是做了分表分文件保存的话，就需要挑出.frm表结构，表数据文件.ibd不需要复制全量备份恢复
实施对备份文件进行恢复前的准备
[root@server mysql]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --prepare --target-dir=/data/mysql/databak/
从备份目录复制对应数据库表结构到默认的数据目录[如果是做了分表分文件，则需要全部复制到默认的数据目录]
cp -r /data/mysql/databak/test /data/mysql/data/
删除默认数据目录中对应的数据文件并复制备份的数据文件到默认数据目录
rm /data/mysql/data/ib*
cp /data/mysql/databak/ib* /data/mysql/data/
修改数据目录权限[注意细节：mysql库的所有者是mysql，组是root]
chown -R mysql:mysql /data/mysql/data
重启MySQL
[root@server data]# /etc/init.d/mysqld restart三、xtrabackup增量备份测试1. 全备
[root@server databak]# mkdir /data/mysql/databak/
[root@server mysql]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --backup --target-dir=/data/mysql/databak/
[root@server mysql]# cp -rp data/test/students.frm databak/test/
2. 增量备份
[root@server databak]# mkdir /data/mysql/databak/delta/
[root@server databak]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --backup --incremental-basedir=/data/mysql/databak/ --target-dir=/data/mysql/databak/delta/3. 备份恢复准备[这里没有完成增量备份，增量备份数据恢复失败][root@server data]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --prepare --target-dir=/data/mysql/databak/
[root@server data]# xtrabackup --defaults-file=/usr/local/mysql/my.cnf --prepare --target-dir=/data/mysql/databak/ --incremental-dir/=/data/mysql/databak/delta/4. 恢复数据库从备份目录复制对应数据库表结构到默认的数据目录[如果是做了分表分文件，则需要全部复制到默认的数据目录]
cp -r /data/mysql/databak/test /data/mysql/data/
删除默认数据目录中对应的数据文件并复制备份的数据文件到默认数据目录
rm /data/mysql/data/ib*
cp /data/mysql/databak/ib* /data/mysql/data/
修改数据目录权限[注意细节：mysql库的所有者是mysql，组是root]
chown -R mysql:mysql /data/mysql/data四、用innobackupex 执行全备与增量备份innobackupex全备和增量备份
1. 全备[root@server mysql]# innobackupex --user=root --password=RedHat /data/mysql/databak/innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3637main::init（） called at /usr/bin/innobackupex line 1557innobackupex: Error: option "datadir" has different values:"/var/lib/mysql" in defaults file"/data/mysql/data/" in SHOW VARIABLES执行失败，需要指定配置文件路径：[root@server xtrabackup]# innobackupex --defaults-file=/usr/local/mysql/my.cnf --user=root --password=redhat /data/mysql/databak/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.150204 19:00:03innobackupex: Connecting to MySQL server with DSN "dbi:mysql:;mysql_read_default_file=/usr/local/mysql/my.cnf;mysql_read_default_group=xtrabackup" as "root"（using password: YES）.150204 19:00:03innobackupex: Connected to MySQL server150204 19:00:03innobackupex: Executing a version check against the server...150204 19:00:03innobackupex: Done.150204 19:00:03innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK！".innobackupex:Using server version 5.5.30innobackupex: Created backup directory /data/mysql/databak/2015-02-04_19-00-03150204 19:00:03innobackupex: Starting ibbackup with command: xtrabackup--defaults-file="/usr/local/mysql/my.cnf"--defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/mysql/databak/2015-02-04_19-00-03 --tmpdir=/tmp --extra-lsndir="/tmp"innobackupex: Waiting for ibbackup （pid=19209） to suspendinnobackupex: Suspend file "/data/mysql/databak/2015-02-04_19-00-03/xtrabackup_suspended_2"xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux （x86_64）（revision id: ）xtrabackup: uses posix_fadvise（）.xtrabackup: cd to /data/mysql/data/xtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup: innodb_data_home_dir = /data/mysql/dataxtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 5242880xtrabackup: using O_DIRECT>> log scanned up to （1602080）xtrabackup: Generating a list of tablespaces[01] Copying /data/mysql/data/ibdata1 to /data/mysql/databak/2015-02-04_19-00-03/ibdata1>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）>> log scanned up to （1602080）[01]...done>> log scanned up to （1602080）[01] Copying ./test/students.ibd to /data/mysql/databak/2015-02-04_19-00-03/test/students.ibd[01]...done>> log scanned up to （1602080）xtrabackup: Creating suspend file "/data/mysql/databak/2015-02-04_19-00-03/xtrabackup_suspended_2" with pid "19209"150204 19:00:17innobackupex: Continuing after ibbackup has suspended150204 19:00:17innobackupex: Executing FLUSH TABLES WITH READ LOCK...150204 19:00:17innobackupex: All tables locked and flushed to disk150204 19:00:17innobackupex: Starting to backup non-InnoDB tables and filesinnobackupex: in subdirectories of "/data/mysql/data/"innobackupex: Backing up files "/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}" （18 files）>> log scanned up to （1602080）innobackupex: Backing up file "/data/mysql/data//test/students.frm"innobackupex: Backing up files "/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}" （72 files）150204 19:00:17innobackupex: Finished backing up non-InnoDB tables and files150204 19:00:17innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...150204 19:00:17innobackupex: Waiting for log copying to finishxtrabackup: The latest check point （for incremental）: "1602080"xtrabackup: Stopping log copying thread..>> log scanned up to （1602080）xtrabackup: Creating suspend file "/data/mysql/databak/2015-02-04_19-00-03/xtrabackup_log_copied" with pid "19209"xtrabackup: Transaction log of lsn （1602080） to （1602080） was copied.150204 19:00:18innobackupex: All tables unlockedinnobackupex: Backup created in directory "/data/mysql/databak/2015-02-04_19-00-03"150204 19:00:18innobackupex: Connection to database server closed150204 19:00:18innobackupex: completed OK！ 2. 第一次增量备份
#--incremental：增量备份的文件夹
#--incremental-dir：针对哪个做增量备份[root@server databak]# innobackupex --defaults-file=/usr/local/mysql/my.cnf --user=root --password=redhat --incremental/data/mysql/databak/ --incremental-dir /data/mysql/databak/2015-02-04_19-00-03/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.150204 19:03:58innobackupex: Connecting to MySQL server with DSN "dbi:mysql:;mysql_read_default_file=/usr/local/mysql/my.cnf;mysql_read_default_group=xtrabackup" as "root"（using password: YES）.150204 19:03:58innobackupex: Connected to MySQL server150204 19:03:58innobackupex: Executing a version check against the server...150204 19:03:58innobackupex: Done.150204 19:03:58innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK！".innobackupex:Using server version 5.5.30innobackupex: Created backup directory /data/mysql/databak/2015-02-04_19-03-58150204 19:03:58innobackupex: Starting ibbackup with command: xtrabackup--defaults-file="/usr/local/mysql/my.cnf"--defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/mysql/databak/2015-02-04_19-03-58 --tmpdir=/tmp --extra-lsndir="/tmp" --incremental-basedir="/data/mysql/databak/2015-02-04_19-00-03"innobackupex: Waiting for ibbackup （pid=19349） to suspendinnobackupex: Suspend file "/data/mysql/databak/2015-02-04_19-03-58/xtrabackup_suspended_2"xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux （x86_64）（revision id: ）incremental backup from 1602080 is enabled.xtrabackup: uses posix_fadvise（）.xtrabackup: cd to /data/mysql/data/xtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup: innodb_data_home_dir = /data/mysql/dataxtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 5242880xtrabackup: using O_DIRECT>> log scanned up to （1602919）xtrabackup: Generating a list of tablespacesxtrabackup: using the full scan for incremental backup[01] Copying /data/mysql/data/ibdata1 to /data/mysql/databak/2015-02-04_19-03-58/ibdata1.delta>> log scanned up to （1602919）>> log scanned up to （1602919）>> log scanned up to （1602919）>> log scanned up to （1602919）>> log scanned up to （1602919）[01]...done[01] Copying ./test/students.ibd to /data/mysql/databak/2015-02-04_19-03-58/test/students.ibd.delta[01]...done>> log scanned up to （1602919）xtrabackup: Creating suspend file "/data/mysql/databak/2015-02-04_19-03-58/xtrabackup_suspended_2" with pid "19349"150204 19:04:05innobackupex: Continuing after ibbackup has suspended150204 19:04:05innobackupex: Executing FLUSH TABLES WITH READ LOCK...150204 19:04:05innobackupex: All tables locked and flushed to disk150204 19:04:05innobackupex: Starting to backup non-InnoDB tables and filesinnobackupex: in subdirectories of "/data/mysql/data/"innobackupex: Backing up files "/data/mysql/data//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}" （18 files）>> log scanned up to （1602919）innobackupex: Backing up file "/data/mysql/data//test/students.frm"innobackupex: Backing up files "/data/mysql/data//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}" （72 files）150204 19:04:06innobackupex: Finished backing up non-InnoDB tables and files150204 19:04:06innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...150204 19:04:06innobackupex: Waiting for log copying to finishxtrabackup: The latest check point （for incremental）: "1602919"xtrabackup: Stopping log copying thread..>> log scanned up to （1602919）xtrabackup: Creating suspend file "/data/mysql/databak/2015-02-04_19-03-58/xtrabackup_log_copied" with pid "19349"xtrabackup: Transaction log of lsn （1602919） to （1602919） was copied.150204 19:04:07innobackupex: All tables unlockedinnobackupex: Backup created in directory "/data/mysql/databak/2015-02-04_19-03-58"150204 19:04:07innobackupex: Connection to database server closed150204 19:04:07innobackupex: completed OK！[root@server databak]# ls2015-02-04_19-00-032015-02-04_19-03-58[root@server databak]# lltotal 8drwxr-xr-x. 5 root root 4096 Feb4 19:00 2015-02-04_19-00-03drwxr-xr-x. 5 root root 4096 Feb4 19:04 2015-02-04_19-03-58[root@server databak]# du -sh *1.1G2015-02-04_19-00-031.5M2015-02-04_19-03-58 3. 模拟数据丢失mysql> drop database test;Query OK, 1 row affected （0.14 sec）mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set （0.00 sec） 4. 将全备数据执行prepare[root@server 2015-02-04_19-03-58]# innobackupex --apply-log --redo-only /data/mysql/databak/2015-02-04_19-00-03/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.150204 19:10:15innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK！".150204 19:10:15innobackupex: Starting ibbackup with command: xtrabackup--defaults-file="/data/mysql/databak/2015-02-04_19-00-03/backup-my.cnf"--defaults-group="mysqld" --prepare --target-dir=/data/mysql/databak/2015-02-04_19-00-03 --apply-log-onlyxtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux （x86_64）（revision id: ）xtrabackup: cd to /data/mysql/databak/2015-02-04_19-00-03xtrabackup: This target seems to be not prepared yet.xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=（1602080）xtrabackup: using the following InnoDB configuration for recovery:xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 1xtrabackup: innodb_log_file_size = 2097152xtrabackup: using the following InnoDB configuration for recovery:xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 1xtrabackup: innodb_log_file_size = 2097152xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool （set by --use-memory parameter）InnoDB: Using atomics to ref count buffer pool pagesInnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Memory barrier is not usedInnoDB: Compressed tables use zlib 1.2.3InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, size = 100.0MInnoDB: Completed initialization of buffer poolInnoDB: Highest supported file format is Barracuda.InnoDB: The log sequence numbers 1602070 and 1602070 in ibdata files do not match the log sequence number 1602080 in the ib_logfiles！InnoDB: Database was not shutdown normally！InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages InnoDB: from the doublewrite buffer...[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 = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1602080150204 19:10:16innobackupex: completed OK！ 5. 将增量备份数据合并到全备中[root@server 2015-02-04_19-03-58]# innobackupex --apply-log --redo-only --incremental /data/mysql/databak/2015-02-04_19-00-03/ --incremental-dir=/data/mysql/databak/2015-02-04_19-03-58/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.150204 19:10:19innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK！".150204 19:10:19innobackupex: Starting ibbackup with command: xtrabackup--defaults-file="/data/mysql/databak/2015-02-04_19-00-03/backup-my.cnf"--defaults-group="mysqld" --prepare --target-dir=/data/mysql/databak/2015-02-04_19-00-03 --apply-log-only --incremental-dir=/data/mysql/databak/2015-02-04_19-03-58/xtrabackup version 2.2.8 based on MySQL server 5.6.22 Linux （x86_64）（revision id: ）incremental backup from 1602080 is enabled.xtrabackup: cd to /data/mysql/databak/2015-02-04_19-00-03xtrabackup: This target seems to be already prepared.xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=（1602919）xtrabackup: using the following InnoDB configuration for recovery:xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = /data/mysql/databak/2015-02-04_19-03-58/xtrabackup: innodb_log_files_in_group = 1xtrabackup: innodb_log_file_size = 2097152xtrabackup: Generating a list of tablespacesxtrabackup: page size for /data/mysql/databak/2015-02-04_19-03-58//ibdata1.delta is 16384 bytesApplying /data/mysql/databak/2015-02-04_19-03-58//ibdata1.delta to ./ibdata1...xtrabackup: page size for /data/mysql/databak/2015-02-04_19-03-58//test/students.ibd.delta is 16384 bytesApplying /data/mysql/databak/2015-02-04_19-03-58//test/students.ibd.delta to ./test/students.ibd...xtrabackup: using the following InnoDB configuration for recovery:xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:1G:autoextendxtrabackup: innodb_log_group_home_dir = /data/mysql/databak/2015-02-04_19-03-58/xtrabackup: innodb_log_files_in_group = 1xtrabackup: innodb_log_file_size = 2097152xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool （set by --use-memory parameter）InnoDB: Using atomics to ref count buffer pool pagesInnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Memory barrier is not usedInnoDB: Compressed tables use zlib 1.2.3InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, size = 100.0MInnoDB: Completed initialization of buffer poolInnoDB: Highest supported file format is Barracuda.InnoDB: The log sequence numbers 1602070 and 1602070 in ibdata files do not match the log sequence number 1602919 in the ib_logfiles！InnoDB: Database was not shutdown normally！InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages InnoDB: from the doublewrite buffer...[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 = 1InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1602919innobackupex: Starting to copy non-InnoDB files in "/data/mysql/databak/2015-02-04_19-03-58/"innobackupex: to the full backup directory "/data/mysql/databak/2015-02-04_19-00-03"innobackupex: Copying "/data/mysql/databak/2015-02-04_19-03-58/xtrabackup_info" to "/data/mysql/databak/2015-02-04_19-00-03/xtrabackup_info"innobackupex: Copying "/data/mysql/databak/2015-02-04_19-03-58/performance_schema/db.opt" to "/data/mysql/databak/2015-02-04_19-00-03/performance_schema/db.opt"innobackupex: Copying "/data/mysql/databak/2015-02-04_19-03-58/performance_schema/events_waits_summary_by_thread_by_event_name.frm" to "/data/mysql/databak/2015-02-04_19-00-03/performance_schema/events_waits_summary_by_thread_by_event_name.frm"innobackupex: Copying "/data/mysql/databak/2015-02-04_19-03-58/performance_schema/file_summary_by_instance.frm" to "/data/mysql/databak/2015-02-04_19-00-03/performance_schema/file_summary_by_instance.frm"
..........
150204 19:10:20innobackupex: completed OK！6. 停止mysqld服务，恢复数据[root@server 2015-02-04_19-03-58]# /etc/init.d/mysqld stopShutting down MySQL... [OK][root@server data]# innobackupex --defaults-file=/usr/local/mysql/my.cnf --copy-back /data/mysql/databak/2015-02-04_19-00-03/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.150204 19:13:47innobackupex: Starting the copy-back operationIMPORTANT: Please check that the copy-back run completes successfully. At the end of a successful copy-back run innobackupex prints "completed OK！".innobackupex: Starting to copy files in "/data/mysql/databak/2015-02-04_19-00-03"

.........innobackupex: Starting to copy InnoDB system tablespaceinnobackupex: in "/data/mysql/databak/2015-02-04_19-00-03"innobackupex: back to original InnoDB data directory "/data/mysql/data"innobackupex: Copying "/data/mysql/databak/2015-02-04_19-00-03/ibdata1" to "/data/mysql/data/ibdata1"innobackupex: Starting to copy InnoDB undo tablespacesinnobackupex: in "/data/mysql/databak/2015-02-04_19-00-03"innobackupex: back to "/data/mysql/data/"innobackupex: Starting to copy InnoDB log filesinnobackupex: in "/data/mysql/databak/2015-02-04_19-00-03"innobackupex: back to original InnoDB log directory "/data/mysql/data/"innobackupex: Finished copying back files.150204 19:13:53innobackupex: completed OK！ 7. 对恢复的文件修改权限[root@server data]# chown -R mysql:mysql *[root@server data]# chown -R mysql:root mysql/8. 启动mysql服务[root@server data]# /etc/init.d/mysqld startStarting MySQL...[OK]done ^_^更多XtraBackup相关教程见以下内容：MySQL管理之使用XtraBackup进行热备 http://www.linuxidc.com/Linux/2014-04/99671.htmMySQL开源备份工具Xtrabackup备份部署 http://www.linuxidc.com/Linux/2013-06/85627.htmMySQL Xtrabackup备份和恢复 http://www.linuxidc.com/Linux/2011-12/50275.htm用XtraBackup实现MySQL的主从复制快速部署【主不锁表】 http://www.linuxidc.com/Linux/2012-10/71919p2.htm安装和使用 Percona 推出的 Xtrabackup 备份 MySQL http://www.linuxidc.com/Linux/2011-10/44451.htmXtraBackup 的详细介绍：请点这里
XtraBackup 的下载地址：请点这里本文永久更新链接地址