From: Kern S. <ke...@si...> - 2003-08-16 12:59:40
|
Hello, On Sat, 2003-08-16 at 13:58, Jari Fredriksson wrote: > >Hello, > > > >At the current time, Bacula does not remove Path or File > >entries that are orphaned. This is because they are > >put in the database one time only and will be used > >by any backup that references them. The amount of > >extra space they consume is really pretty small, and > >in most installations, there will not be a huge number > >of orphaned path or files. To orphan them, you must > >first do a backup, then delete a directory and all > >unique filenames. > > > >I figured it was more efficient to use dbcheck rather > >than having each backup spend hours trying to delete > >orphaned entries. > > > >Best regards, > > > >Kern >=20 > Ok, it's nothing to worry then. >=20 > That kind of deletion actually is (or can be) the task of the database. >=20 > I'll check my "own" version of it, and prepare needed CASCADE DELETE > instructions if it's doable in InnoDB (should be I think). Basic MySQL do= es > not support those, although. When you are 100% happy with your Innodb database, could you send me a copy. It might be something to include with Bacula. On doing CASCADE DELETE, OK, please realize that in general, there are multiple File records that point to each Path and Filename record. To know that one is orphaned, you must search all the File records, and there are a lot of them. Best regards, Kern >=20 >=20 >=20 >=20 >=20 > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/= 01 > _______________________________________________ > Bacula-devel mailing list > Bac...@li... > https://lists.sourceforge.net/lists/listinfo/bacula-devel |