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

**URL:** <https://forums.percona.com/t/innobackupex-gives-error-on-mysql-child-process-has-died-password-problem/2266>\
**Category:** Percona XtraBackup\
**Created:** [July 5, 2012, 10:00pm UTC](https://forums.percona.com/t/innobackupex-gives-error-on-mysql-child-process-has-died-password-problem/2266 "2012-07-05T22:00:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rei125](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@rei125](https://forums.percona.com/u/rei125)\
**Post date:** [July 5, 2012, 10:00pm UTC](https://forums.percona.com/t/innobackupex-gives-error-on-mysql-child-process-has-died-password-problem/2266/1 "2012-07-05T22:00:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![rprabhu](https://avatars.discourse-cdn.com/v4/letter/r/ce7236/32.png) [@rprabhu](https://forums.percona.com/u/rprabhu)\
**Post date:** [July 31, 2012, 3:08am UTC](https://forums.percona.com/t/innobackupex-gives-error-on-mysql-child-process-has-died-password-problem/2266/2 "2012-07-31T03:08:34Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [July 31, 2012, 3:29am UTC](https://forums.percona.com/t/innobackupex-gives-error-on-mysql-child-process-has-died-password-problem/2266/3 "2012-07-31T03:29:51Z")

</div>

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.