>>>>> 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
