[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