How to check and repair corrupted sqlite database:
1. Download sqlite3.exe from http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.zip
2. Copy VideoDatabaseV5.db3 as bad.db to some folder (ie. C:\SQLRepair)
3. Copy sqlite3.exe from downloaded ZIP file to C:\SQLRepair
open cmd (Command prompt) and go to C:\SQLRepair
type following in command prompt (you can also copy-paste into cmd those commands):
sqlite3 bad.db
pragma integrity_check;
If you see error message then do next
exit sqlite3.exe with CTRL+C
type following in command prompt (you can also copy-paste into cmd those commands)::
echo .dump | sqlite3.exe bad.db > good.sql
sqlite3.exe -init good.sql VideoDatabaseV5.db3
4. Backup your corrupted videodatabase to somewhere and copy repaired one (from C:\SQLRepair) over your corrupted db.
1. Download sqlite3.exe from http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.zip
2. Copy VideoDatabaseV5.db3 as bad.db to some folder (ie. C:\SQLRepair)
3. Copy sqlite3.exe from downloaded ZIP file to C:\SQLRepair
open cmd (Command prompt) and go to C:\SQLRepair
type following in command prompt (you can also copy-paste into cmd those commands):
sqlite3 bad.db
pragma integrity_check;
If you see error message then do next
exit sqlite3.exe with CTRL+C
type following in command prompt (you can also copy-paste into cmd those commands)::
echo .dump | sqlite3.exe bad.db > good.sql
sqlite3.exe -init good.sql VideoDatabaseV5.db3
4. Backup your corrupted videodatabase to somewhere and copy repaired one (from C:\SQLRepair) over your corrupted db.