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

[Steven Adeff]

On 3/2/06, Chris Petersen <lists at forevermore.net> wrote:
> > 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

I've run into a situation where I want to do this, but when I run,

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

I get,
ERROR 1241 (21000): Operand should contain 1 column(s)

I'd like to copy the settings as I have another computer using
"MythBox" and I want to replicate the settings for "MythCenter" to be
able to tweak from there.

thanks!

-- 
Steve
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette