View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Wed Jul 25, 2007 7:29 pm 
Offline
Joined: Wed Feb 15, 2006 3:18 pm
Posts: 47
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.

_________________
--
2.4 GHz P4 - 1GB Ram - 200 GB HardDisk
2 x DVICO DVB-T Lite
nVidia 7300GT - DVICO PCI Remote - R6
Wifey loves it more than me.
--


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 25, 2007 9:52 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 26, 2007 12:33 am 
Offline
Joined: Wed Feb 15, 2006 3:18 pm
Posts: 47
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.....

_________________
--
2.4 GHz P4 - 1GB Ram - 200 GB HardDisk
2 x DVICO DVB-T Lite
nVidia 7300GT - DVICO PCI Remote - R6
Wifey loves it more than me.
--


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu