[mythtv-users] mythfilldatabase taking very long time

[Mark Greenwood]

On Wednesday 11 June 2008 19:28:32 Nick Morrott wrote:
> On 09/06/2008, Mark Greenwood <fatgerman at ntlworld.com> wrote:
> > But I have been shutting it down and starting it back up again quite a lot, sometimes
> > during recording and once during a mythfilldatabase session when it took so long
> > I thought it had crashed. Is there any way I can check for corruption in my database,
> > or anything I can run which will fix it?
> 
> You want to run optimize_mythdb.pl to check your database - details
> are on the wiki and in the installation docs. If you do have any bad
> tables in the database, it should flag them and fix them for you.
> 

Thanks, I have done that and a mythfilldatabase now takes 10 minutes! Marvellous.. sounds like a cron job is needed :)

Mark