[mythtv-users] (almost) completely fresh install

[Marius Schrecker]

On Tuesday, November 21, 2017 05:27 CET, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
 On Mon, 20 Nov 2017 10:18:21 +0100, you wrote:

>
>Hi,
>   My combined backend-frontend server has been retired and I am starting work to replace it with a distributed system.
>
>I haven't taken the time to maintain the old (updated to 0.28) system for quite a while now so despite the database being in a consistent state, quite a few settings are either outdated cruft or no longer working (my hd-pvr for example no longer works with mythtv and my channel list is hopelessly out of date). 
>
>  Because of this, I have decided to go for a completely fresh install and configure, only saving my recordings from the old database.  I was intending to use mythexport to save my recording metadata, but can't make the cgi scripts work, so rather than spending time trying to figure that out, am thinking of going for a "partial"restore to a new, empty database, using mythconverg_backup.pl and mythconverg_restore.pl
>following the instructions at https://www.mythtv.org/wiki/Database_Backup_and_Restore.
>
>Both the old and the new systems are running version 0.28
>
>Can anyone think of any reasons for NOT using this approach?
>
>BR.
>
>--Marius--

The mythconverg_restore.pl --partial_restore option restores the
recording rules as well as the recordings. But it only works if the
database schema is the same - see the Wiki page for how to make it
work when you are also upgrading the schema.

Here is the code from mythconverg_restore.pl that specifies the tables
that --partial_restore will keep (unless you also use the
--with_plugin_data option):

@partial_restore_tables = ('oldrecorded',
'record',
'recorded',
'recordedmarkup',
'recordedprogram',
'recordedrating',
'recordedseek');

The oldrecorded table is all the programs that have previously been
recorded (very useful to prevent recording of repeats, as well as
things you have already watched and deleted), and the record table is
the recording rules. The other tables are for the existing
recordings.

The tables that are used by mythexport/mythimport for a recording are
similar:

recorded
recordedseek
recordedrating
recordedprogram
recordedmarkup
recordedcredits

except that recordedcredits is also transferred.

I think that both --partial_restore and mythexport/mythimport should
also be transferring the recordedfile table these days. However, as
it was added recently and hence only contains data about recordings
made since it was added, MythTV is OK if there is no recordedfile
entry for a recording, in order to work with all your older
recordings. So not transferring that data does not make anything stop
working. It just provides less detailed information about the
recording.

I think that using --partial_restore is probably not the best option.
If your main concern about your old database is to do with the tuners
and channels, I would recommend just transferring the entire database,
then on the new system using mythtv-setup > Capture cards > Delete all
capture cards. That option is specially coded so that it completely
cleans up the database related to tuners and channels and allows a
clean new setup. You might also want to do mythtv-setup > Video
sources > Delete all video sources for an even more complete cleanup.

With respect to using mythexport, what problems were you having? If
you are unable to get the http://<mythtv box address>/mythexport page
to show up, then I have recently updated my page here:

http://www.jsw.gen.nz/mythtv/mythimport.html

with some extra information that may help. And feel free to email me
directly if necessary.
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Hi Stephen,

  Thank you very much for your detaild reply.  I did respond to it but see that my message is in the moderation trap.

BR.

--Marius--


 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20171121/fab88bf8/attachment.html>