Home  >  Q&A  >  body text

mysql - Percona XtraBackup 数据库备份工具使用问题

按照阿里云RDS推荐的Mysql备份工具Percona xtrabackup工具 在实际擦操作过程中,一直报下面的错误,求解?

[vagrant@localhost ~]$ sudo innobackupex --defaults-file=/alidata/www/databases_backups/20150814/backup-my.cnf --apply-log /alidata/www/databases_backups/20150814/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

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

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150814 08:55:39  innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.
           At the end of a successful apply-log run innobackupex
           prints "completed OK!".

Warning: World-writable config file '/alidata/www/databases_backups/20150814/backup-my.cnf' is ignored
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 4545
	main::get_option('innodb_data_file_path') called at /usr/bin/innobackupex line 2631
	main::apply_log() called at /usr/bin/innobackupex line 1578
innobackupex: Error: no 'innodb_data_file_path' option in group 'mysqld' in server configuration file '/alidata/www/databases_backups/20150814/backup-my.cnf' at /usr/bin/innobackupex line 4545.
[vagrant@localhost ~]$

backup-my.cnf配置如下

阿里云RDS 数据库恢复工具Percona XtraBackup 实战心得(都是心酸血泪啊)

阿神阿神2713 days ago648

reply all(1)I'll reply

  • 巴扎黑

    巴扎黑2017-04-17 13:12:22

    Alibaba Cloud RDS database recovery tool Percona XtraBackup practical experience (all heartbreaking and bloody)

    • http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/

    • http://blog.csdn.net/mchdba/article/details/12970991

    Through the above help and my own understanding, I finally saw the effect

    reply
    0
  • Cancelreply