[mythtv-users] How to migrate from 0.22 to 0.24?

Greg greg12866 at nycap.rr.com
Sun Jul 17 12:39:32 UTC 2011


On 07/17/2011 12:00 AM, Idan Shoham wrote:
> Hello!
>
> I'm trying to migrate an older mythtv server to a new system.
> Copying over the recordings and configuring the new system are
> no problem.
>
> I've run into an issue with minor changes in the schema between
> versions.
>
> Does anyone have any guidance on how to migrate the contents of mysql
> between versions?
>
> Old system:
> mythbackend --version
>    Please include all output in bug reports.
>    MythTV Version   : 22594
>    MythTV Branch    : branches/release-0-22-fixes
>    Network Protocol : 50
>    Library API      : 0.22.20091023-1
>    QT Version       : 4.5.2
>    (Ubuntu 9.10)
>
> New system:
>    mythbackend --version
>    Please attach all output as a file in bug reports.
>    MythTV Version   : v0.24-243-g9ba3ece
>    MythTV Branch    : fixes/0.24
>    Network Protocol : 63
>    Library API      : 0.24.20101129-1
>    QT Version       : 4.7.2
>    (Ubuntu 11.04)
>
> I searched the archives and elsewhere but didn't find any description of how to do this sort of cross-version migration.
>
> BTW - I've tried the following commands, which is how I know the schema has changed:
>
>    On old server:
>    mysqldump -u mythtv -p -t mythconverg record recorded \
>      oldrecorded recordedprogram recordedrating \
>      recordedmarkup recordedseek>  recordings.sql
>
>    On new server:
>    mysql -u mythtv -p mythconverg<  recordings.sql
>
> (obviously with appropriate passwords and after transferring files around)
>
> Any help would be appreciated.  :-)
>
> -- Idan
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
I assume you have a copy of your old database.. If so use this 
script...http://www.mythtv.org/wiki/Database_Backup_and_Restore

Make sure you do a full restore and not a partial..

After you restore the D/B allow the schema to update it's self....


More information about the mythtv-users mailing list