On Wed, Feb 4, 2009 at 12:14 PM, Reynier Perez Mira <rper...@uci.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
