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 [2017/07/25 13:25] – [Quick solution for MS Win users] mstupkamanual:advanced:map_tools:corrupted_sqlite [2022/08/23 08:29] (current) menion
Line 7: Line 7:
 ==== Quick solution for MS Win users ==== ==== Quick solution for MS Win users ====
 This procedure concerns corrupted //'tracks.db'// file that you can find in your Locus directory //Locus/data/database//: This procedure concerns corrupted //'tracks.db'// file that you can find in your Locus directory //Locus/data/database//:
-  - Download **[[http://nas.asamm.com:8080/share.cgi?ssid=04tjsoL|this .ZIP file]]** and unpack it+  - Download **[[http://storage.asamm.com/locus/data/various/SQLite_tools.zip|this .ZIP file]]** and unpack it
   - Copy tracks.db to the unpacked directory   - Copy tracks.db to the unpacked directory
   - Run **fix_tracks.bat**   - Run **fix_tracks.bat**
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.1500981908.txt.gz · Last modified: 2017/07/25 14:25 (external edit)