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

Bruce Markey bjm at lvcm.com
Fri Jul 1 01:14:02 UTC 2005

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

More information about the mythtv-users mailing list