[mythtv-users] [mythtv] Recovering recording meta data from 0.18 DB dump?

[Michael T. Dean]

On 07/20/2006 09:45 AM, Michael T. Dean wrote:

>The automatic upgrade works, but /only/ from a "complete" database 
>restore (i.e. like http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 
>).  If you want to do a partial restore (as 
>http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 ), the easiest 
>solution is to:
>
>    a) do a complete restore (you'll have to drop the existing database 
>that Myth couldn't upgrade, first)
>    b) run mythtv-setup (to upgrade) and exit mythtv-setup without 
>making changes
>  
>
b.5) backup the new upgraded database ( 
http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 )

>    c) drop the database
>    d) run mc.sql (to create the database)
>    e) start mythtv-setup (to create the up-to-date database schema) and 
>exit mythtv-setup without making changes
>    f) do a partial restore ( 
>http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 )
>  
>
of the upgraded database backup

>    g) run mythtv-setup to fix settings
>    h) run mythbackend
>    i) run mythfrontend
>  
>

D'oh.  I forgot to explicitly say to do a backup of the upgraded 
database and to use the new database backup for the partial restore.  
Sorry if you end up doing the whole process an extra time because of this...

Mike