Table of Contents

Corrupted SQLite Database Repair


SQLite databases on Android devices are very stable by definition. However, we have experienced that databases can be corrupted. This may be due to wrong closing the database or killing Locus app. The result is that Locus Map is not able to open the database file or the file deletes itself - this concerns both map files and points/track databases, all are SQLites. Luckily sometimes it is possible to repair such a corrupted database.

How to

Quick solution for MS Win users

This procedure concerns corrupted 'tracks.db' file that you can find in your Locus directory Locus/data/database:

  1. Download this .ZIP file and unpack it
  2. Copy tracks.db to the unpacked directory
  3. Run fix_tracks.bat
  4. copy repaired tracks.db to its original place (i.e. to Locus/data/database folder)

General solution

Following steps require working with the DOS command line (cmd).

>sqlite3.exe filename.db "PRAGMA integrity_check"

to verify database. Result will be probably error message Error: database disk is malformed.

>sqlite3.exe filename.db ".dump" | sqlite3 new.db

In case, above command failed, try alternative

>sqlite3.exe filename.db ".recover" | sqlite3 new.db

For example:

However, this procedure is not always successful. The easiest and most reliable way is to restore the database file from the backup.