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

[Nick Morrott]

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

Cheers,
Nick

-- 
Nick Morrott

MythTV Official wiki: http://mythtv.org/wiki/
MythTV users list archive: http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin