[mythtv-users] failing upgrade from 0.21-fixes to 0.23-fixes using mysql 5.1 / Ubuntu 10.4

[Michael T. Dean]

On 06/22/2010 01:17 PM, Alain Brossard wrote:
>     I'm trying to upgrade an old release of Mythtv (schema 1214) 
> following a re-install to Ubuntu 10.04, I was running Ubuntu 8.04 
> unpatched mostly.
>
>    The automatic DB upgrade started by mythbackend is failing:
> |
> |
...
> |2010-06-22 18:45:23.151 Newest MythTV Schema Version : 1254
> 2010-06-22 18:45:23.398 *Database corruption detected. Unable to 
> proceed with database upgrade*. (Table: oldrecorded, Warnings: 2)
> 2010-06-22 18:45:23.398 Your database must be fixed before you can 
> upgrade beyond 0.21-fixes. Please see 
> http://www.mythtv.org*/wiki/Fixing_Corrupt_Database_Encoding* for 
> information on fixing your database.
> 2010-06-22 18:45:23.399 Database Schema upgrade FAILED, unlocking.
> |
...
>     Following the instructions in the Wiki doesn't resolve the issue.
> The output of the "status;" command returns a different result than 
> contained in the wiki

You definitely don't have "equal corruption", so it's probably just 
individual records that are corrupt.  The fasted and easiest way to tell 
you how to fix it is for you to provide (off list--send directly to me) 
a link to your (ideally the 1214) database backup (from before the first 
upgrade attempt).

Mike