SQLite database is the default database used by Android Applications for local Storage. Learn2Crack shows you a easy way to pull SQLite database from a Android Device and edit it in your PC. Just follow the steps given below.

Requirements:

1.Android SDK: Download and extract Android SDK bundle from this link.
2.Android Device should be rooted.

Steps to Pull Database File:

1.In your Android device Turn On USB Debugging. (For Android 4.2 and more select  About Phone in Settings. And scroll down till you see Build number. Tap on the “Build Number” button about 7 times. Now you can see Developer Options in Settings.)

2.Connect your Android Device with your PC.

3.It shows a dialog to Allow USB Debugging. Select OK.

4. Now move to the extracted SDK folder /sdk/platform-tools/ using file explorer.

6.Select File->Open Command Prompt within the platform-tools folder.

7. Type adb -d shell .You will be landed in Android Shell.

8.Then type su. You will get root Privileges

9.Now type the command in terminal. Replace <Package Name> with your Recquired app’s package name. Replace “mydatabase” with database of the App.

cat /data/data/<Package Name>/databases/mydatabase > /sdcard/mydatabase

Here I am copying the Database of Android MMS App as

cat /data/data/com.android.mms/databases/message_templates.db > /sdcard/mydatabase.db

Using ADB to Pull Database.

10. Now the database will be stored in the root of your SD card. Copy to your PC.

To Edit the Database.

1.Download SQLite Browser from this link and extract it.

2. Open the Copied SQLite Database file with the SQLite Browser and then edit it.

Editing Database in SQLite Browser.

Enjoy 🙂
Any questions comment here.

• Bio
• Twitter
• Google+
• LinkedIn
• Latest Posts

Raj Amal

Developer at Learn2Crack

Raj Amal is an Android Developer. He Loves to code and explores new technologies. He also authored a book Learning Android Google Maps

@rajamalw

+Raj Amal

Latest posts by Raj Amal (see all)

• Android working with Retrofit and RxJava in Kotlin - November 23, 2017
• Getting Started with Android Development in Kotlin - November 23, 2017
• Android Upload Image using Retrofit #2 - August 8, 2017