CODEWITHSUNDEEP
androidandroid-studioandroid-emulatorandroid-device-monitor
Fattie
Fattie

Reputation: 12353

Mac, Android Studio, Emulator, SQLite database - actually find directory?

I am using Android Studio on a Mac, everything on the latest version. Say I do this:

SQLiteDatabase db;
db = yourAppContext.openOrCreateDatabase("db.sqlite3", Context.MODE_PRIVATE, null);

Thanks to this link:

http://www.c-sharpcorner.com/UploadFile/e14021/know-where-database-is-stored-in-android-studio/

it's possible to exactly find the directory holding your actual SQLite3 database on the emulator as it runs:

enter image description here

Great stuff.

Next you can click the Pull button, and pull that file to say your desktop on the Mac. Awesome.

But, how do you actually find literally that folder ("databases" in the example), on your Mac?

i.e., using a normal shell terminal, I want to "cd" to there.

Where is that folder, in the ordinary 'nix file structure of the host Mac computer?

Upvotes: 5

Views: 6366

Answers (2)

l'L'l
l'L'l

Reputation: 47274

adb (Android Debug Bridge) is needed to access an emulator device's filesystem via the command-line . If you don't already have it installed you can download it here.

Once installed it's just a matter of using a few commands to view/access the files:

  1. Open Terminal.app.
  2. Execute adb devices (this should list your current emulator devices).
  3. Connect to the emulator device with adb shell .
  4. Change directory cd to the folder where your app databases are.
  5. Type ls to see which database files are present.

In Terminal it would look something like this:

List the emulator devices:

$ adb devices
List of devices attached
emulator-5554  device

Connect to device with adb shell:

$ adb -s emulator-5554 shell

Change directory (cd) into it's SQLite3 database location (package name is usually com...):

adb shell
$ cd /data/data/<your app package name>/databases/

List the files in the databases directory:

adb shell
$ ls
db.sqlite3

That's really the basics of it! It's also possible to push/pull to copy files from the emulator (remote) to your (local) filesystem:

adb pull /data/data/com.yourpackagename.app/databases/db.sqlite3 /local/save/path

If Permission is denied run ADB in root mode:

adb root

More information:

Upvotes: 13

Abdullah Raza
Abdullah Raza

Reputation: 600

or you can pull databases using this command

adb pull /data/data/com.application/databases/ for example adb pull /data/data/com.zameen.propforce/databases/

secondly that folder is not accessible unless your device is rooted or you are using emulator

if your device is rooted. you get super user access by adb su command then you can go to this directory

Upvotes: 2

Related Questions