innobackupex gives error on mysql child process has died & password problem

MySQL & MariaDB Percona XtraBackup
1

Hi,

(1) First question on error
I tried to did an innobackupex but it is giving me this error.

innobackupex: Error: mysql child process has died: sh: mysql: no such command

Previously i installed through rpm and it works fine (on the other server though).
Now i tried the binary package, percona-xtrabackup-2.0.1-446.tar.gz, but backup isnt working anynmore…

(2) 2nd question on password

Could someone please help me with it?

innobackupex --no-timestamp --user=root --password=xxx --defaults-file=/etc/sample/my.cnf /tmp/backup

This command works (ends with error in (1) though) but executing this on prompt will end up logging the password into system log file.
So i tried

innobackupex --no-timestamp --user=root --password=xxx --defaults-file=/etc/sample/my.cnf /tmp/backup

assuming that it will ask me to enter my password, just like the way we tried with mysql -uUSER -p
but it doesnt…
How to prompt innobackupex to ask for password from standard input?

Thank you.

2

For “innobackupex: Error: mysql child process has died: sh: mysql: no such command” first check if PATH variable is set correctly for innobackupex.

Also, provide complete command-line and output of the command, it may also be that mysql may have gone away before it executed.

3

For 2nd question on password, I guess, you have two options.

  1. You can set user and password information in my.cnf like
    [client]
    user=
    password=

  2. If you want to use it in command line but doesn’t want to include in system log file, start the command with a space so it will not be recorded.