Failed to connect to MySQL server to detect version.

The following issues occur when using Xtrabackup for data backup recovery:

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 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 is xtrabackup_51 (for MySQL 5.0 and 5.1) or xtrabackup (for MySQL 5.1 with InnoDB plugin or Percona Serve R

Reason:

Xtrabackup is a tool for data backup of InnoDB

Solve:

1. Use a different backup method. such as Mysqldump

2. Modify the Database engine ... (recommended), try to use the InnoDB engine.

To view the data engine:

Show Crate table table_test;

To modify the data engine:

ALTER TABLE table_name ENGINE=INNODB;