[mythtv-users] Copy settings from one hostname to another scripts or new MythWEB features

[Chris Petersen]

> 1.  Be able to copy all the settings, keybindings, jumppoints, playlists  to
> another new hostname for a new frontend,  bacicly SELECT * from TABLE where
> HOSTNAME="myGoodFrontEnd"  then INSERT INTO TABLE   values  SET
> HOSTNAME=NewHostName..

     REPLACE INTO settings (data, value. hostname)
             SELECT (data, value, "new_host")
               FROM settings
              WHERE hostname = "old_host";

(yes, that's one query)

It seems that there is no "unique" index on the settings table, so it 
looks like you might also need:

     DELETE FROM settings WHERE hostname = "old_host"

-Chris