[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