由于my.cnf里没有配置datadir参数导致数据库无法恢复

[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/