On Friday 16 September 2005 16:31, Alan Brown wrote: > On Fri, 16 Sep 2005, Kern Sibbald wrote: > > Are you running on 1.36.3? If so, this is strange since the default > > table setup for 1.36.3 includes an index on JobId in the File table. > > But not on upgrades from previous versions, right?
On most upgrades, the index should not be lost, because generally an upgrade adds new columns or new tables. Now, if an index is lost during a modification of a table to add a new column, there would be a big problem that I was not aware of -- at least in something like 10 upgrades of my production system on MySQL, I have never lost an index. -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users