innobackupex throwing error

  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex throwing error

    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.