This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
manual:advanced:map_tools:corrupted_sqlite [2015/09/03 13:11] – mstupka | manual:advanced:map_tools:corrupted_sqlite [2019/01/22 09:18] (current) – mstupka | ||
---|---|---|---|
Line 3: | Line 3: | ||
---- | ---- | ||
- | SQLite databases on Android devices are very stable by definition. However, we have an experience | + | SQLite databases on Android devices are very stable by definition. However, we have experienced |
===== How to ===== | ===== How to ===== | ||
+ | ==== Quick solution for MS Win users ==== | ||
+ | This procedure concerns corrupted //' | ||
+ | - Download **[[http:// | ||
+ | - Copy tracks.db to the unpacked directory | ||
+ | - Run **fix_tracks.bat** | ||
+ | - copy repaired tracks.db to its original place (i.e. to Locus/ | ||
+ | ==== General solution ==== | ||
- | Following steps require working with the command line. | + | Following steps require working with the DOS command line (cmd). |
+ | |||
+ | * Copy corrupted map file (or other sqlite database) from your device to PC | ||
+ | * Download sqlite-tools from [[http:// | ||
+ | * Unpack it and place corrupted database file into the same directory as sqlite3.exe | ||
+ | * Start " | ||
+ | * Run | ||
- | * Copy corrupted map file (sqlite database) from your device to PC | + | < |
- | * Download sqlite-shell from http://www.sqlite.org/download.html | + | </code>to verify database. Result will be probably error message Error: |
- | * Unpack it and place corrupted | + | |
- | * Start cmd and navigate to the directory with map file | + | |
* Run | * Run | ||
- | echo .dump | sqlite3.exe name_of_map.sqlitedb | + | < |
+ | </code> | ||
+ | * If you repeat above integrity check on a new.db file, you should get " | ||
+ | * 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/ | ||
- | * and then | + | For example: |
+ | {{ : | ||
- | sqlite3.exe -init name_of_map_dump.sql name_of_map_fixed.sqlitedb | + | <WRAP important round> However, this procedure is not always successful. The easiest and most reliable way is to restore the database file from the backup. </ |
- | * Try to import the fixed map |