How to pull SQLite database file from Android device(rooted)

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.

How to pull SQLite database file from Android device

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

How to pull SQLite database file from Android device

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s