Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

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. Note that development questions are off-topic.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 views

Which process floods my logs with SQLite migration error and how can I cure it?

Phone: Xiaomi Mi Max 3, MIUI 11, Android 10. Using a custom ROM from xiaomi.eu. The start of the flood is captured in LogCat, it happens every single millisecond, and I'm suspecting some system ...
Csaba Toth's user avatar
0 votes
0 answers
54 views

Where does termux sqlite db files be stored?

There was other questions like this but no answer for this. Where is the path to find my sqlite files? I have Xiaomi Redmi 10 android. And with termux installed SQLite and i was going to start ...
C9_HP's user avatar
  • 31
0 votes
0 answers
25 views

Where is the path to to the Google Chrome sqlite database on Android? [duplicate]

It seems like the known methods for copying open tabs out of Android Chrome no longer work (a debug interface was removed) and I'd like to see if I can squeeze the open tabs from the sqlite database. ...
merlin2011's user avatar
1 vote
1 answer
2k views

"Could not launch inspector studio.network.inspection" when using App Inspector on Android Studio Bumblebee 2021.1.1.1 with WiFi pairing

When we use a "pair device using WiFi" in Android Studio Bumblebee version 2021.1.1, in the "App Inspection" section, it gives us an error in reading the "Database". ...
Pouria Hemi's user avatar
0 votes
0 answers
22 views

SMS text messages on Huawei p smart 2017 [duplicate]

How do I recover SMS that have been deleted from my phone? I have phone of brand Huawei p smart 2017.
Kennian Fnug Bjerregaard's user avatar
1 vote
1 answer
298 views

Recover Draft Emails from Deleted Account

I have a Samsung Galaxy S5 phone and use the native, built-in email app for two corporate/ActiveSync accounts. Recently something went wrong with the settings of one of the accounts, which caused my ...
Luminocity's user avatar
2 votes
0 answers
104 views

My phone is not saving things (screenshots, download from browser, etc)

So one day my phone shutdown and when restarted I started to get some issues. Screenshot was not working saying that there was no space left. Gallery had no images/videos at all. File manager was not ...
Ben's user avatar
  • 21
1 vote
0 answers
85 views

Recovering Deleted SQLite Records on Disk

I'm trying to access the raw screentime data that Android tracks - located in /data/data/com.google.android.apps.wellbeing/databases/app_usage on my OnePlus 7 Pro. My problem is that the database ...
Zacchary D-P's user avatar
1 vote
1 answer
9k views

Merging whatsapp database of two different accounts

So, I have two WhatsApp accounts A and B. A has chat history only till December '19 while B's chat history start from January '20. I want to have one account with mobile number that of A, groups of B ...
Apoorv Goyal's user avatar
1 vote
0 answers
2k 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 ...
user1874594's user avatar
3 votes
1 answer
753 views

Fix "android.process.acore keeps stopping" when the contacts provider can't load it's db

My phone just decided that it should spam an exception onto my screen that reopens as soon as I tap it away. A look at logcat reveals the following being thrown multiple times per second: SQLiteLog: ...
Link64's user avatar
  • 141
1 vote
1 answer
3k views

android.database.sqlite.SQLiteException: Can't downgrade database from version X to Y when running an app

I have problem with TitaniumBackup. I had it installed on my Android tablet which is rooted and using Android 4.4.2. It was working fine, but I had to do factory reset and after that, if I try to ...
user1800997's user avatar
1 vote
0 answers
193 views

Can't access Gmail Inbox trough Sqlite3, [email protected] 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/[email protected] "SELECT ...
kurokirasama's user avatar
3 votes
0 answers
515 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 ...
ChrisJ's user avatar
  • 159
2 votes
1 answer
764 views

High resolution contact pictures in Marshmallow - what is their size and where are they stored

Trying to answer this question How to backup large contact photos?, I wanted to compare the picture size after restore I do see a database for contacts , as mentioned in Narayanan's answer here - ...
beeshyams's user avatar
  • 41.1k
0 votes
2 answers
4k views

Is it possible to recover Google authenticator database

I am using 2 factor authentication through google authenticator and forgot to keep backup for one of the websites (cex.io). When I changed to new phone, I uninstalled Google authenticator from the old ...
Vivek V Dwivedi's user avatar
3 votes
0 answers
2k 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 ...
Rodrigo's user avatar
  • 131
