[MySQL生产环境数据恢复]innobackupex:fatalerror:ORno'da_MySQL

[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既可解决此问题。