On Sun, Mar 8, 2009 at 4:13 PM, Ulrich Leodolter
<ulrich.leodolter AT obvsg DOT at> wrote:
> hello,
>
> do i really need a daily catalog backup ?
> (like the default setup)
>
> isn't it enough to dump (maybe rsync)
> the catalog database to other system(s) ?
>
Yes, that will be fine. Make sure you properly dump and not just rsync
the folder containing the database. I would have each dump compressed
and have the name of the file contain the date of the dump.

Here is what I do daily for a different database backup:

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

And then every so many months I go back and delete all backups that
are older then the current month.

John

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users