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 > > > ------------------------------------------------------------------------- > 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 > -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de ------------------------------------------------------------------------- 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
