[mythtv-users] seeking upgrade advice 0.20 -> 0.23 backend database

[Michael T. Dean]

  On 01/04/2011 05:03 PM, Steven Adeff wrote:
> On Tue, Jan 4, 2011 at 4:11 PM, Ross Camm wrote:
>> I have been running on mythtv 0.20 for over 4 years and have not wanted to
>> upgrade ( its complicated )...until now
>>
>> I want to go from 0.20 to 0.23 as unbuntu 10.04 is on 0.23, which is on
>> all clients.
> Recommendation: use the Mythbuntu AutoBuilds repo and upgrade to 0.24.

Good recommendation.  http://www.mythbuntu.org/auto-builds

>> the reason for finally upgrading is moving  to HD on ASUS AT5IONT-I and it
>> needs VDPAU...not available in 0.20...so time to move forward.
>>
>> Backend questions are:
>>
>> 1. Can I upgrade straight from 0.20 to 0.23 using ? Will the database be
>> migrated in this case ? Do I need to run scripts or does an upgrade
>> magically happen upon backend startup ? Any known issues ?
> I believe the backend and frontend will upgrade the database as
> needed.

Yep.  Though, really, you should run mythtv-setup to upgrade the backend 
database since you need to verify settings after a MythTV version 
upgrade (and, in the case of 0.20 to 0.24 upgrade, you'll need to set up 
basic things like Storage Groups).

>   I would DEFINITELY backup your database before doing so though
> either way.
> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>
> I would also consider, if you don't have any important current
> recordings, to start from a fresh database. There are so many new
> settings, options, etc. that forcing yourself to go through all them
> in setting up your systems for the much newer version may be
> beneficial.

Or just let MythTV upgrade your database--like it's supposed to--and all 
your recordings, recording rules, and recording history, and then go 
through the mythtv-setup and mythfrontend settings pages to make sure 
they all look like what you want.  However, when changing your capture 
cards or capture card drivers (as would happen with a distro upgrade), 
you may need to clear and re-create your Input Connections 
configuration:  
http://www.gossamer-threads.com/lists/mythtv/users/264034#264034

>> 3. Finally, if I can't get 0.23 on lenny, how would I migrate the backend
>> to ubuntu 10.4 to then 'upgrade/install' using deb package management,
>> while still keeping the database intact ?
> see the page I linked. you would backup your database, copy to a (or
> multiple) secure locations, then when the new system is up and ready,
> restore the database.

Exactly.  Only gotcha being that if you decide to use a different host 
name (and I recommend you use the same host name), you must change the 
host name in the database ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend 
) before running any MythTV apps on that host.

Mike