[mythtv-users] import an old sql DB into the new format on exisiting 0.19 install
Raphael Pooser
rpooser at gmail.com
Sun Feb 19 05:38:30 UTC 2006
Tom Lichti wrote:
> Raphael Pooser wrote:
>
> Well, what you could do is look at what the DB schema version is on the
> old database (select * from settings where value = 'DBSchemaVer') and
> compare that to the latest version (mine is 1124) and then look in the
> source file mythtv/libs/libmythtv/dbcheck.cpp and go to the function
> doUpgradeTVDatabaseSchema and find the first version that is newer than
> what you have, and then run all the commands manually until you are up
> to the latest version. Tedious. The other thing you could do, since you
> don't have any data in the db yet (I assume) is make the .19 setup point
> at the old DB, and it should upgrade it to the current schema. Don't do
> this on your only copy, and I make no guarantees as to the accuracy of
> this advice. :)
>
>> Or perhaps I should uninstall myth, drop the mythconverg db, restore my backup db
>> into sql and then reinstall 0.19...? Then when I reinstall mythtv it
>> should find my old mythconverg db already existing an upgrade it to the
>> new format. If that's the best route to I'll do that.
>>
> Sort of what I said above, and should work, except you don't have to
> uninstall/reinstall in my version.
>
> Tom
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
Got it, will try that; thanks.
Raphael
More information about the mythtv-users
mailing list