[mythtv-users] Total system upgrade: Am I screwed?

[Richard Shaw]

On Sun, Nov 29, 2009 at 8:48 AM, Bob Wiegand <bob_ml at stuffofmine.com> wrote:
> Richard Shaw wrote:
>>
>> Well I thought I had done the right thing but apparently not.
>>
>> I had a Fedora 10 system with Myth 0.21 and I decided to take the
>> plunge and upgrade the system to Fedora 12 and Myth to 0.22 all at
>> once.
>>
>> I backed up the database per the wiki and copied all important data on
>> my desktop so I could wipe the system for a fresh install. The F12
>> install went smoothly and I installed Myth. Per the wiki I was
>> supposed to import the mc.sql file prior to restoring the database,
>> which I did. However, when I ran the restore script it bombed out.
>>
>> Bottom line: Is there any way to save any of my database info? The
>> only things I care about are the recordings which I still have all of
>> on a separate drive and my recording schedules.
>>
>> Thanks,
>> Richard
>
> Big warning - I'm not I database expert and I haven't done this myself.
>
> The problem is probably that the backup data is not compatible with the
> the latest database version. When you installed myth it created a
> new database.
>
> A Myth database expert might know how to fix the backup files, but
> I don't.
>
> It might be possible to make this work by doing the following:
> 1 - uninstall Myth
> 2 - remove the myth database if it still exists
> 3 - manually create the myth database from your backup
> 4 - reinstall myth
>
> I believe that the myth install is supposed to upgrade an existing
> database if it finds one.
>
> Bob

I thought about that but I couldn't find any info specifically
covering a complete system upgrade so I figured the backup/restore
should work. Maybe I should have upgraded Myth on the existing system
first but that seemed too much as I was going to wipe the drive as
soon as it was done...

Richard

Richard