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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Carr Sent: Thursday, June 30, 2005 7:36 PM To: mythtv-users@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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
