[root@localhostlib]# innobackupex --user=root --password=123456 --copy-back/root/2015-07-14_15-17-32/
InnoDBBackup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
andPercona LLC and/or its affiliates 2009-2013. All Rights Reserved.
Thissoftware is published under
the GNUGENERAL PUBLIC LICENSE Version 2, June 1991.
Get thelatest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
15071416:42:04 innobackupex: Starting thecopy-back operation
IMPORTANT:Please check that the copy-back run completes successfully.
At the end of a successful copy-back runinnobackupex
prints "completed OK!".
innobackupex:got a fatal error with the following stacktrace: at /usr/bin/innobackupex line4545
main::get_option('datadir') called at/usr/bin/innobackupex line 2450
main::copy_back(0) called at/usr/bin/innobackupex line 1578
innobackupex: Error: no 'datadir' option in group 'mysqld' inserver configuration file '' at /usr/bin/innobackupexline 4545.
解决方法:
此报错是由于/etc/my.cnf里面没有定义datadir变量,只需在此配置文件中添加即可
[root@localhost mysql]# vim /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
~
[root@localhostmysql]# innobackupex --user=root --password=123456 --copy-back/root/2015-07-14_15-17-32/
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
150714 16:48:44 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 '/root/2015-07-14_15-17-32'
innobackupex: back to original data directory '/usr/local/mysql/data'
innobackupex: Copying '/root/2015-07-14_15-17-32/xtrabackup_binlog_pos_innodb' to '/usr/local/mysql/data/xtrabackup_binlog_pos_innodb'
innobackupex: Copying '/root/2015-07-14_15-17-32/xtrabackup_info' to '/usr/local/mysql/data/xtrabackup_info'
innobackupex: Creating directory '/usr/local/mysql/data/@0024database2'
innobackupex: Copying '/root/2015-07-14_15-17-32/@0024database2/db.opt' to '/usr/local/mysql/data/@0024database2/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/test'
innobackupex: Copying '/root/2015-07-14_15-17-32/test/db.opt' to '/usr/local/mysql/data/test/db.opt'
innobackupex: Creating directory '/usr/local/mysql/data/tiankedb'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/db.opt' to '/usr/local/mysql/data/tiankedb/db.opt'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/tianke.frm' to '/usr/local/mysql/data/tiankedb/tianke.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/tiankedb/tianke.ibd' to '/usr/local/mysql/data/tiankedb/tianke.ibd'
innobackupex: Creating directory '/usr/local/mysql/data/jiaowu'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/totor.frm' to '/usr/local/mysql/data/jiaowu/totor.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/scores.ibd' to '/usr/local/mysql/data/jiaowu/scores.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students1.frm' to '/usr/local/mysql/data/jiaowu/students1.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sutdents2.ibd' to '/usr/local/mysql/data/jiaowu/sutdents2.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/sutdents2.frm' to '/usr/local/mysql/data/jiaowu/sutdents2.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/totor.ibd' to '/usr/local/mysql/data/jiaowu/totor.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students1.ibd' to '/usr/local/mysql/data/jiaowu/students1.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/db.opt' to '/usr/local/mysql/data/jiaowu/db.opt'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students.ibd' to '/usr/local/mysql/data/jiaowu/students.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors1.ibd' to '/usr/local/mysql/data/jiaowu/tutors1.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors.frm' to '/usr/local/mysql/data/jiaowu/tutors.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors1.frm' to '/usr/local/mysql/data/jiaowu/tutors1.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/students.frm' to '/usr/local/mysql/data/jiaowu/students.frm'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/tutors.ibd' to '/usr/local/mysql/data/jiaowu/tutors.ibd'
innobackupex: Copying '/root/2015-07-14_15-17-32/jiaowu/courses.frm' to '/usr/local/mysql/data/jiaowu/courses.frm'
innobackupex: Copying '/root/