[mythtv-users] Failing database upgrade from mythtv 0.20 to 0.23
Michael T. Dean
mtdean at thirdcontact.com
Sat Jan 1 00:05:35 UTC 2011
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:
> 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.
More information about the mythtv-users