设为首页 加入收藏

TOP

[MySQL生产环境数据恢复]innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options(二)
2015-07-24 11:15:16 来源: 作者: 【 】 浏览:5
Tags:MySQL 生产 环境 数据恢复 innobackupex: fatal error: ' datadir' option group mysqld' options
up_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既可解决此问题。
?
首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇数据库的优化tips 下一篇linuxmysql定时备份并压缩

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·Java 编程和 c 语言 (2025-12-25 08:19:48)
·. net内存管理宝典这 (2025-12-25 08:19:46)
·C++为什么不加上内存 (2025-12-25 08:19:44)
·MySQL 安装及连接-腾 (2025-12-25 06:20:28)
·MySQL的下载、安装、 (2025-12-25 06:20:26)