[mythtv-users] MythTV Database problem - Credits.MYI

[Korey Fort]

Look and see if those entries are UNIQUE inside the table. You may have many
many many duplicates of the same thing on those tables. I'm not sure what
deleting all of the entries and then running mythfilldatabase again would
mean for everything else on the system. 

If you just want to get rid of everything in those tables you could try
this:
DELETE FROM people WHERE name != null;

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Scott Carr
Sent: Thursday, June 30, 2005 7:36 PM
To: mythtv-users at mythtv.org
Subject: [mythtv-users] MythTV Database problem - Credits.MYI

I have been having problems with MythFillDatabase taking FOREVER to 
input the records.  This process used to take about 5 minutes, now it 
takes close to 24 hours.

I noticed that my Credits.myi has 14000000 records and my people table 
only has 800000 records.  Is there something going on here?

If I try to list the Credits.myi table it takes forever.

-- 
Scott Carr
OpenOffice.org
Documentation Maintainer
http://documentation.openoffice.org

_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users