Help restore db tracks and points

thanks for the answer. automatically saved configuration only. I have 5 files with the settings. a manual backup saves and points and tracks and settings.

Petr, I have a 5 * .zip with automatic backup. They contain only settings. Tracks and points I lost.

tracks.db - 31Mb tracks2.db - 12Kb

waypoints.DB - 1700Kb waypoints2.DB - 10Kb

D:\111>sqlite3 tracks.db ".dump" | sqlite3 tracks2.db

Error: near line 3: table android_metadata already exists

Error: near line 5: table categories already exists

Error: near line 6: UNIQUE constraint failed: categories._id

Error: near line 7: UNIQUE constraint failed: categories._id

Error: near line 8: UNIQUE constraint failed: categories._id

Error: near line 9: UNIQUE constraint failed: categories._id

Error: near line 10: UNIQUE constraint failed: categories._id

Error: near line 11: UNIQUE constraint failed: categories._id

Error: near line 12: UNIQUE constraint failed: categories._id

Error: near line 13: UNIQUE constraint failed: categories._id

Error: near line 14: UNIQUE constraint failed: categories._id

Error: near line 15: table tracks already exists

Error: near line 18: table locations already exists

Error: near line 21: table folder_group already exists

Error: near line 28: index locations_parent_id already exists

D:\111>sqlite3 waypoints.DB ".dump" | sqlite3 waypoints2.DB

Error: near line 3: table android_metadata already exists

Error: near line 5: table categories already exists

Error: near line 6: UNIQUE constraint failed: categories._id

Error: near line 7: UNIQUE constraint failed: categories._id

Error: near line 8: UNIQUE constraint failed: categories._id

Error: near line 9: UNIQUE constraint failed: categories._id

Error: near line 10: UNIQUE constraint failed: categories._id

Error: near line 11: UNIQUE constraint failed: categories._id

Error: near line 12: UNIQUE constraint failed: categories._id

Error: near line 13: UNIQUE constraint failed: categories._id

Error: near line 14: UNIQUE constraint failed: categories._id

Error: near line 15: UNIQUE constraint failed: categories._id

Error: near line 16: UNIQUE constraint failed: categories._id

Error: near line 17: UNIQUE constraint failed: categories._id

Error: near line 18: UNIQUE constraint failed: categories._id

Error: near line 19: UNIQUE constraint failed: categories._id

Error: near line 20: UNIQUE constraint failed: categories._id

Error: near line 21: UNIQUE constraint failed: categories._id

Error: near line 22: UNIQUE constraint failed: categories._id

Error: near line 23: UNIQUE constraint failed: categories._id

Error: near line 24: UNIQUE constraint failed: categories._id

Error: near

line 25: UNIQUE constraint failed: categories._id

Error: near line 26: UNIQUE constraint failed: categories._id

Error: near line 27: table waypoints already exists

Error: near line 30: table folder_group already exists

Error: near line 37: index waypoints_id already exists

Error: near line 38: index waypoints_query_exists already exists

sqlite> .fullschema

CREATE TABLE android_metadata (locale TEXT);

CREATE TABLE categories (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT,icon TEXT,extra_style BYTE, group_id INTEGER, labels_mode INTEGER);

CREATE TABLE tracks (_id INTEGER PRIMARY KEY AUTOINCREMENT, parent_id INTEGER, name STRING, breaks BYTE, extra_data BYTE, extra_style BYTE, use_category_style INTEGER,num_points INTEGER, start_time INTEGER, stop_time INTEGER, total_length FLOAT, total_length_move FLOAT, total_time INTEGER, total_time_move INTEGER, speed_max FLOAT, altitude_min FLOAT, altitude_max FLOAT, ele_neutral_distance FLOAT, ele_neutral_height FLOAT, ele_positive_distance FLOAT, ele_positive_height FLOAT, ele_negative_distance FLOAT, ele_negative_height FLOAT, ele_total_abs_distance FLOAT, ele_total_abs_height FLOAT, overview_image BYTE);

CREATE TABLE locations (_id INTEGER PRIMARY KEY AUTOINCREMENT, provider TEXT, longitude FLOAT, latitude FLOAT, time INTEGER, elevation FLOAT, speed FLOAT, bearing FLOAT, accuracy FLOAT, parent_id INTEGER, previous_id INTEGER, sensor_heart_rate INTEGER, sensor_cadence INTEGER, sensor_speed FLOAT, sensor_power FLOAT, sensor_strides INTEGER, sensor_battery INTEGER, sensor_temperature FLOAT); CREATE INDEX locations_parent_id ON locations (parent_id);

CREATE TABLE folder_group (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);

/* No STAT tables available */

sqlite>

sqlite> .dbinfo

database page

size: 4096

write format: 1

read format: 1

reserved bytes: 0

file change counter:

1702

database page count:

7995

freelist page count: 0

schema cookie: 10

schema format: 4

default cache

size: 0

autovacuum top root: 9

incremental

vacuum: 0

text encoding: 1 (utf8)

user version: 9

application id: 0

software version: 3007011

number of tables: 6

number of

indexes: 1

number of

triggers: 0

number of views: 0

schema size: 1361

sqlite> .header on

sqlite> .mode csv

sqlite> .once d:\111\out_tracks.csv

sqlite> select * from tracks;

Error: database disk image is malformed

sqlite>

Thank you for helping,

I am not strong in databases

Source

files

Wp and tracks

https://drive.google.com/file/d/0B-6HAtAtH1KOeV8xWkZ6RlhRSm8/view?usp=docslist_api

32mb

Peter, thank you very much.

I am trying to rebuild different programs with sd-card files.

As long as the same result

OK... and sorry for that.

if it can be done in the locus pro automatic backup points and tracks with loading on google cloud.

Unfortunately Locus doesn't offer such feature. But there are some synchronization apps that can automatically backup custom folder into cloud. Please check for example the app https://play.google.com/store/apps/details?id=dk.tacit.android.foldersync.lite