[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