Failed to connect to MySQL server to detect version.

用xtrabackup进行数据备份恢复时出现如下问题:


InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

and Percona Inc 2009-2011.  All Rights Reserved.


This software is published under

the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.


option_ibbackup_binary is autodetect, trying to connect to MySQL

Connected to MySQL with pid 6358

Failed to connect to MySQL server to detect version.

You must set xtrabackup version to use with --ibbackup option.

Possible values are xtrabackup_51 (for MySQL 5.0 and 5.1) or xtrabackup (for MySQL 5.1 with InnoDB plugin or Percona Server)

原因:

  Xtrabackup是一个对InnoDB做数据备份的工具

解决:

  1. 使用其它备份方式。如mysqldump

  2. 修改数据库引擎。。。(推荐),,尽量使用InnoDB引擎。

查看数据引擎:

show crate table table_test;

修改数据引擎:

alter table table_name engine=innodb;


Failed to connect to MySQL server to detect version.,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。