[mythtv-users] [mythtv] Recovering recording meta data from 0.18 DB dump?

[Fredrik Karlsson]

Hi,

Thank you for your reply. However, it is not that simple.
When I do what you suggest, the backend does not start properly and
spits out this in the log:

2006-07-19 22:58:32.959 New DB connection, total: 2
2006-07-19 22:58:32.960 Connected to database 'mythconverg' at host: localhost
2006-07-19 22:58:32.966 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-07-19 22:58:32.971 New DB connection, total: 3
2006-07-19 22:58:32.973 Connected to database 'mythconverg' at host: localhost
2006-07-19 22:58:32.975 Told to create a NEW database schema, but the database
already has 49 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2006-07-19 22:58:32.976 Database Schema upgrade FAILED, unlocking.
2006-07-19 22:58:32.977 Couldn't upgrade database to new schema

So, the automatic upgrade approach does not seem to work...

/Fredrik

On 7/19/06, George Nassas <gnassas at mac.com> wrote:
> On 19-Jul-06, at 3:20 AM, Fredrik Karlsson wrote:
>
> > MythTV 0.19. So, all I have is meta data from the 0.18.1 release,
> > which is different in data base structure compared to 0.19 ( or so
> > ...
> > a) which columns I should fill the data I have into. Specifically,
> > I need a
> > ...
> > b) What do I do with the empty columns? Do I have to fill it with
> > anything?
>
> No manual tinkering is needed. Just restore your old DB and when the
> backend comes up it will automatically upgrade the tables to whatever
> version you're running. After that you can run contrib/
> myth.rebuilddatabase.pl which will scan your recordings directory for
> files which aren't in your database and prompt you for info to
> restore them.
>
> The only remaining problem is you will have entries in your watch
> recordings list for shows that were present at the time of the backup
> but were deleted later. You can find them by attempting to play each
> show and removing the ones that mention "file missing" or whatever.
> If you have tons of stale recordings it's possible to write some
> clever shell and sql to list them.
>
> - George
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>


-- 
--
My Gentoo + PVR-350 + IVTV + MythTV blog is on http://gentoomythtv.blogspot.com/