[mythtv-users] How to copy 'frontend' portion of mysql database
Jeffrey J. Kosowsky
mythtv at kosowsky.org
Thu Jan 7 13:34:41 UTC 2010
Ronald Frazier wrote at about 06:51:56 -0500 on Thursday, January 7, 2010:
> >From my notes, here is the easiest way to setup a new frontend
> identical to the old frontend end. Edit these queries, replacing all
> instances of <NEWHOSTNAME> and <OLDHOSTNAME> then run.
>
> DELETE FROM settings WHERE hostname ='<NEWHOSTNAME>';
> INSERT INTO settings(value, data, hostname) SELECT value, data,
> "<NEWHOSTNAME>" FROM settings WHERE hostname = "<OLDHOSTNAME>"
>
> DELETE FROM keybindings WHERE hostname ='<NEWHOSTNAME>';
> INSERT INTO keybindings(context, action, description, keylist,
> hostname) SELECT context, action, description, keylist,
> "<NEWHOSTNAME>" FROM keybindings WHERE hostname = "<OLDHOSTNAME>"
>
> DELETE FROM jumppoints WHERE hostname ='<NEWHOSTNAME>';
> INSERT INTO jumppoints(destination, description, keylist, hostname)
> SELECT destination, description, keylist, "<NEWHOSTNAME>" FROM
> jumppoints WHERE hostname = "<OLDHOSTNAME>"
>
SWEET!
I assume though if I am *adding* a frontend then, I want to skip the
first "DELETE" line of each stanza? Right?????
More information about the mythtv-users
mailing list