用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做数据备份的工具
解决:
使用其它备份方式。如mysqldump
修改数据库引擎。。。(推荐),,尽量使用InnoDB引擎。
查看数据引擎:
show crate table table_test;
修改数据引擎:
alter table table_name engine=innodb;
Failed to connect to MySQL server to detect version.,布布扣,bubuko.com
Failed to connect to MySQL server to detect version.
原文:http://dihuo.blog.51cto.com/1657091/1413797