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?

Thank you once again.

Regards.

Neil Wilson.

On Thu, Jun 11, 2015 at 3:02 PM, Phil Stracchino <ph...@caerllewys.net>
wrote:

> On 06/11/15 08:44, Neil wrote:
> > Hi Ana,
> >
> > Thank you very much for your reply.
> >
> > I've dropped the entire Bacula mysql database and re-created it and my
> > Bacula seems to be working and it's free'd up about 10GB's of space now,
> > however I do still have a very large /var/spool/bacula/bacula.sql (12GB)
> > and log.sql (2GB) any ideas how I prune or re-create these?
>
> What do you mean, "prune or re-create" them?  They are not part of your
> database, nor are they part of Bacula.  Where did they come from?
>
> >From the filenames, my guess would be that bacula.sql is an uncompressed
> dump files of your old Bacula database.  If that's what it is and you
> need the data in it, you could load it back into your database and
> delete it.  If you don't need the data, you could just delete it.  If
> you don't know whether you need it or not yet, try compressing it with
> gzip.
>
> I have no idea what log.sql might be.
>
>
> --
>   Phil Stracchino
>   Babylon Communications
>   ph...@caerllewys.net
>   p...@co.ordinate.org
>   Landline: 603.293.8485
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to