https://grasswiki.osgeo.org/w/index.php?action=history&feed=atom&title=Sqlite_malformed_database 2026-05-10T00:11:28Z Revision history for this page on the wiki MediaWiki 1.41.0 https://grasswiki.osgeo.org/w/index.php?title=Sqlite_malformed_database&diff=23225&oldid=prev 2016-07-02T10:20:19Z

<p>+<a href="/wiki/Category:FAQ" title="Category:FAQ">Category:FAQ</a></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 10:20, 2 July 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l26">Line 26:</td> <td colspan="2" class="diff-lineno">Line 26:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>sqlite&gt; .read dump_all.sql</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>sqlite&gt; .read dump_all.sql</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:FAQ]]</ins></div></td></tr> <!-- diff cache key grass_wiki:diff:1.41:old-23219:rev-23225:php=table --> </table>

Neteler https://grasswiki.osgeo.org/w/index.php?title=Sqlite_malformed_database&diff=23219&oldid=prev 2016-06-30T10:11:08Z

<p>create page how to restore malformed sqlite database</p> <p><b>New page</b></p><div>Sometimes can happen to get this error using vector data<br /> <br /> &lt;pre&gt;<br /> DBMI-SQLite driver error:<br /> Error in sqlite3_step():<br /> database disk image is malformed<br /> <br /> DBMI-SQLite driver error:<br /> Error in sqlite3_step():<br /> database disk image is malformed<br /> &lt;/pre&gt;<br /> <br /> To solve this you can only recreate the database in a new one.<br /> <br /> You have to move in the directory of SQLite database inside your GRASSDATA/LOCATION/MAPSET/sqlite, access sqlite.db and run<br /> <br /> &lt;pre&gt;<br /> sqlite&gt; .mode insert<br /> sqlite&gt; .output dump_all.sql<br /> sqlite&gt; .dump<br /> &lt;/pre&gt;<br /> <br /> Now you have to rename sqlite.db to something else (e.g. sqlite.db.old). Create a new empty database called sqlite.db, access it and run<br /> <br /> &lt;pre&gt;<br /> sqlite&gt; .read dump_all.sql<br /> &lt;/pre&gt;</div>

Lucadelu