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:
Use a different backup method. such as Mysqldump
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;