Re: [Bacula-users] Removing old clients from the database
Martin Simmons writes: > 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. Can also use the 'prune' command or the purge command. In particular the 'purge' command will delete the records regardless of their retention.. Just make absolutely sure you are purging the old clients. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Removing old clients from the database
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
Re: [Bacula-users] Removing old clients from the database
> 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. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Removing old clients from the database
On Tue, 06 Jun 2006 13:22:56 +0800 "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > 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? Try running dbcheck. Worked for me. -- Bill Moran Collaborative Fusion Inc. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Removing old clients from the database
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. ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users