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

wdormann at gmail.com wdormann at gmail.com
Sat Jan 1 00:08:09 UTC 2011


This is the exact situation that I'm in!  Is there any way you could post instructions on how the database can be fixed?  I'm sure others are in the same situation...

Thanks
-WD

-----Original Message-----
From: "Michael T. Dean" <mtdean at thirdcontact.com>
Sender: mythtv-users-bounces at mythtv.org
Date: Fri, 31 Dec 2010 19:05:35 
To: Discussion about MythTV<mythtv-users at mythtv.org>
Reply-To: Discussion about MythTV <mythtv-users at mythtv.org>
Subject: Re: [mythtv-users] Failing database upgrade from mythtv 0.20 to 0.23

  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
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


More information about the mythtv-users mailing list