[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

?

?