hi there,

I cannot get MySQL fifo backups to work. If I run the
backup job it hangs forever waiting for the input. If I
run the job manually from the shell it works without
problems. What is going on?

My job and fileset definition are as follows:


Job {
  Name = "MyDatabaseFull"
  JobDefs = "DefaultBackup"
  FileSet = "MyDatabaseFileSet"
  Write Bootstrap = "/backup/bootstrap/MyDatabase"
  ClientRunBeforeJob = "/backup/scripts/MyDatabase before"
  ClientRunAfterJob = "/backup/scripts/MyDatabase after"
  Priority = 20
}
FileSet {
  Name = "MyDatabaseFileSet"
  Include {
    Options {
      signature = SHA1
      compression = GZIP
      readfifo = yes
    }
    File = "/backup/fifo/MyDatabase"
  }
}


The script being called:


#!/bin/sh

database=mydb
user=root
password="***"
fifo=/backup/fifo/MyDatabase

case "$1" in
  before)
    echo Before backup job processing...
    rm -f $fifo 2>&1 < /dev/null
    mkfifo $fifo 2>&1 < /dev/null
    echo Dumping $database to fifo: $fifo
    mysqldump --user=$user --password=$password $database & > $fifo 2>&1 < 
/dev/null
    echo Done.
    ;;
  after)
    echo After backup job processing...
    rm -f $fifo 2>&1 < /dev/null
    echo Done.
    ;;
esac


regards
Frank



-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to