[mythtv-users] How to delete mythfrontend client settings

[Nick Morrott]

On 10/03/2008, Jean-Yves Avenard <jyavenard at gmail.com> wrote:
> Hi
>
>  Since I've upgraded mythtv my mac client running mythfrontend only
>  displays a green screen.
>
>  How can I delete all the settings related to a specific host in mysql ?

I recommend you backup the DB before editing it directly. However:

mysql> SELECT DISTINCT `hostname` FROM `settings`;

will show you the various hostnames/identifiers with settings.

mysql> DELETE FROM `settings` WHERE `hostname` = 'identifier';

will delete all settings for the machine using the chosen identifier.

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin