Martin Simmons wrote: >>>>>> On Tue, 06 Jun 2006 13:22:56 +0800, "[EMAIL PROTECTED]" <[EMAIL >>>>>> PROTECTED]> said: >>>>>> >> Hi, >> >> I was wondering how you remove database entires for clients that are no >> longer being used. Currently I simply remove them from bacula-dir.conf >> but I suspect the database entries still exist. >> >> I'm getting a really bloated mysql bacula directory (currently nearly >> 1GB with 37 clients; used to be 42...) even after compacting. >> >> Any recommendations? >> >> Which tables can I drop in the database pertaining to the old clients as >> I'm looking to trim that database. >> > > Don't drop any tables -- they are all needed! > > You can use the "query" command option "List all backups for a Client" to find > the jobids for jobs on the old clients and the use the "delete job" command to > remove the information for each one. > I ran dbchek (set to modify) but that did not reduce the size of the database. I'll try your suggestions. Thanks! > __Martin > >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users