[mythtv-users] Failing database upgrade from mythtv 0.20 to 0.23

[Michael T. Dean]

  On 12/31/2010 02:43 AM, Jeffrey Yeo wrote:
> I've finally decided to upgrade my mythtv box after many years of being an
> ignored appliance.
>
>
> I am upgrading from MythTV 0.20 running on Gentoo to Mythbuntu 10.10 (MythTV
> 0.23).  I downloaded mythconverg_backup.pl and used it to backup my old
> database.  When I attempted to restore the data, I appear to have run into the
> partial corruption problem.  If I read the mythconverg_backup file names
> correctly, my old schema was 1160 (!!).
>
>
> I have found and followed a number of upgrade instructions:
> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
> http://www.gossamer-threads.com/lists/mythtv/users/406111#406111
>
> But now seem to be stuck at "Data base corruption detected. Unable to proceed
> with database upgrade. (Table: oldrecorded, Warnings 41)".   As one of the posts
> stated, with data for over 3000 recorded shows I would rather not start again.
>
>
> Is there any way to recover the data?

If you'd like to send me a link (I highly recommend you send the link 
off-list) to a copy of your pre-upgrade (0.20) database backup, I'll 
likely be able to get it fixed for you.  Best case-scenario, I can 
provide you with a list of SQL commands to salvage your 0.20 backup.  As 
a last resort, I can modify current MythTV to stop the upgrade at 
0.21-fixes and exit, then make a backup so you can use the "blank" 0.21 
database to do a partial restore.

Unfortunately, due to visitors and plans, this evening, I won't be able 
to get to it until tomorrow, but I'd be happy to do it for you as soon 
as I get a chance.

To do it, though, I really need the pre-upgrade database backup.

Mike