Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

    Comment


    • #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.

      Comment

      Working...
      X