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

Ray Whiteman ray.whiteman at consultant.com
Mon Jul 28 07:02:22 UTC 2008


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>


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

More information about the mythtv-users mailing list