mysql - Percona XtraBackup 数据库备份工具使用问题
阿神
阿神 2017-04-17 13:10:22
0
1
664

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

阿神
阿神

闭关修行中......

Antworte allen(1)
巴扎黑

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

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

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

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

Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage
Über uns Haftungsausschluss Sitemap
Chinesische PHP-Website:Online-PHP-Schulung für das Gemeinwohl,Helfen Sie PHP-Lernenden, sich schnell weiterzuentwickeln!