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

[Bruce Markey]

Scott Carr wrote:
> 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.


$ mysql -u mythtv -pmythtv mythconverg
mysql> truncate table program;
mysql> truncate table programrating;
mysql> truncate table people;
mysql> truncate table credits;
mysql> quit
$ mysqlcheck -r -u mythtv -pmythtv mythconverg
$ mythfilldatabase

--  bjm