[mythtv-users] Dump of Setup > TV > Playback page from database

[Ray Whiteman]

Hello,

Answered my own question.

The TV Playback settings are held in the settings table in mythconverg 
mysql database.

To dump them I have written a simple dump.sql script.
The contents look like

|select * from settings|

then run this simple command line.

|mysql -u mythtv -h mythtv --password=mythtv --database=mythconverg < 
~/dump_settings.sql > ~/settings_backup|

-h = <hostname>
-u = <myth sql username>
-- password = <myth sql username password>

Enjoy

Ray Whiteman wrote:
> Hello,
>
> I have just run through an irritating couple hours resetting my 
> xorg/.rc.nvidia-settings/TV playback options after a failed attempt at 
> getting XVMC working.
>
> Is there a way (scripted ideally) of dumping the TV Playback settings to 
> a human readable text file to allow me to capture the configuration 
> before fooling about next time?
>
> I can obviously backup xorg.conf and .rc-nvida-settings, and I can dump 
> the myth database. But restoring an entire database to get those 
> configuration options back seems unwieldy.
>
> For now I am using the old fashioned pen and paper method.
>
> Thanks for your help.
>
> Ray.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
>