Restoring a Full Backup with innobackupex

蔚落 2022-08-11 00:41 142阅读 0赞

# Restoring a Full Backup with **innobackupex** #

For convenience, **innobackupex** has a *--copy-back* option, which performs the restoration of a backup to the server’s[datadir][]

$ innobackupex --copy-back /path/to/BACKUP-DIR

It will copy all the data-related files back to the server’s [datadir][], determined by the server’s my.cnf configuration file. You should check the last line of the output for a success message:

innobackupex: Finished copying back files.
    
    111225 01:08:13  innobackupex: completed OK!

Note

The [datadir][] must be empty; *Percona XtraBackup* [innobackupex --copy-back][] option will not copy over existing files. Also it’s important to note that MySQL server needs to be shut down before restore is performed. You can’t restore to a [datadir][] of a running mysqld instance (except when importing a partial backup).

As files’ attributes will be preserved, in most cases you will need to change the files’ ownership to mysql before starting the database server, as they will be owned by the user who created the backup:

$ chown -R mysql:mysql /var/lib/mysql

Also note that all of these operations will be done as the user calling **innobackupex**, you will need write permissions on the server’s [datadir][].

备注：该篇技术文档是与MySQL数据库中的“备份恢复”主题相关的技术主题。  
  
  
本文转载自：http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/restoring\_a\_backup\_ibk.html

[datadir]: http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-datadir
[innobackupex --copy-back]: http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--copy-back