[mythtv-users] Migrating database from 0.18 to 0.19 (SQL hacking?)

[Cory Papenfuss]

On Wed, 3 May 2006, Cory Papenfuss wrote:

>> You could still start with the vanilla FC box and atprms. Instead of using
>> the base mc.sql file, just restore your .18-1 mythconverg database dump to
>> mysql and then run mythtv-setup/mythbackend(can never remember which) and it
>> will update the database to .19.
>
> 	Ah-ha.... that might work.  Then I can re-export the updated
> record, recorded, oldrecorded, and recordedmarkup from the 0.19-ified db,
> flush the DB and reimport.
>
> brb... :)
>
 	Hrm... close.  After importing the 0.18 DB into a 0.19 system and 
trying to run mythtvsetup, I get the following:

$ mythtvsetup
2006-05-03 17:44:46.210 Using runtime prefix = /usr
2006-05-03 17:44:46.246 New DB connection, total: 1
2006-05-03 17:44:46.258 Connected to database 'mythconverg' at host: 
localhost
2006-05-03 17:44:46.261 Total desktop dim: 3200x1200, with 2 screen[s].
2006-05-03 17:44:46.278 Using screen 0, 1600x1200 at 0,0
2006-05-03 17:44:46.290 Current Schema Version:
2006-05-03 17:44:46.291 Newest Schema Version : 1124
2006-05-03 17:44:46.293 New DB connection, total: 2
2006-05-03 17:44:46.294 Connected to database 'mythconverg' at host: localhost
2006-05-03 17:44:46.295 Setting Lock for Database Schema upgrade. If you 
see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2006-05-03 17:44:46.297 New DB connection, total: 3
2006-05-03 17:44:46.298 Connected to database 'mythconverg' at host: 
localhost
2006-05-03 17:44:46.301 Told to create a NEW database schema, but the databasealready has 70 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2006-05-03 17:44:46.302 Database Schema upgrade FAILED, unlocking.
2006-05-03 17:44:46.361 Total desktop dim: 3200x1200, with 2 screen[s].

 	Seems like he doesn't want to update himself.  Any thoughts?

-Cory

  > 
--
>
> *************************************************************************
> * Cory Papenfuss, Ph.D., PPSEL-IA                                       *
> * Electrical Engineering                                                *
> * Virginia Polytechnic Institute and State University                   *
> *************************************************************************
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

-- 

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