xtrabackup: Error: Please set parameter 'datadir',innoback_MySQL

php中文网
发布: 2016-06-01 13:31:53
原创
1706人浏览过

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
最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号