Android – Pulling SQlite database android device

by

If your device is running Android v4 or above, you can pull app data, including it’s database, without root by using adb backup command, then extract the backup file and access the sqlite database.

First backup app data to your PC via USB cable with the following command, replace app.package.name with the actual package name of the application.

adb backup -f ~/data.ab -noapk app.package.name

This will prompt you to “unlock your device and confirm the backup operation”. Do not provide a password for backup encryption, so you can extract it later. Click on the “Back up my data” button on your device. The screen will display the name of the package you’re backing up, then close by itself upon successful completion.

The resulting data.ab file in your home folder contains application data in android backup format. To extract it use the following command:

dd if=data.ab bs=1 skip=24 | openssl zlib -d | tar -xvf -

If the above ended with openssl:Error: 'zlib' is an invalid command. error, try the below.

dd if=data.ab bs=1 skip=24 | python -c "import zlib,sys;sys.stdout.write(zlib.decompress(sys.stdin.read()))" | tar -xvf -

The result is the apps/app.package.name/ folder containing application data, including sqlite database.

For more details you can check the original blog post.

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. SQlite Getting nearest locations (with latitude and longitude)
  5. Best way to work with dates in Android SQLite [closed]
  6. How can I create a user-defined function in SQLite?
  7. Insert new column into table in sqlite?
  8. How do you enable LIMIT for DELETE in SQLite?
  9. SQLite Schema Information Metadata
  10. How to create custom functions in SQLite
  11. Query to get records based on Radius in SQLite?
  12. Get generated id after insert
  13. How do I create a database in android? [closed]
  14. Android SimpleCursorAdapter doesn’t update when database changes
  15. How to implement Export sqlite To excel/csv file in android?
  16. How to generate all dates between two dates
  17. How to store and retrieve a byte array (image data) to and from a SQLite database?
  18. Does it matter what extension is used for SQLite database files?
  19. SQLite Query in Android to count rows
  20. What is the use of BaseColumns in Android
  21. How do I DROP a constraint from a sqlite (3.6.21) table?
  22. Attempt to reopen an already-closed object sqlitedatabase
  23. Case sensitive and insensitive like in SQLite
  24. How insert image in room persistence library?
  25. android.database.sqlite.SQLiteException: no such column
  26. How to store JSON object in SQLite database
  27. How to display blob value using x’abc’ binary string literal syntax?
  28. Android SQLiteOpenHelper cannot open database file
  29. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment