View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Aug 13, 2006 12:32 pm 
Offline
Joined: Sun Nov 14, 2004 10:04 am
Posts: 263
Location: Toronto, Canada
Hi friends:

Well, I want to burn a couple of shows to DVD. But they were recorded when I was having nasty
program guide problems, and so they have the wrong title.

Can I go into the database and change the show title somehow? If so, could somebody step me
through that? I have absolute zero knowledge of SQL.


Shplad

_________________
KnoppMyth R5C7
Abit NF7-S
Athlon XP Mobile 2500+
Hauppauge PVR-150 + PVR-150MCE
nVidia Geforce 6600GT
Samsung Spinpoint SATA 120GB
NEC ND-3520A DVD
Seasonic Super Tornado 350
BTC 9019URF Wireless Kbd. w. Joystick


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 13, 2006 12:36 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Use the webmin interface. It will let you do form based editing of the tables.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 13, 2006 7:49 pm 
Offline
Joined: Sun Nov 14, 2004 10:04 am
Posts: 263
Location: Toronto, Canada
tjc:

Thanks, I got to webmin's interface for MySQL, but care to elaborate?

As I said above
Quote:
I have absolute zero knowledge of SQL.


Please, if you will, some specifics


Shplad

_________________
KnoppMyth R5C7
Abit NF7-S
Athlon XP Mobile 2500+
Hauppauge PVR-150 + PVR-150MCE
nVidia Geforce 6600GT
Samsung Spinpoint SATA 120GB
NEC ND-3520A DVD
Seasonic Super Tornado 350
BTC 9019URF Wireless Kbd. w. Joystick


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 13, 2006 9:39 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
shplad wrote:
I have absolute zero knowledge of SQL.

You should be in good shape then because this is exactly the amount of knowledge required. ;-)

Under webmin go to: Servers -> mysql database server -> mythconverg -> recorded -> view data (bottom of the page)

Down the left hand side of the spreadsheet shown are check boxes to select items. At the bottom of the page are 3 buttons. Select a couple rows to test by checking the checkbox, then hit "Edit selected rows". This will bring an altered page up with entry fileds where you can modify the data in the selected rows. Don't forget to hit the save button when you're done. It really couldn't be much easier.

The only thing to be aware of is that webmin has a 5 minute activity time out (and filling in forms doesn't count as activity because it doesn't go back to the server) so take small bites (1 or 2 recordings) and work quickly.


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 23 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