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 > > Not forcing MySQL to do a *TOTAL* rewrite of the tables seems to leave > something *WRONG* in it from the buggy version. Running the alter table > engine stuff forces total table rebuild from scratch vs just a repair > which doesn't do that. >
Thanks Michael - I'm giving that a try John ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
