sqlite3 - MyMoneyTracker dump file content at Android os -

sqlite3 - MyMoneyTracker dump file content at Android os -

nice see you!

mymoneytracker backup database (dump) file has specific encoding, suppose. it's sqlite3 dump file. in difference regular text dump file has lot of "^@" , other "^" symbols "^g" or "^h".

is possible create(generate) similar file standalone sqlite3 on machine utilize backup within mymoneytracker? in other words, substitute 1 own data.

first string dump file:

sqlite format 3^@^p^@^a^a^@@ ^@^@^@<8a>^@^@^@^p^@^@^@^@^@^@^@^@^@^@^@^n^@^@^@^d^@^@^@^@^@^@^@^p^@^@^@^a^@^@^@^k^@^@^@^@^@^@^@^@^@^@^@^@ ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@<8a>^@-т#^m Ќ^@^n^e^y^@^oЇ^nк^n<88>^lф^l^q^k(

one string dump file:

create table budgets(_id integer primary key autoincrement,budgetname text not null,opendate integer not null,closedate integer not null , currencyid int null)<81>^k^n^g^w^[^[^a<81>mtablehistoryhistory^pcreate table history (_id integer primary key autoincrement,actiondate integer not null, sqlquery text not null)<81>z^m^g^w^u^u^a<83>^wtabledebtdebt^ocreate table debt (_id integer primary key autoincrement ,whom text not null,type integer not null, accountid integer not null, initialballance real not null,date integer not null,comments not null)<81>^w^l^g^w;;^a<81>etableaccountcurrecyassigmentaccountcurrecyassigment^ncreate table accountcurrecyassigment (accountid integer n ot null,currecyid integer not null)<81>%^k^g^w%%^a<82>^mtableexcangeratesexcangerates^mcreate table excangerates (sourcecurrecyid intege r not null,destinationcurrencyid integer not null, exchanagerate real not null)<81>^v

that file database file, re-create of actual database.

you can open tool supports sqlite3 databases, such sqlite3 command-line shell, or sqlite manager.

android sqlite3 dump database-dump