We are getting the below error while running innobackup on a mysql 5.0.95 database. Can anybody help please?
[root@VTRMYSQL93 bin]# ./innobackupex-1.5.1 /home/e141027/bkp --defaults-file=/etc/my.cnf --user=root
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
141117 11:28:53 innobackupex-1.5.1: Starting mysql with options: --defaults-file=‘/etc/my.cnf’ --user=‘root’ --unbuffered –
141117 11:28:53 innobackupex-1.5.1: Connected to database with mysql child process (pid=24226)
141117 11:29:00 innobackupex-1.5.1: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex-1.5.1
prints “completed OK!”.
innobackupex-1.5.1: Using mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex-1.5.1: Using mysql server version Copyright (C) 2000-2008 MySQL AB
sh: xtrabackup_51: command not found
innobackupex-1.5.1: fatal error: no ‘mysqld’ group in MySQL options
[root@VTRMYSQL93 bin]# innobackupex-1.5.1: fatal error: no ‘mysqld’
-bash: innobackupex-1.5.1:: command not found
[root@VTRMYSQL93 bin]#
[root@VTRMYSQL93 bin]# innobackupex-1.5.1: fatal error: no ‘mysqld’ group in MySQL options
As per documentation described here [url]Percona XtraBackup
“It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1 [1], 5.5 and 5.6 servers”
So you will require atleast MySQL 5.1
Sorry Xtrabackup can works fine on Mysql 5.0, the issue was that the binaries was not present in the PATH. After changing everything works well.