[mythtv-users] I Messed up Myth's menu-how to fix?

[chris at cpr.homelinux.net]

On Sun, Nov 13, 2005 at 08:48:14PM -0500, Robert Lundy wrote:
> Is there a config file somewhere that I can go into to get back to another
> theme?  This is with myth 0.18.1.
>   I've
> tried a yum remove mythtv-suite then a yum install mythtv-suite.  But
> apparently yum doesn't remove all the files because the same messed up menu
> came up after the reinstall.

Uninstalling the front-end software doesn't delete the theme settings 
stored in the MySQL database on the back-end.

Login to your front-end as root and type the following *EXACTLY*:

mysql mythconverg -e "delete from settings where hostname=\"`uname -n`\""

If successful, it will respond by telling you how many records it 
deleted.  This will erase all of your front-end settings for that 
machine only.  The next time you start the front-end it will prompt you 
for your language and launch the setup screen.