Re: [Bacula-users] Moved to new NFS storage

Hi Neil,

Yes, as Phil said, something is generating the bacula.sql. Maybe a catalog backup job, where you have the make_catalog_backup script configured or something else. I can´t see a "log.sql". Instead I see a "log" file. This is the log file generated by Bacula according to your Messages resource configuration (specifically in this line: append = "/var/spool/bacula/log" = all, !skipped). You can delete this file if you do not need the log from your previous installation. But if you keep this configuration, Bacula will continue to append to this file as it is configured in your Messages resource.

Best regards,

Ana

On Thu, Jun 11, 2015 at 1:11 PM, Phil Stracchino <phils AT caerllewys DOT net> wrote:

On 06/11/15 09:59, Neil wrote:
> Hi Phil and Ana,
>
> Thank you for your replies. I didn't do any database dumps and the files
> have been updated today as can be seen by the datastamps below, so I'm
> concerned about removing the files. Below is the output of all the files
> under this folder...
>
> -rw-r----- 1 root root 2.2K Jun 11 15:33 bacula-dir.9101.state
> -rw-r----- 1 root root 2.0G Jun 1 12:45
> bacula-dir.BackupCatalog.2015-06-01_10.30.16_01.-1543443896.mail
> -rw-r----- 1 root root 410 Jun 10 05:55
> bacula-dir.bacula-dir.14381816.mail
> -rw-r----- 1 root root 410 Jun 9 05:56
> bacula-dir.bacula-dir.14914296.mail
> -rw-r----- 1 root root 410 Jun 8 08:15
> bacula-dir.bacula-dir.28189432.mail
> -rw------- 1 root root 2.5K Jun 11 15:33 bacula-dir.conmsg
> -rw-r----- 1 root root 0 Jun 11 2014
> bacula-dir.MAIL.2014-05-28_23.05.00_15.13058968.mail
> -rw-r----- 1 root root 2.2K Jun 11 13:43 bacula-fd.9102.state
> -rw-r----- 1 root root 221 Jun 11 01:28 bacula-fd.bsr
> -rw-r----- 1 root root 2.2K Jun 11 15:33 bacula-sd.9103.state
> -rw------- 1 root root 8.6G Jun 11 01:31 bacula.sql
> -rw-r----- 1 root root 2.0G Jun 11 15:33 log
>
> I've looked through my config files referencing /var/spool/bacula and
> below are the various config options...
>
> /etc/bacula/bacula-dir.conf: WorkingDirectory = /var/spool/bacula
> /etc/bacula/bacula-dir.conf: File = /var/spool/bacula
> /etc/bacula/bacula-dir.conf: File = "/var/spool/bacula/bacula.sql"
> /etc/bacula/bacula-dir.conf: append = "/var/spool/bacula/log" = all,
> !skipped
> /etc/bacula/bacula-fd.conf: WorkingDirectory = /var/spool/bacula
> /etc/bacula/bacula-sd.conf: WorkingDirectory = /var/spool/bacula
>
> Does this help in determining what files these are?

Well, that seems to fairly clearly indicate that those.sql files are
created (and refreshed daily) by whatever database backup script you are
using.

--
Phil Stracchino
Babylon Communications
phils AT caerllewys DOT net
phil AT co.ordinate DOT org
Landline: 603.293.8485

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users