Where does Android emulator store SQLite database?

Question

Hi folks,

I'm working on an Android application that stores data in a SQLite database. My question is, where does this database file get stored on the filesystem when you're using an emulator?

I have seen that it's stored in

/data/data/package_name/databases

but I need to know where on my local machine's hard drive that actually maps to. The database persists on multiple runs of the emulator, even after having shut down the machine, so it can't just reside in RAM...

Answer 1

The filesystem of the emulator doesn't map to a directory on your hard drive. The emulator's disk image is stored as an image file, which you can manage through either Eclipse (look for the G1-looking icon in the toolbar), or through the emulator binary itself (run "emulator -help" for a description of options).

You're best off using adb from the command line to jack into a running emulator. If you can get the specific directory and filename, you can do an "adb pull" to get the database file off of the emulator and onto your regular hard drive (this applies to a real device too, even if you have non-root permissions and "ls" isn't showing you anything).

Answer 2

You have to be on the DDMS perspective on your Eclipse IDE (Windows > Open Perspective > Other > DDMS), and, the most important, YOUR APPLICATION MUST BE RUNNING SO YOU CAN SEE THE HIERARCHY OF FOLDERS AND FILES. Then you will follow the path data > data > your-package-name > databases > your-database-file.

Check out this link, it explains everything, its on portuguese, but you can translate it on google translator.

http://www.psyhclo.com/?p=89

Answer 3

you can pull /data/data/package_name/databases/databasefile.db from device to your harddisk using DDMS. Then you can use SQLite3 to open and work on that databasefile.db

You can use any Graphic SQLite management tool to work with the databasefile.db on your PC. Create tables, insert, update, delete... After you have done just upload the databasefile.db to device using DDMS again.

If you are interested in developing GPS and routing service for android phones, check our website www.andgps.com

Answer 4

The databases are stored as SQLite files in /data/data/PACKAGE/databases/DATABASEFILE where:

• PACKAGE is the package declared in the AndroidManifest.xml (tag "manifest", attribute "package")
• DATABASEFILE is the name passed when you call the SQLiteOpenHelper constructor as explained here: http://developer.android.com/guide/topics/data/data-storage.html#db

You can see (copy from/to filesystem) the database file in the emulator selecting DDMS perspective, in the File Explorer tab.