[mythtv-users] Importing recordings from 18.x into 20.x, lessons learned
Ackster
ackster at gmail.com
Wed Oct 18 15:56:05 UTC 2006
Michael T. Dean wrote:
> You can't do a "partial restore" (
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 ) of a 0.18 database
> into a 0.20 database schema. You can either:
>
> a) upgrade the 0.18 database in place, then export, then drop the
> database, then create a new 0.20 database, then do a "partial restore"
> of the 0.20 export into the 0.20 database
>
> or
>
> b) export the 0.18 database, drop the 0.18 database, create a new
> 0.18 database, do a "partial restore" of the 0.18 database into the 0.18
> database, then upgrade the new 0.18 database in place.
>
> progstart is not the only data you're missing. The basename is one much
> more important one... There are probably others.
>
> I recommend you drop your current database, use the /entire/ export of
> the 0.18 database to re-create the 0.18 database (
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 ), start and exit
> mythtv-setup (to upgrade the 0.18 database in place), and continue with
> the steps in a above. Any new recordings (from between the time you
> exported the 0.18 database and when you fix the broken database) can be
> imported with myth.rebuilddatabase.pl.
>
> Mike
>
Thanks for the followup Mike, but I'm no longer having any problems. My
base name is set fine it seems.
But for reference, here's what my partial restore did put :
(`chanid`, `starttime`, `endtime`, `title`, `subtitle`, `description`,
`category`, `hostname`, `bookmark`, `editing`, `cutlist`, `autoexpire`,
`commflagged`, `recgroup`, `recordid`, `seriesid`, `programid`,
`lastmodified`, `filesize`, `stars`, `previouslyshown`,
`originalairdate`, `preserve`, `findid`, `deletepending`, `transcoder`)
My guess is that Myth is somewhere rebuilding the basename on it's own,
regardless of having to do a db upgrade.
The only fields I have missing by default are :
| timestretch | float | | | 1
| |
| recpriority | int(11) | | | 0
| |
| basename | varchar(128) | | |
| |
| progstart | datetime | | | 0000-00-00 00:00:00
| |
| progend | datetime | | | 0000-00-00 00:00:00
| |
| playgroup | varchar(32) | | | Default
| |
| profile | varchar(32) | | |
| |
| duplicate | tinyint(1) | | | 0
| |
| transcoded | tinyint(1) | | | 0
| |
| watched | tinyint(4) | | | 0
| |
Three of those are now set correctly, and the rest don't seem to be
showstoppers.
Anything else you can think of that might end up being a problem?
-Ackster
More information about the mythtv-users
mailing list