Questions tagged [sqlite]

SQLite is a relational database management system (RDBMS). Instead of running a server process, SQLite databases are directly accessed by running the 'sqlite' binary.

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
269 views

Android Music Player - Does the default “Music Player” program store the timestamp of when a song was last played?

I have a question about the recently played items in the Android (specifically v4.2.2) media library. Does the default "Music Player" program store the timestamp of when a song was last played? Or ...
2
votes
0answers
1k views

Batch script use sqlite3 to edit settings.db

I want to create batch script to enable hidden languages in a Huawei phone. But every time I stuck can you guys spot where is my problem @echo off color e cd "%~dp0" mode con:cols=90 lines=40 adb ...
2
votes
0answers
831 views

Where is the data for S Health stored?

I'm making a personal fitness tracker but I want to grab the days for sleep and heartbeat that gets stored on s health. Where is this stored in the filesystem (maybe an SQL lite db)?
2
votes
0answers
799 views

Can Not Open mmssms.db

I have taken a copy of the mmssms.db from the /data/data/com.android.providers.telephony/databases/ I am trying to open this in sqliteman, but the database does not want to load in, I have taken ...
2
votes
0answers
894 views

Rooted Phone's data folder now empty

I used to see all the dbs in File Explorer , now all of a sudden the data folder is empty, What could have happened? Phone: Motorola Droid X (original). I have been debugging rigorously, the only ...
1
vote
0answers
102 views

Can't access Gmail Inbox trough Sqlite3, mailstore.email@gmail.db doesn't exist Android nougat

I used this to get all emails on inbox (on android shell or through tasker running a shell command): sqlite3 /data/data/com.google.android.gm/databases/mailstore.YOUREMAIL@gmail.com.db "SELECT ...
1
vote
0answers
293 views

How to extract files from Huawei backups to SD card

I've backed up my Huawei P9 lite to the SD Card using the native backup app provided by Huawei. It backs up each APK and along side each a sqlite DB file that seems to contain all of the files that ...
1
vote
0answers
591 views

Is it impossible to pull a database file from non debuggable app in a non rooted device?

Here's what I tried: adb shell "run-as my.package ..." doesn't work because the app was installed without the android:debuggable option. adb backup doesn't work (it produces an empty file) I can't ...
1
vote
0answers
1k views

Can't recover my .db files

I did a backup before reseting my phone. I've got two .db files (contacts & text messages); I really want to put them back into my phone but when I try to open them it says "unable to open". How ...
1
vote
0answers
368 views

GTab with access denied to all app databases

I have a brand new GTAB (Android) that was working fine but suddenly, give a reboot while I was using anMoney, a very good application of financial organization. Until anything I'd like to observe ...
0
votes
0answers
78 views

msgstore.db nightmare on my WhatsApp

I have a 780 MB msgstore.db WhatsApp file that I recovered when my phone data was corrupted ( from the available image - data recovery software). now the issue is that I have the UN encrypted ...
0
votes
1answer
1k views

android thinks accounts.db is corrupted and deletes it

After a reboot, i lost all my accounts. i looked into the logcat and got: 04-02 11:54:01.535 5305 8068 E SQLiteLog: (11) statement aborts at 24: [SELECT key, value FROM extras WHERE accounts_id=(...
0
votes
1answer
227 views

Can you execute sqlite3 outside xbin directory?

When sqlite3 is installed you can execute the binary e.g. via a terminal emulator. If sqlite3 is not installed per default and you do not want to root the phone to install it, is there any ...
-1
votes
1answer
938 views

2016 Colornote saving manual backup in .doc format

Hello I saw in another post from this site that I could open the colornote.db file that was stored here: /data/data/com.socialnmobile.dictapps.notepad.color.note/databases/ with a db sqlite browser. ...