[mythtv-users] MythTV Database problem - Credits.MYI
scarr at progbits.com
Fri Jul 1 23:57:12 UTC 2005
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.
More information about the mythtv-users