[mythtv-users] Troubles to upgrade database schema
Yann Lehmann
aristide at vtxmail.ch
Sun Oct 28 21:05:21 UTC 2012
Hi
Now that MythTV 0.26 and Ubuntu 12.04 are out, I have decided to
upgrade my MythTV system, currently running 0.21 on a Hardy, going to
0.23 as a first step.
To do so, I put a second hard disk in my combined backend/frontend and
installed Mythbuntu 10.04 with MythTV 0.23 along the old system.
Then I booted in the new system and restored a fresh backup of the 0.21
database (on schema 1214), using the 'mythconverg_restore.pl' script
(with 'drop_database' and '--create_database').
Then I ran 'mythtv-setup' on the new system in order to upgrade the
database.
The database was upgraded from schema 1214 to 1215.
After the upgrade, mythfrontend says that the database needs to be
upgraded with the following message:
'This version of MythTV requires an updated database. (schema is 39
versions behind).
Please run mythtv-setup or mythbackend to update your database.'
When I run mythtv-setup again, it displays this:
'Warning: MythTV wants to upgrade your database, for the TV schema, from
1215 to 1254.'
When I choose to upgrade the db, a backup-file is created, but the db
doesn't get upgraded. In the terminal-window of mythtv-setup, I can see
something like 'newest DB schema 1254' just before the window closes.
But the database remains on schema 1215.
When I start mythfrontend on the command line, the following output is
displayed in the shell:
'Not allowed to upgrade the database. Skipping backup. Couldn't upgrade
database to new schema, exiting.'
Should I upgrade to 0.22 first ? I have seen posts on this list saying
that a database of a 0.21 version could easily get upgraded on a 0.23
system.
Any help will be very appreciated.
Regards
Yann Lehmann
PS: If that matters, I am running mythtv-setup as a "normal" user, not
as the "mythtv-user".
More information about the mythtv-users
mailing list