Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
103 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: ...
1
vote
1answer
251 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 ...
1
vote
0answers
94 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
203 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 ...
2
votes
1answer
495 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 - ...
0
votes
2answers
844 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 ...
1
vote
0answers
482 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 ...
0
votes
1answer
964 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=(...
1
vote
2answers
3k 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 ...
-1
votes
1answer
738 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. ...
2
votes
0answers
909 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
1answer
33 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 !
1
vote
3answers
853 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 ...
1
vote
2answers
11k 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 ...
0
votes
1answer
2k 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 ...
1
vote
1answer
2k 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 ...
3
votes
0answers
259 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 ...
4
votes
1answer
19k 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 ...
0
votes
1answer
209 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 ...
2
votes
0answers
826 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)?
3
votes
2answers
11k 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....
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 ...
2
votes
1answer
2k 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 $...
1
vote
0answers
363 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 ...
2
votes
0answers
796 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 ...
1
vote
1answer
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 ...
23
votes
1answer
19k 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 ...
4
votes
2answers
3k 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 ...
8
votes
2answers
3k 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 ...
2
votes
0answers
890 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 ...
0
votes
1answer
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 ...
18
votes
4answers
28k 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 ...
16
votes
9answers
16k 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 ...