How to check and repair corrupted SQLite database.
If you find database errors in your log files, or repeated "closing database" entries, your SQLite database may be corrupted.
The following instructions apply to the MediaPortal video database, but could be applied to any MediaPortal SQLite database.
sqlite3.exeinto a working folder, e.g.
Make a copy of the corrupted Database into the working folder "
C:\SQLRepair"and name it, e.g. to
open cmd (Command prompt) and go to
type following in command prompt to check DB integrity (copy-paste these commands into cmd):
If you see any error message(s), then type following in command prompt to extract data into an SQL File and recreate a new Database with the extracted Data (copy-paste these commands into cmd) :
Backup your corrupted video database to somewhere. Copy the repaired one from
C:\SQLRepair and overwrite your corrupted db.
You can also check this forum post for similar type of solution, but more appropriate for automating.
This page has no comments.