xtrabackup: Error: Please set parameter 'datadir',innobackupex: fatal error: no 'mysqld' group in My

最新推荐文章于 2021-05-20 16:15:23 发布

iteye_4185

最新推荐文章于 2021-05-20 16:15:23 发布

阅读量200

点赞数

文章标签：数据库操作系统

本文详细介绍了使用InnoDBBackupUtility进行数据库备份的过程，包括解决备份过程中遇到的问题，如设置datadir参数、创建备份目录等，并提供了相关的命令示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

-- 报错:
[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbackup

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130716 10:38:27 innobackupex: Starting mysql with options: --password=xxxxxxxx --user='backupusertmp' --unbuffered --
130716 10:38:27 innobackupex: Connected to database with mysql child process (pid=6083)
130716 10:38:33 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

解决办法: 添加--defaults-file=/opt/mysql/product/5.5.25a/my.cnf参数

[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp --defaults-file=/opt/mysql/product/5.5.25a/my.cnf /mysqldata/shared/tmpbackup

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130716 10:44:29 innobackupex: Starting mysql with options: --defaults-file='/opt/mysql/product/5.5.25a/my.cnf' --password=xxxxxxxx --user='backupusertmp' --unbuffered --
130716 10:44:29 innobackupex: Connected to database with mysql child process (pid=6595)
130716 10:44:35 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: Error: Failed to create backup directory /mysqldata/shared/tmpbackup/2013-07-16_10-44-35: No such file or directory at /usr/bin/innobackupex line 371.

看到文件目录不存在,所以mkdir目录
[root@5.5.25a]# mkdir /mysqldata/shared/tmpbackup/
[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp --defaults-file=/opt/mysql/product/5.5.25a/my.cnf /mysqldata/shared/tmpbackup

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130716 10:46:24 innobackupex: Starting mysql with options: --defaults-file='/opt/mysql/product/5.5.25a/my.cnf' --password=xxxxxxxx --user='backupusertmp' --unbuffered --
130716 10:46:24 innobackupex: Connected to database with mysql child process (pid=6780)
130716 10:46:30 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!".

开始复制进行
.................

PS：有些情况是需要把innobackupex设置到linux系统的PATH环境中去。

innobackupex中的--rsync 参数可以记录下复制的binlog位置.

innobackupex --help 中看不到rsync的注释，要去官网上面看

参考: http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/innobackupex_option_reference.html?id=percona-xtrabackup:innobackupex:option_reference

--rsync

Uses thersyncutility to optimize local file transfers. When this option is specified,innobackupexusesrsyncto copy all non-InnoDB files instead of spawning a separatecpfor each file, which can be much faster for servers with a large number of databases or tables. This option cannot be used together with--stream.