On Wed, Feb 4, 2009 at 12:14 PM, Reynier Perez Mira <rperezm AT uci DOT cu> 
wrote:
>> I do it the same way bacula does it for the catalog. mysql or postgresql 
>> dump utilities. This is good if the database can be dumped in a few minutes. 
>> For example the
>> 27GB database for my bacula catalog dumps in less than 10 minutes (actually 
>> the whole job finishes in that time).
>
> And what is that way? Use the backup utility for PostgreSQL or MySQL instead 
> of use Bacula Catalog?
>
Like Ryan said check out the script for the bacula catalog backup. It
uses the dump utilities and is a good example of how to do this
directly.

For me what I do for most of my smaller database backups is have a
cron job dump the databases (compressing the dump) each night and then
have bacula do an incremental backup on the dump folder.


Here is an example of this for a mysql database:

jmd1 ~ # cat /etc/cron.daily/mythtv.cron
#! /bin/sh
mkdir -p /var/backup/mythtv
mysqlrepair --all-databases
/usr/bin/mysqldump -u mythtv mythconverg | /bin/bzip2 -c >
/var/backup/mythtv/mythtv-`date +%F`.bz2

John

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users