You are right Alan.
It's a database dump file. 
So you mean to say that I can compress the current file and rename it. So that 
next time 
Mysql will start writing onto new bacula.sql file?
Will it not affect the functionality of mysql and in turn bacula any way?
More importantly ,we wish to change the location of this directory itself.
Currently it is ,

Oldhome/tape/

Which we wish to change to new NFS share,

Newhome/tape

I hope that should not matter atall.

Any idea where to make appropriate changes for it to take effect?

Thanx,
Admin

-----Original Message-----
From: Alan Brown [mailto:ajb2 AT mssl.ucl.ac DOT uk] 
Sent: Montag, 18. Oktober 2010 12:55
To: Damian Ge;bicki
Cc: Holikar, Sachin (ext); bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Bacula mysql cleanup

Damian Ge;bicki wrote:
>
> The bacula.sql, if I good remember, it's your main CatalgoDB - sqlite.

The original poster is using mysql, not sqlite.

bacula.sql is his database dump - it's a plain ascii text file.

It can be compressed with gzip, bzip2, etc etc and you should keep 
multiple copies around (use logrotate or a similar program to maintain it)

6Gb is a small database dump, as far as Bacula use goes. Mine is in 
excess of 40Gb.


sqlite is only included for testing purposes and should not be used in a 
production environment.



------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users