Krunoslav Pisacic skrev:
I can convert the data from the old dvb channel tables into the new tables so I dont have to set all my channels up again?You don't need to convert the data. All you need to do is run the setup program and scan for channels and it should find them all and
But migration from old dvb tables to new should be simple "insert into select [some fields] from dvb_channel, dvb_pids where ..." -
shouldn't it?
The database structure with regards to DVB has been completely changed (and it's now much more logical). This was needed to simplify things and to allow many of the new DVB features (channel scanning, autopid, guide data etc.) and will also hopefully make it possible in the future to record multiple programs simultaneously from the same transport.
The new structure is completely different and some info is missing in the "old" db so unfortunately there is no easy way to automatically migrate the data. It should however be possible to salvage some of the data with some manual work. You will probably need to work out the details yourself but I think something like this could work:
-create temporary table dvb_temp select chanid,channum,serviceid,icon... from channel join dvb_channel...
-truncate channels and repopulate the db with the scanner in setup
-update channels,dvb_temp set channels.channum=dvb_temp.channum... where channels.serviceid=dvb_temp.serviceid (this requires serviceid to be properly set in your old data, or that you have some other good "key" to use to map the data)
-update recordings,recordedmarkup (?) and maybe some more tables to use the new channel IDs.
Everyone's situation is different so it's probably hard to make something that will work for everyone but if you figure out a way to do it please share it with the list. And don't forget to backup your db before messing with this... :)
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
