[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