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

Nick Morrott knowledgejunkie at gmail.com
Mon Jul 28 15:22:41 UTC 2008


On 28/07/2008, Ray Whiteman <ray.whiteman at consultant.com> wrote:
> 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>

$ mysqldump -u <user> -h <dbhost> -p mythconverg settings > ~/settings_backup

should do the same thing.

$ man mysqldump gives the plentiful options list

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list