Now I've gotten myself into a pickle. Because the text in various selection screens wasn't lining up with the highlights for me, I thought I'd try some different themes included with KnoppMyth to see if they were better. Most were no better.

Then I tried "Minimalist something-or-other theme" (I think!) and now I have no menu choice for Setup anymore. I want to get out of this theme, but without Setup I have no idea how to. Is there some file I can edit to get myself back to the default Blue theme? Barring that, is there some magic keystroke incantation/shortcut to get me directly to Setup->Appearance? BTW, the KnopMyth menu choise that was there in Blue is missing now as well. Maybe others too - I don't remember all the old menu choices I used to have off the top of my head.

Search for a post by me which mentions "theme" "settings" and "sql". It has directions on how to do this.

Ok, I found your earlier post. I can handle delete and insert statements. Now I have an even more basic (and newbie) question. I'm fine running direct SQL, using Informix and Oracle on many Unix boxes for years. But I'm unfamiliar with MySQL. So far I've gotten in partly, but not to a database.

I ran "mysql -h localhost -u mythtv -p"
It prompted me for a password and I got in using "mythtv"
Now I think I need to access a specific database, I believe using "connect" or "use"
But I don't know a database name. Guessing "mythtv" as a DB name didn't work.

Once I get to a prompt where I can run something like "describe settings;" I'll be in good shape (I think). But how do I get there? Your previous post said "Click on the Execute SQL button". Huh? What button? I'm at the Linux command line. Is this within the Myth frontend? Where? Maybe under some advanced settings or something (I might guess), but I don't have a Settings menu item.

Man I feel stupid right now. Can't even get into the friggin' database to run some simple SQL. I'm hopeless!

As root you can do:

Or:

or any of a number of variations. As a ordinary user you can say:

Note that "localhost" is the assumed default. Finally you can issue the SQL commands using the webmin interface as was discussed further up that thread.

the database name is mythconverg but if you are using mysql command line there is no clicking. if someone mentioned clicking they were probably talking about in webmin. for more info on webmin check the wiki.

also for getting out of a wide theme on a regular tv I thought there was a post about being able to use the pgdown or pgup keys to see what you need to change it. you might want to search the forum for that, as it would be easier than changing the database directly.

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets

Thanks both tjc and Xsecrets! It was a most trivial exercise once you guys forwarded the database name to me. I first ran "update settings set data = 'Blue' where value = 'Theme';" The frontend wouldn't start (probably it's not "Blue", but rather "blue" ... whatever) Anyway, I used "Iulius" and that got the frontend going again and from there I was able to use the regular frontend GUI to set things back to Blue.