[mythtv-users] Fresh install, struggling to change imported db schema

[Michael T. Dean]

On 05/27/2012 07:32 AM, Michael T. Dean wrote:
> On 05/27/2012 05:42 AM, Damian wrote:
>> Hello all,
>>
>> Here's my story :-)
>>
>> I've had MythTV running on Ubuntu (via the addition of Mythbuntu) for 
>> a few years. It's been fine for most of that time.
>>
>> Upgrading to 0.25 broke things (it did a 'partial upgrade') and 
>> upgrading to Ubuntu 12.04 didn't fix them.
>>
>> I then formatted the file system and home partitions and installed a 
>> pure Mythbuntu system. However, I came across the same problem I am 
>> about to describe below, and also wasn't keen on a couple of things 
>> about XFCE. So, yesterday I installed a fresh Ubuntu 12.04 system.
>>
>> I have added the Mythbuntu packages and managed to import my old 
>> database.
>>
>> The problem I'm having is when I click to launch the backend set up, 
>> I'm told:
>>
>> "MythTV wants to upgrade your database for the TV schema, from 1276 
>> to 1299".
>>
>> I click the relevant buttons to allow this, but it doesn't seem to 
>> work, as the next time I click on the back end set up it tells me the 
>> same thing.
>>
>> If it helps at all, I'm also seeing this message inside pypmyadmin:
>>
>> "connection for controluser as defined in your configuration failed".
>>
>> Any tips?
>
> Need backend log files showing the failed upgrade.
>
> However, I recommend using mythtv-setup to upgrade the database, 
> instead of mythtv-setup.
>
> That said, the failure at, specifically, 1277 is almost definitely:
>
> http://www.gossamer-threads.com/lists/mythtv/users/517981#517981
>
> which means you need to go back to the pre-upgrade database backup 
> (the 1264 schema version backup) and restore it properly.  If you 
> don't have the 1264 database backup, there will be /much/ more work 
> involved in fixing things properly.

Guess I should have linked the more-detailed instructions for how to 
proceed after a failed DB schema upgrade (from slightly earlier in the 
same thread):

http://www.gossamer-threads.com/lists/mythtv/users/517959#517959

Mike