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

[Andrew Barbaccia]

On Mon, Feb 1, 2010 at 5:23 AM, Ian Oliver <lists at foxhill.co.uk> wrote:

> In article
> <c4b6bea51001311754q69e52eb0qb6849b15b2894e3b at mail.gmail.com>, Bill
> Williamson wrote:
> > Bookmarks are shared.
>
> Thanks, that's good news.
>
> I also found the database backup/restore stuff in the "how to" so I'll
> try that mysql wrangling. The intention is that I do all remote/etc.
> setup on one fe and then keep copying the new settings across to the
> others. I'll update files using rsync or dd/netcat but want any
> easy/figner-truble proof way of doing the same for mythtv settings.
>
> Ian
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


Can't you just use some sql to copy the settings?

insert into settings (value, data, hostname) select value, data,
'newhostname' from settings where hostname = 'oldhostname';
Just my 2c.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100202/eb399d86/attachment-0001.htm>