[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