[mythtv-users] SD programid too long?

[Cory Papenfuss]

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:
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7

 	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
-- 

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