Corrupt Program DB? (1 Viewer)

[rsbrux]

Since a few days, my HTPC refuses to shut down. Looking at the log files, it looks as though the problem is caused by a corruption of the TV Program Guide DB. Is this uninformed interpretation correct? How can I correct the situation?

 

[Holzi]

Indeed, it could be a corrupt database. Shut down TVService.exe and try this:

Since running MP Version 1.1. beta I have had a number of corruptions to program.myi.
So I have been have used the following to repair mysql database files.

CD C:\Program Files\MySQL\MySQL Server 5.1\bin
mysqlcheck mptvdb --auto-repair -e -u root -p

when asked password = "MediaPortal"

Hope it help anyone as it took me hours to find how to do this.

 

[rsbrux]

Looks much better now, many thanks!

 

[rsbrux]

Seems that I rejoiced too soon. DB corruption is fixed, but it looks like EPG is still keeping the HTPC awake. Logs attached.

P.S. Should I start a new thread for this?