[mythtv-users] mythconverg hygiene question

Don Brett dlbrett at zoominternet.net
Mon Jul 16 15:03:32 UTC 2018


I have a mythconverg database that's been migrated from several 
versions.  It works fine, but on my latest migration, I notice some 
lingering hostnames from years ago.  For example, the settings table 
should have hostname as nick, but it also has andy, kate, katie, null, 
and localhost (all are earlier boxes).  I also see cases of multiple 
entries of the same property, here are some examples (from settings table):

| AC3PassThru                  | 0 | andy      |
| AC3PassThru                  | 0 | andy      |
| AC3PassThru                  | 0 | kate      |
| AC3PassThru                  | 0 | localhost |
| AC3PassThru                  | 0 | nick      |

| AdjustFill                        | 0 | andy      |
| AdjustFill                        | 0 | andy      |
| AdjustFill                        | 0 | andy      |
| AdjustFill                        | 0 | kate      |
| AdjustFill                        | 0 | localhost |
| AdjustFill                        | 0 | nick      |


On each migration, I installed a separate box, copied everything over, 
then changed the hostname.  Just to add a little detail:

Install database process is:
drop default database on new box, install blank from script (mc.sql), 
restore current with mythconverg_restore.pl.

Change hostname command is:
$ sudo /usr/share/mythtv/mythconverg_restore.pl --change_hostname 
--old_hostname="nick" --new_hostname="andy"


Mythconverg_restore.pl does a pretty good job of changing hostnames 
(loops through all tables), but I don't see a way resolve duplicates.  
Should I be concerned?


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the mythtv-users mailing list