bitscn.com
[mysql生产环境数据恢复]innobackupex: fatal error: or no 'datadir' option in group 'mysqld' in mysql options
1 执行恢复命令 
[xxx@xxx-c001db1 tmp]$ time /usr/bin/innobackupex --rsync --user=user --password=#xxx$ /mysqldata/shared/backup
[--rsync ] 可以记录master点，以便进行复制设置。
innodb backup utility v1.5.1-xtrabackup; copyright 2003, 2009 innobase oy
and percona inc 2009-2012.  all rights reserved.
this software is published under
the gnu general public license version 2, june 1991.
131023 04:26:26  innobackupex: starting mysql with options:  --password=xxxxxxxx --user='user' --unbuffered --
131023 04:26:26  innobackupex: connected to database with mysql child process (pid=24497)
131023 04:26:32  innobackupex: connection to database server closed
important: please check that the backup run completes successfully.
           at the end of a successful backup run innobackupex
           prints completed ok!.
innobackupex: using mysql  ver 14.14 distrib 5.5.25a, for linux (x86_64) using readline 5.1
innobackupex: using mysql server version copyright (c) 2000, 2011, oracle and/or its affiliates. all rights reserved.
xtrabackup: error: please set parameter 'datadir'
innobackupex: fatal error: no 'mysqld' group in mysql options
innobackupex: fatal error: or no 'datadir' option in group 'mysqld' in mysql options
real    0m6.379s
user    0m0.219s
sys     0m0.124s
mysql    26087 26086  0 04:32 pts/3    00:00:00 -bash
2  去check 配置文件有无datadir配置参数。
[xxx@xxx-c001db1 sharding_setup_1]$ cat /xxx/xxx/xxx/5.5.25a/my.cnf |grep datadir
datadir=/mysqldata/data
看起来my.cnf里面已经配置了。
3  自定义备份制定my.cnf，试下看。
[xxx@xxx-c001db1 backup]$ time /usr/bin/innobackupex --rsync --user=user --password=#xxx$ --defaults-file=/opt/xxx/xxx/5.5.25a/my.cnf  /mysqldata/backup
innodb backup utility v1.5.1-xtrabackup; copyright 2003, 2009 innobase oy
and percona inc 2009-2012.  all rights reserved.
this software is published under
the gnu general public license version 2, june 1991.
131023 06:33:41  innobackupex: starting mysql with options:  --defaults-file='/opt/xxx/xxx/5.5.25a/my.cnf' --password=xxxxxxxx --user='user' --unbuffered --
131023 06:33:41  innobackupex: connected to database with mysql child process (pid=22321)
131023 06:33:47  innobackupex: connection to database server closed
important: please check that the backup run completes successfully.
           at the end of a successful backup run innobackupex
           prints completed ok!.
innobackupex: using mysql  ver 14.14 distrib 5.5.25a, for linux (x86_64) using readline 5.1
innobackupex: using mysql server version copyright (c) 2000, 2011, oracle and/or its affiliates. all rights reserved.
innobackupex: created backup directory /mysqldata/shared/backup/2013-10-23_06-33-47
131023 06:33:47  innobackupex: starting mysql with options:  --defaults-file='/opt/xxx/xxx/5.5.25a/my.cnf' --password=xxxxxxxx --user='user' --unbuffered --
131023 06:33:47  innobackupex: connected to database with mysql child process (pid=22358)
131023 06:33:49  innobackupex: connection to database server closed
131023 06:33:49  innobackupex: starting ibbackup with command: xtrabackup_55  --defaults-file=/opt/xxx/xxx/5.5.25a/my.cnf --backup --suspend-at-end --target-dir=/mysqldata/shared/backup/2013-10-23_06-33-47
innobackupex: waiting for ibbackup (pid=22419) to suspend
innobackupex: suspend file '/mysqldata/shared/backup/2013-10-23_06-33-47/xtrabackup_suspended'
xtrabackup_55 version 2.0.0 for percona server 5.5.16 linux (x86_64) (revision id: 417)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mysqldata/data
xtrabackup: target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = /mysqldata/data
xtrabackup:   innodb_data_file_path = ibdata01:1g:autoextend
xtrabackup:   innodb_log_group_home_dir = /mysqldata/iblogs
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 1073741824
131023  6:33:49 innodb: using linux native aio
xtrabackup: using o_direct
131023  6:33:49  innodb: warning: allocated tablespace 68, old maximum was 9
>> log scanned up to (450994458760)
[01] copying /mysqldata/data/ibdata01 to /mysqldata/shared/backup/2013-10-23_06-33-47/ibdata01
>> log scanned up to (450994626288)
>> log scanned up to (450994768050)
[01]        ...done
[01] copying ./billing/enum_invoice_tax_status.ibd to /mysqldata/shared/backup/2013-10-23_06-33-47/./xxx/xxxxtb.ibd
[01]        ...done
.......
4 ok，成功了，在innobackupex的命令行上面指定--defaults-file=/opt/xxx/xxx/5.5.25a/my.cnf既可解决此问题。
bitscn.com