View unanswered posts    View active topics

Board index Linux MythTV

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 7 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
MiguelSanchez
PostPosted: Fri Dec 16, 2005 4:13 pm 
Offline
Joined: Tue Sep 13, 2005 4:09 pm
Posts: 18
On accident, I ran the Video manager with a backup of my old install (just upgraded from R5A16). I didn't realize until it was too late, and now I have a bunch of files (kernel, sources, etc) in my Video database, which is causing all sorts of problems. I went back to the Video Manager and it's removing the files one by one, but it takes a few seconds for each file and it's been running constantly for about a day. Is there a faster way to wipe clean that part of the database?
Top
 Profile  
 
lorenzanaj
 Post subject:
PostPosted: Sat Dec 17, 2005 11:46 am 
Offline
Joined: Fri Jun 17, 2005 8:48 am
Posts: 9
Location: Chicago, IL
Do some google searches on mysql querries on deleting everything from the videometadata table. from the linux prompt:

[root@localhost mythconverg]# mysql -p -u mythtv mythconverg
Enter password: mythtv

To view the table:
select * from videometadata;

To delete data from table (not 100% sure on this, google it):
delete * from videometadata;


Good luck.

_________________
Sempron 2800+
Fedora Core 3, mythtv-suite-0.18.1-55.at
pvr-150, pvr-500, ivtv 0.3.6l
Top
 Profile  
 
spalVl
 Post subject:
PostPosted: Sat Dec 17, 2005 4:57 pm 
Offline
Joined: Mon Aug 29, 2005 4:04 pm
Posts: 729
Location: Philadelphia, PA US
or, create an empty directory on the Myth box, change MyVideo to use empty directory in Utilities/Setup and go Video Manager when rescans choose to remove bad files.
Top
 Profile  
 
MiguelSanchez
 Post subject:
PostPosted: Sat Dec 17, 2005 6:07 pm 
Offline
Joined: Tue Sep 13, 2005 4:09 pm
Posts: 18
spalVl wrote:
or, create an empty directory on the Myth box, change MyVideo to use empty directory in Utilities/Setup and go Video Manager when rescans choose to remove bad files.


The problem is that it has been 2 days since I went back to the Video Manager and it is still removing bad files. I have webmin installed - can I use that to wipe out videometadata? Would that be safe?
Top
 Profile  
 
MiguelSanchez
 Post subject:
PostPosted: Sat Dec 17, 2005 10:07 pm 
Offline
Joined: Tue Sep 13, 2005 4:09 pm
Posts: 18
Here is what mysql.log is reporting:

Code:
1 Query       SELECT NULL
                      1 Query       SELECT intid FROM videometadata WHERE filename = '/myth/video/backup/usr/local/lib/vlc/video_output/libopengl_plugin.so'
051217 20:06:35       5 Query       SELECT NULL
                      5 Query       SELECT filename FROM videometadata WHERE intid = 46552
                      5 Query       DELETE FROM videometadata WHERE intid = 46552
                      5 Query       DELETE FROM videometadatacountry WHERE idvideo = 46552
                      5 Query       DELETE FROM videometadatagenre WHERE idvideo = 46552
                      5 Query       DELETE FROM filemarkup WHERE filename = '/myth/video/backup/usr/local/lib/vlc/video_output/libopengl_plugin.so'
                      1 Query       SELECT NULL
                      1 Query       SELECT intid FROM videometadata WHERE filename = '/myth/video/backup/usr/local/lib/vlc/visualization/libvisual_plugin.so'


Should I delete everything from videometadata, videometadatacountry, videometadatagenre, and filemarkup? Or will that kill my mythtv database?
Top
 Profile  
 
lorenzanaj
 Post subject:
PostPosted: Sun Dec 18, 2005 1:21 pm 
Offline
Joined: Fri Jun 17, 2005 8:48 am
Posts: 9
Location: Chicago, IL
I'd guess myth can't find the files and things go wrong from there. You can possibly put all the files back in those dirs and myth will probably delete them afterwards.

I'd recommend manipulating the database manually as stated b4. But before you mess around w/ the database shut the backend down, and backup the database. I usually just:

Code:
cp -a /var/lib/mysql /var/lib/mysql.bak


Then go ahead and manually delete all records in those tables you found (looks like the complete list you have). Strangly my videometadatcountry and filemark tables don't have any records so I'm not sure what got put in there.

Code:
mysql> select * from videometadatacountry;
Empty set (0.00 sec)

mysql> select * from filemarkup;
Empty set (0.01 sec)


I usually backup my database once a month just for occasions your experiencing now.

_________________
Sempron 2800+
Fedora Core 3, mythtv-suite-0.18.1-55.at
pvr-150, pvr-500, ivtv 0.3.6l
Top
 Profile  
 
MiguelSanchez
 Post subject:
PostPosted: Sun Dec 18, 2005 5:53 pm 
Offline
Joined: Tue Sep 13, 2005 4:09 pm
Posts: 18
I did do a backup, and tried to look at videometadatacountry and filemarkup tables but webmin told me there wasn't a primary index or something. Anyhow, I deleted everything and it seems like things are running smoothly now. Thanks for all the help!
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 7 posts ] 


Board index Linux MythTV

All times are UTC - 6 hours




Who is online

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