最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL

来源:动视网 责编:小采 时间:2020-11-09 18:40:01
文档

xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL

xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL:bitsCN.com xtrabackup: Error: Please set parameter 'datadir',innobackupex: fatal error: no 'mysqld' group in解决 -- 报错:[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbac
推荐度:
导读xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL:bitsCN.com xtrabackup: Error: Please set parameter 'datadir',innobackupex: fatal error: no 'mysqld' group in解决 -- 报错:[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbac


bitsCN.com

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

-- 报错:

[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe 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 closedIMPORTANT: 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.1innobackupex: 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 optionsinnobackupex: 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/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe 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 closedIMPORTANT: 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.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.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/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe 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 closedIMPORTANT: 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.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

开始复制进行

.................

bitsCN.com

文档

xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL

xtrabackup:Error:Pleasesetparameter'datadir',innoback_MySQL:bitsCN.com xtrabackup: Error: Please set parameter 'datadir',innobackupex: fatal error: no 'mysqld' group in解决 -- 报错:[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbac
推荐度:
标签: error mysql back
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top