[mythtv-users] How to delete mythfrontend client settings

[Sarah Hayes]

Nick Morrott wrote:
> 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.
>
>   
I'd been wondering how to do this myself from the mysql client.  Ta 
muchly for the demo.

Sarah