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

[Jeffrey J. Kosowsky]

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?????