Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread Ferdinando Pasqualetti
Ciao Fabrizio, I'll answer in English, to be understood by the list. There are no direct indexes pointing to files from Jobs or Volumes, so deletion of them at each pruning would be very expensive in terms of resources. Anyway you can delete unuseful items using dbcheck. I have in a daily crontab

Re: Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread .:faber:.
Thanks Ferdinando and Rudolf for your answers. On Mon, 2006-05-22 at 10:28 +0200, Ferdinando Pasqualetti wrote: There are no direct indexes pointing to files from Jobs or Volumes, so deletion of them at each pruning would be very expensive in terms of resources. That's just what I used to

Re: Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread Rudolf Cejka
Ferdinando Pasqualetti wrote (2006/05/22): ... I could not read and reply to html mails well, but if you have MySQL and MyISAM, you do not need to drop the tables - it is sufficient to perform optimize table File; and all other tables (File, Path, Filename, ...) you want to shrink. Hopefully