[mythtv-users] DB charset pre-conversion test failed! Your database seems to be partially corrupted.

[Tom Dexter]

On Mon, Nov 9, 2009 at 11:11 AM, Brian J. Murrell <brian at interlinx.bc.ca> wrote:
> On Mon, 2009-11-09 at 10:04 -0500, Tom Dexter wrote:
>>
>> If the problem is in fact from missing tables, that's a serious issue.
>
> Indeed.
>
>> I can't imagine the schema upgrade handling such a thing gracefully.
>
> If this is the case, it would be nice if the upgrade process mentioned
> missing tables and not sending the user on a wild goose chance about
> corrupted databases and character sets and so on.
>

If we're talking about tables that just happen to be missing from a
database crash or whatever, what kind of warning could they give ahead
of time?  "If your database is hosed the upgrade won't work"?  I'm not
sure what you expect there.

I'm not sure what "wild goose chase" you're referring to.  That
database corruption issue due to connection default character sets is
far from a wild goose chase.  It's something that affects all Gentoo
users like myself for one thing.

>> It looks to me like the 1214->1215 upgrade is doing an alter table to
>> like 44 tables.
>
> Hrm.  I have something like 92.
>

I didn't mean the total number of tables...I meant the number of those
tables that are actually being altered during the 1214->1215 upgrade.

>> If more than a tiny handful of people had this happen, I'd be curious
>> as to what caused it in the first place.
>
> I saw some indication, I don't remember where, about having MythVideo
> installed without MythDVD or vice-versa.
>

MythDVD has been gone for some time now hasn't it?

>> If you want to try and determine what might be missing you can do:
>>
>> mysql -umythtv -p mythconverg -e 'show tables' > list_of_tables.txt
>>
>> ...and I can compare it to my 1214 database.
>
> Attached, thanx!
>
> b.
>

I'll compare it to mine when I get home.