View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu Jul 06, 2006 11:23 am 
Offline
Joined: Mon Jun 07, 2004 11:48 am
Posts: 55
I was searching for the database location for mysql, which cesman pointed to /var/lib/mysql. In addition, I found the schema at:
http://www.cuymedia.net/doxygen-dev-doc ... chema.html

And for those looking to delete a channel(s) from the database, check out:
https://www.ilikelinux.com/howto/MythTVMySQL


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 06, 2006 12:04 pm 
Offline
Joined: Thu Dec 15, 2005 8:15 pm
Posts: 46
Location: Michigan
Without going through all that trouble or knowing where the database is on the system (even from the command line that shouldn't be necessary), just use the WebMin interface for easy access.

If you're really good, you can have a great experience if you install SqlMyAdmin (or is that mySQLAdmin -- whatever). It's simple to install. I haven't done so yet on my Myth box, but I'm planning on doing it when I do my reinstall next weekend or so.

I've not read the schema, but if you read the table numbers and look at the table data, you'll be able to figure out a lot of it.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 06, 2006 3:42 pm 
Offline
Joined: Tue Apr 13, 2004 6:51 pm
Posts: 890
Location: Groton, MA
you can use the Mythweb interface.

Go to Settings -> channels. check teh 'delete' box for any channel you want deleted and press 'save'

As they say in the commercial 'That was Easy' :)

_________________
R5F1 - Dell P4 2.4Ghz 500MB - PVR250 x 2 - GeForce FX 5200 - Onboard sound/NIC 80GB ATA/250GB ATA/400GB SATA


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 06, 2006 7:39 pm 
Offline
Joined: Mon Jun 07, 2004 11:48 am
Posts: 55
Thanks for the input, my search to find information of where the database llocation was, was to copy the recorded information database files from a corrupt myth install to a new install instead of manually entering each recorded program and came arcoss a few web pages I thought would be of interest.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 10, 2006 2:23 am 
Offline
Joined: Wed Feb 08, 2006 8:04 pm
Posts: 4
I like to use phpMyAdmin... easy to install, great for tweaking broken DB entries for channels when using DVB.

P.


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 5 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:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu