[mythtv-users] How to copy 'frontend' portion of mysql database

Jeffrey J. Kosowsky mythtv at kosowsky.org
Thu Jan 7 13:32:05 UTC 2010


Nick Morrott wrote at about 10:56:24 +0000 on Thursday, January 7, 2010:
 > 2010/1/7 Jeffrey J. Kosowsky <mythtv at kosowsky.org>:
 > > Nick Morrott wrote at about 07:34:23 +0000 on Thursday, January 7, 2010:
 > >  > 2010/1/7 Jeffrey J. Kosowsky <jeff at kosowsky.org>:
 > >  > > On my server's combined frontend/backend, I spent a fair bit of time
 > >  > > customizing all the zillions of options in the mythfrontend setup
 > >  > > menu.
 > >  > >
 > >  > > I now am adding a remote frontend only and would like to copy over all
 > >  > > the mythfrontend relevant tables without copying over all the backend
 > >  > > video card/input and program data.
 > >  > >
 > >  > > So, I would like to know what tables can I 'drop' that are only used
 > >  > > by the backend?
 > >  >
 > >  > Are you wanting to clone your frontend settings from one frontend to
 > >  > another? Frontend settings are held in the `settings` table against a
 > >  > hostname or other identifier you have given during frontend setup.
 > >  >
 > >
 > > Also in the 'keybindings' table.
 > >
 > > Are there any other tables that have local frontend data?
 > 
 > AFAICT the core tables that store frontend settings data against hostnames are:
 > 
 > jumppoints
 > keybindings
 > settings
 > 
 > There are also the displayprofilegroups and displayprofiles tables,
 > but these store data with autoincrementing fields so it is not as
 > straightforward to SnR one hosthame with another.
 > 
 > Plugins may also store settings for each frontend in (at least) the
 > folowing tables:
 > 
 > music_playlists
 > weatherscreens
 > weathersourcesettings
 > 
Thanks....
Now are there any "established" routines to properly copy this all
over?
If not would it be best to do this directly in mysql? (I personally
don't know much if any sql commands)

Or would it be better to dump the relevant tables, then use something
like 'sed' to change the relevant entries and then import back the
changed entries?


More information about the mythtv-users mailing list