Arno Lehmann wrote: > Hi, > > 06.11.2008 11:32, Isabel Bermejo wrote: > >> Hi all, >> >> I'm trying to backup a MySQL database and in the Job Resource I define the >> command RunBeforeJob with a script that dumps the database to a fifo file. I >> need to run both at the same time, I mean I want to run the script while >> bacula runs the job. With RunBeforeJob, first dumps the database and then >> starts the backup of a file. Does anyone know how to run a script in >> background using RunBeforeJob to perform the dump and the backup job run at >> the same time? >> > > The solution to that is to start the MySQL dump in the background. In > your run before job script, you'd create (or make sure it's useable) > the FIFO, then start mysqldump with an "&" at the end of the command > line. That sends the mysqldump to the background - you'll probably > need to detach from stdin, stdout and stderr first as these file > handles, when kept open, can prevent Bacula from going further. > > I believe I pointed you to a wiki page where a collection of sample > scripts is presented which backs up PostgreSQL in that fashion - > adapting those to MySQL should be possible without changing the stuff > around the actual database interface. > > Arno > > >> Thank you >> ISABEL >> The "&" is one way of doing it. I suspect a careful "nohup" would do just the same. For some instances I even use screen to work around parallel processes, not only for Bacula issues.
You _could_ even start a second job, an admin job for instance that takes care of the dumping. A carefully placed "echo \"run job=\"TheJobName\" yes | bconsole\"" will work wonders. Hope that helps, regards... -- Mit freundlichen Grüßen Ronald Buder Dipl-Ing.(BA) Profi.Com AG Büro Dresden Stresemannplatz 3 D-01309 Dresden mail: [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
