恢复数据库
[root@slave-test fullbackup]# innobackupex --copy-back /data/fullbackup/2015-10-12_15-24-06/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
151012 20:40:09 innobackupex: Starting the copy-back operation
IMPORTANT: 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/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original data directory '/var/lib/mysql'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_info' to '/var/lib/mysql/xtrabackup_info'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_binlog_pos_innodb' to '/var/lib/mysql/xtrabackup_binlog_pos_innodb'
innobackupex: Creating directory '/var/lib/mysql/bhdw_qa'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/bhdw_qa/db.opt' to '/var/lib/mysql/bhdw_qa/db.opt'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/bhdw_qa/user_logins.ibd' to '/var/lib/mysql/bhdw_qa/user_logins.ibd'
...
...
innobackupex: Starting to copy InnoDB system tablespace
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original InnoDB data directory '/var/lib/mysql/'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ibdata1' to '/var/lib/mysql/ibdata1'
innobackupex: Starting to copy InnoDB undo tablespaces
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to '/var/lib/mysql'
innobackupex: Starting to copy InnoDB log files
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ib_logfile0' to '/var/lib/mysql/ib_logfile0'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ib_logfile1' to '/var/lib/mysql/ib_logfile1'
innobackupex: Finished copying back files.
151012 20:44:21 innobackupex: completed OK!
[root@slave-test fullbackup]# echo $?
0
[root@slave-test fullbackup]#
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。