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

[Scott Carr]

Bruce Markey wrote:

> 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

Thanks, this worked like a charm.

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