[mythtv-users] 0.20 schema upgrade failed

Peter Bienstman Peter.Bienstman at ugent.be
Sun Oct 8 19:14:41 UTC 2006

I tinkered around with editing and restoring sql files, but without a lot of 

I've resigned myself to the fact that I'd better start with a fresh 


On Sunday 08 October 2006 19:36, Michael T. Dean wrote:
> On 10/08/06 01:57, Peter Bienstman wrote:
> >On Saturday 07 October 2006 22:59, Michael T. Dean wrote:
> >>On 10/07/06 16:23, Peter Bienstman wrote:
> >>>I upgraded from 0.19 to 0.20 (Actually the Gentoo 0.20_p11444 version),
> >>>but when I start mythfrontend, I get this:
> >>
> >>...
> >>
> >>>Database error was:
> >>>Table 'mythconverg.recordedprogram' doesn't exist
> >>
> >>Let me guess.  You did a partial restore of the database (
> >>http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 ) after the upgrade
> >>rather than a full restore (
> >>http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 )?
> >>
> >>If that's not the case, you may have exported a corrupt database whose
> >>recordedprogram table couldn't be opened (and, therefore, wasn't
> >>exported).  Fortunately, recordedprogram isn't critical data (it's
> >>automatically regenerated).
> >>
> >>After a bit more information on what constitutes "the upgrade," I can
> >>give you more info on possible approaches for getting a working database.
> >
> >I didn't play around with mysqldump and friends (although in hindsight I
> >should have exported my database before the upgrade).
> Yes.  That would have been good.  :)
> >The upgrade was done automaticcaly by starting mythfrontend, I didn't
> > touch the database manually.
> OK.  First step is to verify your database is not corrupt.  Please run
> optimize_mythdb.pl from the contrib directory.  If it catches some
> errors, then try to restart Myth.  If Myth starts OK and the database
> upgrade succeeds, you can try to operate with that database, but I
> wouldn't trust it and would export the data (as in ss23.5 above), then
> drop the database, run mc.sql (to create another), run mythtv-setup (to
> fill in the database) and exit, then do a partial restore (as in ss23.7
> above), then go through mythtv-setup and frontend settings to make
> everything work the way you want.
> If optimize_mythdb.pl doesn't help, then you may want to do an export
> and use the instructions in ss23.7 above to extract the necessary data.
> Then, you'd need to drop your database, run mc.sql, start mythtv-setup
> and exit, then use the mysql client to describe the tables whose data
> you extracted from the backup and use find/replace to "manually upgrade"
> the tables to the new 0.20 structure.
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Peter Bienstman
Ghent University, Dept. of Information Technology
Sint-Pietersnieuwstraat 41, B-9000 Gent, Belgium
tel: +32 9 264 34 45, fax: +32 9 264 35 93
WWW: http://photonics.intec.UGent.be
email: Peter.Bienstman at UGent.be
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 307 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20061008/db533e15/attachment.pgp 

More information about the mythtv-users mailing list