User Tools

Site Tools


manual:advanced:map_tools:corrupted_sqlite

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
manual:advanced:map_tools:corrupted_sqlite [2019/01/22 09:11] – [Quick solution for MS Win users] mstupkamanual:advanced:map_tools:corrupted_sqlite [2022/08/23 08:29] (current) menion
Line 25: Line 25:
   * Run   * Run
  
-<code>>sqlite3 filename.db ".dump" | sqlite3 new.db+<code>>sqlite3.exe filename.db ".dump" | sqlite3 new.db
 </code> </code>
   * If you repeat above integrity check on a new.db file, you should get "OK" message.   * If you repeat above integrity check on a new.db file, you should get "OK" message.
   * Rename new.db file to the original name of your file and copy it to its original place (i.e. copy fixed tracks.db or waypoints.db to Locus/data/database folder)   * Rename new.db file to the original name of your file and copy it to its original place (i.e. copy fixed tracks.db or waypoints.db to Locus/data/database folder)
 +
 +In case, above command failed, try alternative
 +<code>>sqlite3.exe filename.db ".recover" | sqlite3 new.db</code>
  
 For example: For example:
manual/advanced/map_tools/corrupted_sqlite.1548144709.txt.gz · Last modified: 2019/01/22 10:11 (external edit)