home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
Startup time for Mediaportal
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Deda" data-source="post: 1040159" data-attributes="member: 89768"><p><span style="color: #ff0000"><strong>How to check and repair corrupted sqlite database:</strong></span></p><p></p><p>1. Download sqlite3.exe from <a href="http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.zip" target="_blank">http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.zip</a></p><p></p><p>2. Copy <strong>VideoDatabaseV5.db3</strong> as <strong>bad.db</strong> to some folder (ie.<strong> C:\SQLRepair</strong>)</p><p></p><p>3. Copy sqlite3.exe from downloaded ZIP file to C:\SQLRepair</p><p></p><p>open cmd (Command prompt) and go to C:\SQLRepair</p><p></p><p>type following in command prompt (you can also copy-paste into cmd those commands):</p><p><em><strong>sqlite3 bad.db</strong></em></p><p><em><strong>pragma integrity_check;</strong></em></p><p></p><p>If you see error message then do next</p><p></p><p>exit sqlite3.exe with CTRL+C</p><p></p><p>type following in command prompt (you can also copy-paste into cmd those commands)::</p><p><em><strong>echo .dump | sqlite3.exe bad.db > good.sql</strong></em></p><p><em><strong>sqlite3.exe -init good.sql VideoDatabaseV5.db3</strong></em></p><p></p><p>4. Backup your corrupted videodatabase to somewhere and copy repaired one (from C:\SQLRepair) over your corrupted db.</p></blockquote><p></p>
[QUOTE="Deda, post: 1040159, member: 89768"] [COLOR=#ff0000][B]How to check and repair corrupted sqlite database:[/B][/COLOR] 1. Download sqlite3.exe from [url]http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.zip[/url] 2. Copy [B]VideoDatabaseV5.db3[/B] as [B]bad.db[/B] to some folder (ie.[B] C:\SQLRepair[/B]) 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): [I][B]sqlite3 bad.db pragma integrity_check;[/B][/I] 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):: [I][B]echo .dump | sqlite3.exe bad.db > good.sql sqlite3.exe -init good.sql VideoDatabaseV5.db3[/B][/I] 4. Backup your corrupted videodatabase to somewhere and copy repaired one (from C:\SQLRepair) over your corrupted db.[I][B][/B][/I] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Startup time for Mediaportal
Contact us
RSS
Top
Bottom