[mythtv-users] Database Upgrade Questions

makalu at ansae.com makalu at ansae.com
Mon Aug 27 11:47:16 UTC 2007

I'd like to clarify a couple points about preserving my mythtv db while 
upgrading from 0.18. 

First, I assume that I do not want to follow the instructions for setting up 
the initial db, particularly running the script mc.sql, because that would 
blow away my existing data. Yes? 

Second, I see from the UPGRADE readme that mythtv will upgrade old schemas 
automatically (at least from 0.10 or 0.11). When does this happen? During 
the "make install" or during mythfilldatabase? I.e., do I want to run 
mythfilldatabase after I do make install? 

Separately, I have a question about moving my old data to a fresh db. I 
think I'm going to just upgrade mythtv while leaving my system as-is even 
though it's old (FC3). However, if I did want to build a new system, I'm not 
sure how to properly migrate the data from my version 0.18 database. 
Specifically, if I start by making a sql dump of my old database, then built 
a new system and created a new database with the latest mc.sql script from 
the 0.20 tarball, wouldn't that create a version of the db schema that might 
not be compatible with the dump I made of the 0.18 db? Instead, should I go 
to svn to get the version of the mc.sql script for the 0.18 release to 
create an initial db compatible with my sql dump? Then the mythtv install 
could upgrade it to the 0.20 schema. 

More information about the mythtv-users mailing list