Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Phil Stracchino
On 01/11/12 14:21, Honia A wrote: > I'm backing up a handful number of Unix boxes, they all get backed up > very quickly but we can't access them due to the BackupCatalog job being > very slow. When I read online, I see people said it's because of the > database size getting larger and larger. 200

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread John Drescher
On Wed, Jan 11, 2012 at 2:45 PM, John Drescher wrote: > 2012/1/11 Honia A : >> I'm backing up a handful number of Unix boxes, they all get backed up very >> quickly but we can't access them due to the BackupCatalog job being very >> slow. When I read online, I see people said it's because of the d

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread John Drescher
2012/1/11 Honia A : > I'm backing up a handful number of Unix boxes, they all get backed up very > quickly but we can't access them due to the BackupCatalog job being very > slow. When I read online, I see people said it's because of the database > size getting larger and larger. > > I cancel the b

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Honia A
I'm backing up a handful number of Unix boxes, they all get backed up very quickly but we can't access them due to the BackupCatalog job being very slow. When I read online, I see people said it's because of the database size getting larger and larger. I cancel the backup catalog job and all

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Steve Thompson
On Wed, 11 Jan 2012, Honia A wrote: > But when I checked the size of the database it's still really large: > > root@servername:/var/lib/bacula# ls -l > -rw--- 1 bacula bacula 208285783 2012-01-10 05:23 bacula.sql Depending on what you are backing up, that is not really all that big. Mine is

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Honia A
[CODE] root@servername:/etc/init.d# du -sh /var/lib/mysql/bacula/ 814M/var/lib/mysql/bacula/ [/CODE] I just reset MySQL root password but can't really see user bacula's db password in bacula-dir.conf as it appears to be encrypted. I just followed the instruction found here: http://www.ba

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Honia A
Hi Ben, I found bacula mysql password in bacula-dir.conf file but I think it's encrypted. So can't tell what the password is... Thanks for the instruction, I reset MySQL root password. Now, would you pelase let me know how I can retrieve bacula db password and also how to compact the size

Re: [Bacula-users] differential backups with xfs/x86-64?

2012-01-11 Thread Radosław Korzeniewski
2012/1/11 IEM - network operating center (IOhannes m zmoelnig) > alas. > btw, is there a way to "estimate" the next backup? > "estimate" seems to only estimate the fileset (that is: the "full" set) > Did you try a level option of estimate command? * estimate job="MyJob" level=Incremental It is

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 Thread Ben Walton
Excerpts from Honia A's message of Wed Jan 11 13:11:45 -0500 2012: > I have been handed this server by the previous IT guy and don't have > the info required to access the MySQL database. The mysql password for the account bacula uses should be available to you in the Catalog stanza of the bacula

[Bacula-users] Bacula database is getting too long

2012-01-11 Thread Honia A
Hi all, I have been using Bacula to backup several servers. Recently, the backupcatalog job takes so long to finish. I'm pretty sure it's related to the size of bacula.sql file. Code:ls root@servername:/var/lib/bacula# ls -l -rw--- 1 bacula bacula 208285783 2012-01-10 05:23 bacula.sqlI've

Re: [Bacula-users] differential backups with xfs/x86-64?

2012-01-11 Thread IEM - network operating center (IOhannes m zmoelnig)
On 2012-01-11 12:10, Martin Simmons wrote: >> On Wed, 11 Jan 2012 10:02:00 +0100, "IEM said: >> >> On 2012-01-10 14:19, Bruno Friedmann wrote: >>> >>> If the filesystem xfs is not mounted with the noatime option, check to have >>> noatime option in the bacula job. >>> so it will not change ea

Re: [Bacula-users] differential backups with xfs/x86-64?

2012-01-11 Thread Martin Simmons
> On Wed, 11 Jan 2012 10:02:00 +0100, "IEM said: > > On 2012-01-10 14:19, Bruno Friedmann wrote: > > > > If the filesystem xfs is not mounted with the noatime option, check to have > > noatime option in the bacula job. > > so it will not change each file during the full backup, then creating

Re: [Bacula-users] differential backups with xfs/x86-64?

2012-01-11 Thread IEM - network operating center (IOhannes m zmoelnig)
On 2012-01-10 14:19, Bruno Friedmann wrote: >> > > First of all, I'm using also xfs on data source and/or backup media. > There's no special trouble on them to get incremental/differential backup. thanks for your detailed answer. i'm glad to hear that no troubles are to be expected in general. so

Re: [Bacula-users] Encrypting Data on Tape

2012-01-11 Thread Jeremy Maes
Op 11/01/2012 7:38, Thomas Mueller schreef: > Am Tue, 10 Jan 2012 16:12:26 -0500 schrieb Craig Van Tassle: > >> I'm sorry if this has been asked before. >> >> I'm running a Scalar 50 with HP LTO-4 Drives. I want to encrypt the data >> that is put on the tape, We already have encryption going betwee