[mythtv-users] MythTV Database problem - Credits.MYI
Korey Fort
k.m.fort at gmail.com
Fri Jul 1 01:03:06 UTC 2005
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
More information about the mythtv-users
mailing list