On Sat, 18 Nov 2006 11:47:53 +0100 Frank Mueller <[EMAIL PROTECTED]> wrote:
> Hi there, > > memory usage is at 60MB out of 1GB. No swapping at all. > > By the way. Shouldn't it be possible to edit the database to delete some > File entries to make things work? > I already took a look at the db with phpmyadmin, but I do not get the db > structure, coz I do not know much about mysql and bacula. > I know that there's a very huge directory in that contains over 2 Mio > SPAM-Mails and I think completely deleteing that directory might be the > solution for my prob. > Can anyone lead me to the correct entries to delete from the db? Absolutely do a dump of the database before you try anything! However, you may be on to something. Long term you really need to find the performance problem and get it fixed, but you may be able to speed things up some short term. Bacula keeps the pathnames and filenames in seperate tables from the records of what files were backed up. The following procedure should allow you to clean up the excess files: 1) SELECT pathid FROM path WHERE path='/path/to/files/you/want/to/delete' 2) DELETE FROM file WHERE pathid=<the result from step 1> I take no responsibility if this deletes more than you want. Take a dump of the database before you try this. Restore the dump when you're done. The table structure is documented: http://bacula.org/developers/Catalog_Services.html#SECTION000101600000000000000 Good luck. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
