This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
manual:advanced:map_tools:corrupted_sqlite [2015/05/15 06:58] – created mstupka | manual:advanced:map_tools:corrupted_sqlite [2015/11/06 10:04] – [How to] mstupka | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | ====== |
- | Sqlite | + | ---- |
+ | |||
+ | SQLite | ||
===== How to ===== | ===== How to ===== | ||
Line 7: | Line 9: | ||
Following steps require working with the command line. | Following steps require working with the command line. | ||
- | * Copy corrupted map file (sqlite database) from your device to PC | + | * Copy corrupted map file (or other sqlite database) from your device to PC |
- | * Download sqlite-shell http:// | + | * Download sqlite-shell |
* Unpack it and place corrupted database file into the same directory as sqlite3.exe | * Unpack it and place corrupted database file into the same directory as sqlite3.exe | ||
- | * Start cmd and navigate to the directory with map file | + | * Start cmd and navigate to the directory with the corrupted |
* Run | * Run | ||
- | | + | |
- | + | ||
- | * and then | + | |
- | + | ||
- | sqlite3.exe -init name_of_map_dump.sql name_of_map_fixed.sqlitedb | + | |
- | * Try import fixed map | + | * Try to import |
+ | <WRAP important round> | ||
+ | However, this is not always possible. The easiest and most reliable way is to restore the database file from the backup. | ||
+ | </ |