[mythtv] mysql 5 bug affecting mythtv
Michael T. Dean
mtdean at thirdcontact.com
Sun Jan 27 05:34:44 UTC 2008
On 01/26/2008 08:55 PM, Rob Smith wrote:
> On Jan 26, 2008 4:47 PM, David Backeberg <dbackeberg at gmail.com> wrote:
>> has anybody else run into this problem?
> From the depths of my memory, I seem to recall an issue with the
> upgrade from 4 to 5 where the index definition can get corrupted and
> the only way to fix it is to remove the indexes and recreate them.
> That said, this might not help at all, but it's the first thing I'd
> recommend trying.
OP, did you upgrade MySQL using
approach) or by just copying (leaving?) the binary database files into
place? I've seen binary-file-upgrades corrupt the DB (possibly index or
If you don't have a way to go back to upgrade with a backup, I recommend
using http://mythtv.org/docs/mythtv-HOWTO.html#toc23.7 to clean up your DB.
More information about the mythtv-dev