I just installed percona server and loaded all my data from existing mysql installation on a different host. i did that by moving the entire datadir to the new machine. i am able to see the data in mysql client.
but innobackupex is not working for me. xtrabackup is working. but i have some tables that are myISAM, so i need innobackupex. also xtrabackup doesn’t backup the schema right.
can someone help? this is an aws ec2 linux instance.
[ec2-user@ip-10-68-145-124 bin]$ sudo ./innobackupex --user=USER --password=PASSWORD --use-memory=4G /media/ephemeral0/mysql_backups_innobackupex
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.
111004 00:37:33 innobackupex: Starting mysql with options: --password=‘yantra_123’ --user=‘root’ --unbuffered –
111004 00:37:33 innobackupex: Connected to database with mysql child process (pid=4922)
innobackupex: Error: mysql child process has died: sh: mysql: command not found
the interesting thing is that i can run the mysql command above and also run the hello check that the innobackupex is running. i don’t know why its not working then.