ITPub博客

首页 > 数据库 > MySQL > innobackupex 使用错误一例

innobackupex 使用错误一例

原创 MySQL 作者:e71hao 时间:2015-10-08 18:59:32 0 删除 编辑
一、请看错误:
-bash-3.2$ ./innobackupex --version-check /usr/mysql/xtraback/xtrabackup03
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
150930 17:16:26  innobackupex: Executing a version check against the server...
150930 17:16:26  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
        main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
150930 17:16:26  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
        main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
二、错误分析:innobackupex是用perl编写的自动化备份工具,perl用了DBI来连接mysql数据库。
三、解决办法:在操作系统中安装perl,DBI,DBD-mysql
四、上面那个错误日志,搜索错误关键词也有一定技巧。我刚开始搜索的关键字是:“ got a fatal error with the following stacktrace: at ./innobackupex”,找到一些无关的文章。又使用关键字:“Error: Failed to connect to MySQL server ”,找到文章也是关联性不够大。最后使用关键字:“DBD::mysql module is not installed ”,才找到合适的文章。
五、把这个错误记录下来,希望对同学有帮助

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30393770/viewspace-1813516/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 疑问
请登录后发表评论 登录
全部评论

注册时间:2015-08-05

  • 博文量
    106
  • 访问量
    118588