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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
