[mythtv-users] SD programid too long?

Cory Papenfuss papenfuss at juneau.me.vt.edu
Wed Sep 26 02:13:27 UTC 2007

On Tue, 25 Sep 2007, Anduin Withers wrote:

>>  	My update procedure was to
>> - Initialize new database
> The setting is MythFillFixProgramIDsHasRunOnce it was set to 1 when you
> "Initialize[ed] new database" (part of updating the schema). The automatic
> conversion happened then, the data you imported was in the old form and was
> imported after the automatic update happened.
> You can delete that setting or set it to 0 and the conversion will happen
> again.
> An upgrade should involve a DB backup, but starting with a new DB and
> importing old data is asking for more manual work.
 	So, this procedure:

 	wasn't quite right?  The "restore.sql" wasn't a complete database 
snippet, so the skeleton (mc.sql) had to be imported first.

 	What would be the appropriate method to force a schema upgrade to 
my existing database then?


* Cory Papenfuss, Ph.D., PPSEL-IA                                       *
* Electrical Engineering                                                *
* Virginia Polytechnic Institute and State University                   *

More information about the mythtv-users mailing list