I'm not at home currently, but have SSH access to my mythbackend. I've got two PVR 150's in my system, and was wondering if there is a way to change the bitrate values in the recording profiles for them via SSH without having to actually be in front of my myth system.

Are they just stored in a config file somewhere, or is it pretty messy to get in there and change my "medium" quality profile from 4500 down to 3000 or something like that?

They're stored in the database so you can change them with the mysql command line client.

I would kill for a half-way usable way to change MythTV configuration. What I'd really prefer is text files I could edit, but any sort of mysql client would be better than using the MythTV GUI where I have to choose between fonts too small to read and fields/controls being off-screen.

Entering text with nothing but a remote is also very un-fun.

Having either a text-mode or a simple GUI-based (gtk would be my choice) mysql table-browser would be be wonderful.

Has anybody found such a thing?

_________________
Grant

The one in webmin is pretty usable for low volume stuff, I once added the missing subtitles for a whole series that way, cutting and pasting from one browser tab to another.

For anyhting bigger or more complicated than that I tend to write or generate the appropriate SQL commands and feed them into mysql.

I tried mysql-query-browser, but that just seems to be a fancy SQL query editor. There doesn't seem to be a simple way of displaying the rows in a table and changing them. I'll look into webmin -- I didn't know it had a mysql table browser built into it.

_________________
Grant

The webmin mysql browser isn't too bad except for for the fact that the "settings" tables have no primary key, so webmin won't edit them.

Where are frontend configuration/settings stored?

_________________
Grant

Which ones? The ones you were asking about originally are in the recording profiles so those should work fine. A search of the forums should turn up the SQL needed to change a value in the settings table. Once you've browsed it using the table viewer, hit the return to table list link, then hit the Execute SQL button. That'll give you a nice entry screen where you can enter the command and keep a history. It's not perfect, but...

Things like playback overscan, GUI size and offset, font sizes, guide settings, etc.

That was somebody else. I didn't mention any particular settings.

I know enough SQL to come up with the commands to change items. I was just looking for something a bit easier/safer.

Is there any reason those tables can't have a primary key assigned?

_________________
Grant