[mythtv-users] MythTV Database problem - Credits.MYI
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
DELETE FROM people WHERE name != null;
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.
mythtv-users mailing list
mythtv-users at mythtv.org
More information about the mythtv-users