Heim  >  Fragen und Antworten  >  Hauptteil

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 实战心得(都是心酸血泪啊)

阿神阿神2764 Tage vor666

Antworte allen(1)Ich werde antworten

  • 巴扎黑

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

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

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

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

    通过上面的帮助与自己的领悟,终于看到效果了

    Antwort
    0
  • StornierenAntwort