> Thanks Scott,
>
> Can I assume the script does all of the waiting required before starting
> the data backup? How would this differ from just setting up a shell
> script that has a mysqldump statement in it? I don't read Perl real well
> and didn't see anything that does that (at least based on my knowledge
> of Perl) and just skimming the file.
>
> Sorry do be demanding, but this is the crutch of the problem I had
> before. Any type of shell didn't return a code before timing out. The
> manual addresses this, but in a couple of different ways. At the present
> time, by doing the mysqldump from cron locally on the client, and using
> logrotate to keep the directory clean, it works pretty well, but still
> I'd like to get it working with the benefit of ClientRunBefore.
>
Yes, I use this script with bacula as mentioned before and it works great
for me. I keep one week of bzip2 files which contain a dump of each of my
MySQL databases. Each day I receive an e-mail which contains the output
from this script (databases that were backed up, compressed file names,
etc. Again, this works great for me, but may not be right for everyone.
Actually the make_catalog_backup script, which is used in the
BackupCatalog Job {} definition, that comes with bacula is basically doing
exactly what you are trying to accomplish. It uses mysqldump to dump the
bacula database to a file. That file is backed up, and then the file is
deleted after the backup is completed. Possibly you just want to take a
look at the make_catalog_backup script and the BackupCatalog job for an
example?
I am sure there are many different processes people have implemented to
accomplish this task, I was just mentioning the one I chose and works well
for me.
Good Luck.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