1 vote
1 answer
2k 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=(...
allo's user avatar
  • 395
5 votes
2 answers
8k views

How can I access veryfit app database on my device?

I have installed VeryFit2.0 app on my mobile.I want to see previous days heart beat data but there is no option.Is there are way by which I can get in to the database of the app as I know its an ...
2FaceMan's user avatar
  • 243
2 votes
0 answers
2k 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 ...
DREAMER's user avatar
  • 21
-2 votes
1 answer
47 views

Unable to launch sqlite3 in my sumsung phone

I have put the libncurses.so and sqlite3 in the /xbin , but it seems unable to load the library "libncurse.so". waiting for help !
Vincent_Bryan's user avatar
1 vote
3 answers
2k views

Where are Androids’ developer options stored?

Can anyone please tell me, where Androids’ developer options are stored? I’m trying to modify the Pointer Location developer option in this file. After recompiling Android, where is the file ...
fooness's user avatar
  • 11
2 votes
2 answers
16k views

How to convert/encrypt WhatsApp .sqlite to .db.crypt8?

I have aa WhatsApp ChatStorage.sqlite file which was taken from an iPhone backup, and I don't exactly understand the structure of the data inside the database, but it's clearly not encrypted. I want ...
Charles's user avatar
  • 33
0 votes
1 answer
3k views

Can't find webview.db file for android browser to view saved passwords in internet app

I can't find this file anywhere. Can anyone advise where this might be stored? I downloaded SQLITE editor on my note 3 but it says no database. When I see the internet icon under Apps in SQLite Editor ...
Androidgrl's user avatar
1 vote
2 answers
6k views

SQLite database operation from Android terminal

I want to do SQLite command like sqlite3 myDb.db, or do other SQLite command from Android shell, like Terminal Emulator or something else. I have tried googling for these, but no luck. Is it possible ...
ian cikal's user avatar
3 votes
0 answers
431 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 ...
user avatar
4 votes
1 answer
23k views

Merging a Crypt7 and a Crypt8 whatsapp backup

I have been searching a lot in the past couple of weeks on how to merge two whatsapp backup. Last month I got a new phone, installed whatsapp along with my old backup. During installation, whatsapp ...
Mumbai CabinCrew's user avatar
0 votes
1 answer
254 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 ...
user2644908's user avatar
2 votes
0 answers
843 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)?
CR47's user avatar
  • 121
3 votes
2 answers
13k views

Modify settings parameters through database

I have been able to successfully modify and update the settings in the Android phone using ADB commands such as these.. Enable GPRS data: adb shell sqlite3 -batch /data/data/com.android.providers....
Skuma's user avatar
  • 31
1 vote
0 answers
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 ...
titerousse's user avatar
2 votes
1 answer
3k views

Trying to vacuum all databases under /data with sqlite3, but fails with error 14

I would like to vacuum all my database files under /data, to achieve somewhat better performance so I ran the following script: for i in $(find /data -iname "*.db"); do #echo $(basename $i); sqlite3 $...
juniecho's user avatar
  • 163
1 vote
0 answers
376 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 ...
SiriusB's user avatar
  • 11
2 votes
0 answers
861 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 ...
user28912's user avatar
1 vote
1 answer
2k views

open-gpstracker: Export all tracks or access the SQLite database

I am using open-gpstracker to track routes. After quite some time I have collected a large number of tracks that I like to export as GPX files. The application allows to do that, however, there is no ...
JJD's user avatar
  • 237
23 votes
1 answer
21k views

Recover deleted content from userdata partition?

So it came to pass, that Amanda did have a blonde moment and deleted all her threads in the SMS app by mistake. Yeah, "Delete all threads" probably shouldn't be quite so easy to invoke. The phone's ...
Mandy's user avatar
  • 335
4 votes
2 answers
4k views

Transferring messages to android from a sqlite db on my laptop

I am a new android user. I switched from nokia to android today only. Been googling around for various solutions to transfer my sms (text messages only) from my old nokia to my new Android (Galaxy Ace ...
gopi1410's user avatar
  • 203
8 votes
2 answers
4k views

Android apps keep crashing with android.database.sqlite.SQLiteDiskIOException

Starting yesterday, my Galaxy s2 device running Cyanogenmod 9 started to crash with android.database.sqlite.SQLiteDiskIOException exception for every running app. Does it means that my phone is dead ...
Tomer Cohen's user avatar
2 votes
0 answers
924 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 ...
Mike6679's user avatar
  • 151
0 votes
1 answer
1k views

How to extract sqlite file

My Samsung Galaxy S was having an error on the notification bar saying sd card blank or has unsupported file system, so I was required to format my sd card. However, I couldn't format it using the ...
kazain93's user avatar
19 votes
4 answers
43k views

Android Read recent SMS messages from command line

I have recently broken my Android's screen. (Again) Its a T-Mobile G2 Trying to keep up with my busy technology related life is hard enough without losing my link with everyone. I have rooted the ...
The Lazy Coder's user avatar
16 votes
9 answers
18k views

Where can I obtain an SQLite 3 command line binary for Android?

When I read documentation such as examining SQLite 3 databases from a remote shell I get the impression an SQLite command-line binary should exist on my phone. Sadly I can't seem to find it on my ...
fostandy's user avatar
  • 913