Differences

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

--- manual:advanced:map_tools:corrupted_sqlite [2017/07/25 12:29] – [Quick solution for MS Win users] mstupka
+++ manual:advanced:map_tools:corrupted_sqlite [2022/08/23 08:29] (current) – menion
@@ Line 7: / Line 7: @@
 ==== Quick solution for MS Win users ====
 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
-  - Rename tracks.db to tracks_old.db
+  - Run **fix_tracks.bat**
-  - Run **fix_tracks.bat**
+  - copy repaired tracks.db to its original place (i.e. to Locus/data/database folder)
 ==== General solution ====
@@ Line 25: / Line 25: @@
   * Run
-<code>>sqlite3 filename.db ".dump" | sqlite3 new.db
+<code>>sqlite3.exe filename.db ".dump" | sqlite3 new.db
 </code>
   * 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)
+In case, above command failed, try alternative
+<code>>sqlite3.exe filename.db ".recover" | sqlite3 new.db</code>
 For example:

knowledge base