Android export SQLite Database to Computer / Mac

Question

I have a SQLite Database on my Android Device (My own App). Now i want to see the SQLite Database on my Computer.

Is there any solution ( easy way ) to get the Database without root rights and without a SD-Card on my Computer?

I tried to google it but i can't find any solution for this problem....

Edit: I'm using not the Emulator ( need the Camera on my Device).

In my opinion there is no way for a non rooted device to get sqlite database from. — Vijay, Mar 31 '16 at 07:30
The easiest way is through Terminal, the complete guide in this link . answer by dheeraj bhaskar. http://stackoverflow.com/questions/18370219/how-to-use-adb-in-android-studio-to-view-an-sqlite-db — HourGlass, Mar 31 '16 at 07:40

score 6 · Answer 1 · answered Mar 31 '16 at 07:44

6

if phone is not rooted you cant access directly your DB, but you can copy it to download folder, then, copy to PC

public static void copyAppDbToDownloadFolder(Activity ctx) throws IOException {
    File backupDB = new File(Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS),
            "databse_name.db"); // for example "my_data_backup.db"
    File currentDB = getApplicationContext().getDatabasePath("databasename.db");
    if (currentDB.exists()) {
        FileChannel src = new FileInputStream(currentDB).getChannel();
        FileChannel dst = new FileOutputStream(backupDB).getChannel();
        dst.transferFrom(src, 0, src.size());
        src.close();
        dst.close();
    }
}

answered Mar 31 '16 at 07:44

khyper

124
1
6

Thanks i'll try it later. If this works, you'll get a +vote – FunkyMan Mar 31 '16 at 07:46
@FunkyMan you can't upvote, yet. But you can mark this answer as accepted. I guess you must wait a couple of days, though. – Phantômaxx Mar 31 '16 at 08:10
facing EAaccess permission denied issue not able to copy – ABDUL RAHMAN Jun 10 '21 at 08:06

score 4 · Accepted Answer · edited Mar 31 '22 at 23:12

4

This method worked for my unrooted device.

# check if your device connected
adb devices

adb shell

run-as  your.package.name

chmod 777 databases/your.database.name

exit

cp /data/data/your.package.name/your.database.name /mnt/sdcard/

exit

adb pull /mnt/sdcard/your.database.name

edited Mar 31 '22 at 23:12

Afriza N. Arief

7,696
5
47
74

answered Mar 31 '16 at 07:43

crashOveride

839
6
12

copy to file folder to accessible to you. do adb shell. cd mnt/ Then ls. And tell me the folder names. I will tell you where to copy the database – crashOveride Mar 31 '16 at 07:46
the folder name on my Computer? – FunkyMan Mar 31 '16 at 07:48
No, folder on your device. Do adb shell, and cd mnt and then ls (it L for london) and tell me the result. – crashOveride Mar 31 '16 at 07:49
Oh okay. I Thought it was a Upper i. I Tell You later, because i'm on work :D – FunkyMan Mar 31 '16 at 07:51
i used the cat command. cp doesn't work. cat /data/data/your.package.name/databases/database.name >/mnt/sdcard/database.sqlite – FunkyMan Apr 03 '16 at 12:31
So could you do it. Was it successful? – crashOveride Apr 03 '16 at 16:00
Ist was successful but Not with the "cp" command. I used the "cat" command. Thank you – FunkyMan Apr 03 '16 at 16:02
when trying to copy the DB to mnt/sdcard it says `permission denied` – Shadman Akhtar Nov 06 '21 at 14:25
Still getting **permission denied** error – IgorGanapolsky Jan 10 '23 at 14:41

score 1 · Answer 3 · answered Mar 31 '16 at 07:36

1

If you are saving Sqlite DB in default location , you can find the same in path like following

/data/data/com.dev.myapplication/databases/mydb.db

You can find the same using Android Device Monitor, through which you can navigate to both internal and external memory.

Once you find the database file, extract the same and save in desktop after connecting through USB cable. You can use option "Pull a file from device"

Once you have extracted file to desktop, use any tools similar to Mozilla Firefox SQLite viewer to view database.

answered Mar 31 '16 at 07:36

Sreehari

5,621
2
25
59

But i need Root rights to get this Database, or not? I've tried this but my "data" folder is empty. – FunkyMan Mar 31 '16 at 07:38
No root rights is required for this. Try to save to some other location and verify. For example your external SD card location and some custom folders. – Sreehari Mar 31 '16 at 07:40
I don't have a SD card...I try to save it to a other location. Thanks. – FunkyMan Mar 31 '16 at 07:43
/data/data is not an accessible directory – IgorGanapolsky Jan 10 '23 at 14:41

Android export SQLite Database to Computer / Mac

3 Answers3