[mythtv-users] Migration question: 0.20 trunk to 0.20.2 release

[Jerry Rubinow]

On 8/31/07, John Drescher <drescherjm at gmail.com> wrote:
> On 8/31/07, Jerry Rubinow <jerrymr at gmail.com> wrote:
> > This weekend I'll be migrating my system to 0.20.2.  My current system
> > is a combined FE/BE running 0.20 SVN trunk code from January.  I want
> > to switch to a system with FE and BE on separate computers running
> > 0.20.2.  And I want to migrate my recordings to the new backend.
> >
> > Will following section 23.7 of the documentation (Moving your data to
> > new hardware) work in this case?  Given that there are likely DB
> > changes between these two versions, I'm guessing Myth would be
> > confused if I inserted some records from my old DB into the new one
> > and some of the fields were different.
> >
> > If it won't work, any suggestions for the best way to migrate my
> > recordings?  I probably have on the order of 20 to 30 shows.
> >
>
> How about dumping the database with mysql dump. Then restoring it on
> the new master backend machine. Use the backup and restore proceedure.
> Then after the database is restored on master backend install the new
> version of myth and it will automatically upgrade the tables.
>
> John

That's the procedure I was envisioning, but I wasn't sure whether a
non-trunk current version would upgrade the older trunk version tables
correctly.

-Jerry