LinHES Forums
http://forums.linhes.org/

Purge old frontend database settings
http://forums.linhes.org/viewtopic.php?f=6&t=15970		 Page 1 of 1
Author:  weblst [ Wed Jul 25, 2007 7:29 pm ]
Post subject:  Purge old frontend database settings
I have (overtime) used several frontends and would like to rid myself of lingering stale settings from these no longer used systems. Anyone got a few hints on how to go about it ????

Thanks.
Author:  tjc [ Wed Jul 25, 2007 9:52 pm ]
Post subject: 
Whatever you do please, Please, PLEASE, PLEASE make a backup first!

Then do this:
Code:
mysql -u root mythconverg -e "select distinct(hostname) from settings"

That will tell you all the names you need to get rid of. Then for each one do this:
Code:
mysql -u root mythconverg -e "delete from settings where hostname = 'stale-name-here'"

That should get most of it.

Other tables that care about hostname (capturecard, inuseprograms, jobqueue, jumppoints, keybindings, music_playlists, musicplaylist, profilegroups) can be treated similarly.

Do NOT do this for "recorded".

Again, whatever you do please, Please, PLEASE, PLEASE make a backup first! Given the number of people who've already posted questions today that prove they can't read directions I will point and laugh if you ignore this bit of advice and things go all pear shaped.
Author:  weblst [ Thu Jul 26, 2007 12:33 am ]
Post subject: 
Many thanks tjc that worked a treat.


Quote:
Again, whatever you do please, Please, PLEASE, PLEASE make a backup first! Given the number of people who've already posted questions today that prove they can't read directions I will point and laugh if you ignore this bit of advice and things go all pear shaped.

:-) No probs there I am a backup junky (I would get shot if I lost a wifey CSI episode)

Thanks again.....
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/