[Bacula-users] List all files from date

2011-01-27 Thread Tom Sommer
date) - Or.. Is it possible to simply restore all *.ini files on a client (research says no, hence the above question) Thanks a ton :) // Tom Sommer -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On 04-01-2011 15:11, Dan Langille wrote: > On Tue, January 4, 2011 7:55 am, Tom Sommer wrote: >> On Tue, January 4, 2011 12:59, Dan Langille wrote: >>> On 1/4/2011 5:00 AM, Tom Sommer wrote: >>> >>>> On Tue, January 4, 2011 03:15, Dan Langille wrote: >

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 13:55, Tom Sommer wrote: > On Tue, January 4, 2011 12:59, Dan Langille wrote: > >> On 1/4/2011 5:00 AM, Tom Sommer wrote: >> >> >>> On Tue, January 4, 2011 03:15, Dan Langille wrote: >>> >>> >>>> On 1/3/2011

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 12:59, Dan Langille wrote: > On 1/4/2011 5:00 AM, Tom Sommer wrote: > >> On Tue, January 4, 2011 03:15, Dan Langille wrote: >> >>> On 1/3/2011 12:57 PM, Tom Sommer wrote: >>> >>> >>>> I'

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 03:15, Dan Langille wrote: > On 1/3/2011 12:57 PM, Tom Sommer wrote: > >> I'm currently restoring 1.5 mill. files and it's taking forever. >> >> >> bacula-sd is using 100% CPU, disk IO is apparently low, so I assume >> it'

[Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-03 Thread Tom Sommer
COMMAND 4014 root 18 0 109m 19m 1264 S 100.3 0.1 135:07.23 bacula-sd As you can see the process takes 100% CPU usage, on 1 core. Is there any way to make Bacula use all cores? or any other way to speed up the restore - By the looks of it, it could take days to restore the data.

Re: [Bacula-users] How to correctly delete a client

2009-06-29 Thread Tom Sommer
Bruno Friedmann wrote: > Tom Sommer wrote: > >> I've recently deleted some clients from my directory configuration. >> >> However when I look in the Client table in MySQL, the clients are still >> there. >> I suspect the jobs and files won't be p

[Bacula-users] How to correctly delete a client

2009-06-29 Thread Tom Sommer
e these records, and I don't want stale data or clients on my volumes. So what is the correct procedure to wipe client records from Bacula? Thanks -- Tom Sommer -- ___

Re: [Bacula-users] [Bacula-devel] Fwd: Re: Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-26 Thread Tom Sommer
Tom Sommer wrote: > Okay, I added 12GB more RAM. Made my mysql tmp directory a tmpfs. Stole > some settings from Jason's my.cnf. Upgraded to latest MySQL version. > This seem to have done the trick. My FULL backup only took 7 hours today, and completed without problems. Sad

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Tom Sommer wrote: > Mike Holden wrote: > >> Jari Fredriksson wrote: >> >> >>>> INSERT INTO Filename( Name ) >>>> SELECT a.Name >>>> FROM ( >>>> >>>> SELECT DISTINCT Name >>>> FROM batch &

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Mike Holden wrote: > Jari Fredriksson wrote: > >>> INSERT INTO Filename( Name ) >>> SELECT a.Name >>> FROM ( >>> >>> SELECT DISTINCT Name >>> FROM batch >>> ) AS a >>> WHERE NOT >>> EXISTS ( >>> >>> SELECT Name >>> FROM Filename AS f >>> WHERE f.Name = a.Name >>> ) >>> >>> >> That looks s

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Martin Simmons wrote: >>>>>> On Thu, 18 Jun 2009 17:11:04 +0200, Michel Meyers said: >>>>>> >> Martin Simmons wrote: >> >>>>>>>> On Wed, 17 Jun 2009 13:48:58 +0200, Tom Sommer said: >>>>>>&

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Jari Fredriksson wrote: >> INSERT INTO Filename( Name ) >> SELECT a.Name >> FROM ( >> >> SELECT DISTINCT Name >> FROM batch >> ) AS a >> WHERE NOT >> EXISTS ( >> >> SELECT Name >> FROM Filename AS f >> WHERE f.Name = a.Name >> ) >> >> > > That looks silly. > > I would write it shorter as > > I

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-17 Thread Tom Sommer
Martin Simmons wrote: >>>>>> On Tue, 16 Jun 2009 15:05:18 +0200, Tom Sommer said: >>>>>> >> Hi, >> >> I have a somewhat pressing problem with the performance of my Bacula >> installation. >> >> My MySQL datab

[Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-16 Thread Tom Sommer
Hi, I have a somewhat pressing problem with the performance of my Bacula installation. My MySQL database currently holds 247,342,127 (36GB) records in the File table, and 78,576,199 (10GB) records in the Filename table. Since 3.0.0, but even more since 3.0.1, I have a problem with queries being

Re: [Bacula-users] Very selective backup set

2009-02-18 Thread Tom Sommer
Allan Black wrote: > Tom Sommer wrote: > >> Takes backup of all files in /usr/local/example/, and of all *.xml files >> in /example01/, /example02/ and /example03/ - recursively (the .xml >> files are in random subfolders within the example folders, along with a >&

[Bacula-users] Very selective backup set

2009-02-11 Thread Tom Sommer
other files which I don't want to backup). I've tried messing with exclude parameters and what not, but I can't seem to get the Backup Set I want. Anyone got a nice clean solution to this? Thanks a ton -- Tom Sommer -

Re: [Bacula-users] performance

2007-09-07 Thread Tom Sommer
in bconsole, "m" is an alias for the "memory" command now -- confusing, yes. -- Tom Sommer - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Searc

Re: [Bacula-users] restore problem

2007-09-06 Thread Tom Sommer
e the hardware for days with no apparent problems. > > I have deleted all the backups, reinitialized bacula from scratch, run > full backups to different disk volumes, and tried a restore again: same > result. > > I'd be thankful for any clue stick that

Re: [Bacula-users] Optimal setup for large data

2007-08-30 Thread Tom Sommer
would have to be purged right after the new one is taken. > For this to work, you need a reasonable estimate of the actual amount > of data that will need to be stored; after some cycles of prging / reusing, > you can fine-tune your settings. Interesting, and a critical

[Bacula-users] Volume data error

2007-08-28 Thread Tom Sommer
8-28_11.08.47 Error: Bacula nixbackup-dir 2.2.0 (08Aug07): 28-Aug-2007 11:08:49 Is this a generic file corruption, if so, is there any way to fix it or detect it in the future? It kind of got me worried about my remaining backups. I am running Bacula 2.2.0 -- Tom Sommer --

[Bacula-users] Optimal setup for large data

2007-08-27 Thread Tom Sommer
is in progress, bug?). Lots of text, hope someone will share their advice. Thanks a lot. -- Tom Sommer - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log even