Re: [Bacula-users] Bacula + MySQL File Table Corruption Issue

2005-04-22 Thread John Donagher
On Fri, 2005-04-22 at 09:03 -0400, Michael Joyner wrote: > I ran into the "duplicate key" problem. > I fixed it by doing the following: > > updgrade MySQL past the buggy version. > > for each _TABLE_; do: > alter table _TABLE_ engine=InnoDB; > alter table _TABLE_ engine=MyIsam; > done >

Re: [Bacula-users] Bacula + MySQL File Table Corruption Issue

2005-04-22 Thread Michael Joyner
I ran into the "duplicate key" problem. I fixed it by doing the following: updgrade MySQL past the buggy version. for each _TABLE_; do: alter table _TABLE_ engine=InnoDB; alter table _TABLE_ engine=MyIsam; done Not forcing MySQL to do a *TOTAL* rewrite of the tables seems to leave something