The catalog is the last backup of the night. (Lower Priority and later
start time).
This is the files in my catalog FileSet.
File = /var/spool/bacula/working/bacula.sql.gz
File = /var/spool/bacula/working/mysql.sql.gz
File = /etc/bacula/bacula-dir.conf
File = /etc/bacula/bacula-schedule.conf
File = /etc/bacula/bacula-fileset.conf
File = /etc/bacula/bacula-sd.conf
File = /etc/bacula/bacula-fd.conf
File = /etc/bacula/bconsole.conf
File = /etc/bacula/RCS
File = /etc/bacula/delete_catalog_backup
File = /etc/bacula/make_catalog_backup
File = /etc/bacula/backup-mysql.sh
File = /etc/my.cnf
File = /var/spool/bacula/bacula-db-backup/bacula
File = /var/spool/bacula/bacula-db-backup/mysql
File = /etc/init.d/bacula-sd
File = /etc/init.d/bacula-fd
File = /etc/init.d/bacula-dir
/var/spool/bacula/working/bacula.sql.gz
and /var/spool/bacula/working/mysql.sql.gz are mysqldump's of the
databases.
/var/spool/bacula/bacula-db-backup/bacula
and /var/spool/bacula/bacula-db-backup/mysql are mysqlhotcopy of the
databases.
The delete_catalog_backup runs after to delete the mysqlhotcopy versions
of the DB's it also e-mails
the /var/spool/bacula/working/BackupCatalog.bsr to my personal e-mail
and my g-mail account. This way I don't have to bscan the tapes for the
catalog and I can look in the bsr file to see what tapes are required to
get my bacula system running again.
I hope that this help.
-Jason
On Tue, 2008-01-22 at 08:25 +0000, Simon Gray wrote:
> Hi guys,
>
> I have a TS3100 (LTO-4) up and running without any problems. I've
> configured Bacula to store its catalog in MySQL. Our backups are up to
> around 3TB and spanning multiple tapes, obviously the data is fairly
> useless without the catalog to retrieve it? I'm considering writing the
> catalog to a cd/dvd once a week with our full backups (plus daily
> incremental), with my idea being to separate it from the main array of
> tapes. I may even replicate the database offsite as well - but thats
> separate from this discussion.
>
> I'm interested in how others store their catalogs? do you include this
> as part of your main backup?
>
> How do you restore the data if the catalog is on the same media?
>
> Can anybody see any problems with backing up the catalog on to separate
> media?
>
> You thoughts?
>
>
> Cheers,
>
> SG
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
----------------------------------------------------------------------------
Jason A. Kates ([EMAIL PROTECTED])
Fax: 208-975-1514
Phone: 212-400-1670 x2
============================================================================
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
