<html><br />On Tuesday, November 21, 2017 05:27 CET, Stephen Worthington <stephen_agent@jsw.gen.nz> wrote:<br /> <blockquote type="cite" cite="bp871dtckn6113ol0mc5229ive8a2s78td@4ax.com">On Mon, 20 Nov 2017 10:18:21 +0100, you wrote:<br /><br />><br />>Hi,<br />> My combined backend-frontend server has been retired and I am starting work to replace it with a distributed system.<br />><br />>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). <br />><br />> 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<br />>following the instructions at https://www.mythtv.org/wiki/Database_Backup_and_Restore.<br />><br />>Both the old and the new systems are running version 0.28<br />><br />>Can anyone think of any reasons for NOT using this approach?<br />><br />>BR.<br />><br />>--Marius--<br /><br />The mythconverg_restore.pl --partial_restore option restores the<br />recording rules as well as the recordings. But it only works if the<br />database schema is the same - see the Wiki page for how to make it<br />work when you are also upgrading the schema.<br /><br />Here is the code from mythconverg_restore.pl that specifies the tables<br />that --partial_restore will keep (unless you also use the<br />--with_plugin_data option):<br /><br />@partial_restore_tables = ('oldrecorded',<br />'record',<br />'recorded',<br />'recordedmarkup',<br />'recordedprogram',<br />'recordedrating',<br />'recordedseek');<br /><br />The oldrecorded table is all the programs that have previously been<br />recorded (very useful to prevent recording of repeats, as well as<br />things you have already watched and deleted), and the record table is<br />the recording rules. The other tables are for the existing<br />recordings.<br /><br />The tables that are used by mythexport/mythimport for a recording are<br />similar:<br /><br />recorded<br />recordedseek<br />recordedrating<br />recordedprogram<br />recordedmarkup<br />recordedcredits<br /><br />except that recordedcredits is also transferred.<br /><br />I think that both --partial_restore and mythexport/mythimport should<br />also be transferring the recordedfile table these days. However, as<br />it was added recently and hence only contains data about recordings<br />made since it was added, MythTV is OK if there is no recordedfile<br />entry for a recording, in order to work with all your older<br />recordings. So not transferring that data does not make anything stop<br />working. It just provides less detailed information about the<br />recording.<br /><br />I think that using --partial_restore is probably not the best option.<br />If your main concern about your old database is to do with the tuners<br />and channels, I would recommend just transferring the entire database,<br />then on the new system using mythtv-setup > Capture cards > Delete all<br />capture cards. That option is specially coded so that it completely<br />cleans up the database related to tuners and channels and allows a<br />clean new setup. You might also want to do mythtv-setup > Video<br />sources > Delete all video sources for an even more complete cleanup.<br /><br />With respect to using mythexport, what problems were you having? If<br />you are unable to get the http://<mythtv box address>/mythexport page<br />to show up, then I have recently updated my page here:<br /><br />http://www.jsw.gen.nz/mythtv/mythimport.html<br /><br />with some extra information that may help. And feel free to email me<br />directly if necessary.<br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />http://wiki.mythtv.org/Mailing_List_etiquette<br />MythTV Forums: https://forum.mythtv.org</blockquote><br />Hi Stephen,<br /><br /> Thank you very much for your detaild reply. I did respond to it but see that my message is in the moderation trap.<br /><br />BR.<br /><br />--Marius--<br /><br /><br /> </html>