+-le 28/10/2005 19:03 +0200, Kern Sibbald écrivait : | On Friday 28 October 2005 18:38, Martin Simmons wrote: |> >>>>> On Fri, 28 Oct 2005 11:13:30 +0200, Kern Sibbald <[EMAIL PROTECTED]> |> >>>>> said: |> |> Kern> On Friday 28 October 2005 10:59, Martin Simmons wrote: |> >> >>>>> On Fri, 28 Oct 2005 08:28:31 +0700, "frank" <[EMAIL PROTECTED]> |> >> >>>>> said: |> |> frank> I cannot get MySQL fifo backups to work. If I run the |> frank> backup job it hangs forever waiting for the input. If I |> frank> run the job manually from the shell it works without |> frank> problems. What is going on? |> |> frank> ... |> |> frank> #!/bin/sh |> |> frank> database=mydb |> frank> user=root |> frank> password="***" |> frank> fifo=/backup/fifo/MyDatabase |> |> frank> case "$1" in |> frank> before) |> frank> echo Before backup job processing... |> frank> rm -f $fifo 2>&1 < /dev/null |> frank> mkfifo $fifo 2>&1 < /dev/null |> frank> echo Dumping $database to fifo: $fifo |> frank> mysqldump --user=$user --password=$password $database & > |> |> >> $fifo 2>&1 < /dev/null frank> echo Done. |> |> frank> ;; |> frank> after) |> frank> echo After backup job processing... |> frank> rm -f $fifo 2>&1 < /dev/null |> frank> echo Done. |> frank> ;; |> frank> esac |> |> >> Is the mysqldump process still there when the job is hanging? |> >> |> >> What happens if you remove 2>&1? I don't see the point in redirecting |> >> stderr to the fifo anyway, but also it will hide any error messages on |> >> the tape :-) |> |> Kern> In addition, I don't see any need to redirect /dev/null to the |> input for rm, Kern> mkfifo, and mysqldump. |> |> It might be worthwhile for mysqldump, because that is backgrounded so |> doesn't want to be connected to the stdin of the script? | | Yes, this is a good point. In fact, it might even be worth while to try: | | mysqldump --user=$user --password=$password $database >$fifo 2>/dev/null | </dev/null & | | Another possible problem is that perhaps Bacula waits for the script to | finish and in doing so also waits for all children of the script to | terminate. In this case, using an Admin job that that starts before the | backup would resolve the problem.
I guess that putting a : set -m just before the call to mysqldump would do it, it will enable job control and it'll allow things to get detached. -- Mathieu Arnold ------------------------------------------------------- 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
