How to delete android database from local windows machine


Problem

Where is the android database located in the local Windows system ? How to delete the database manually ? I have made changes to android database structure and the changes are not reflected in the database because the AVD is still using the old database. 

Solution

adb shell
cd /data/data
cd <your.application.java.package>
cd Databases
rm <your db name>

Note: Execute the commands from abd path (e.g C:\Program Files (x86)\Android\android-sdk\platform-tools)

Example Console Output Below:

C:\Program Files (x86)\Android\android-sdk\platform-tools>adb.exe shel
root@android:/ # cd /data/
cd /data/
root@android:/data # ls
ls
anr
app
app-private
backup
dalvik-cache
data
dontpanic
drm
local
lost+found
misc
nativebenchmark
nativetest
property
secure
system
root@android:/data # cd data
cd data
root@android:/data/data # ls
ls
android.tts
com.android.browser
com.android.calculator2
com.android.camera
com.android.certinstaller
com.android.contacts
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.email
com.android.exchange
com.android.fallback
com.android.gallery
com.android.gesture.builder
com.android.htmlviewer
com.android.inputmethod.latin
com.android.inputmethod.pinyin
com.android.launcher
com.android.mms
com.android.music
com.android.netspeed
com.android.packageinstaller
com.android.phone
com.android.protips
com.android.providers.applications
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.drm
com.android.providers.media
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.quicksearchbox
com.android.sdksetup
com.android.settings
com.android.soundrecorder
com.android.spare_parts
com.android.speechrecorder
com.android.systemui
com.android.wallpaper.livepicker
com.android.widgetpreview
com.engrid.app.ts
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.motorola.pgmsystem
com.motorola.programmenu
com.svox.pico
com.test
jp.co.omronsoft.openwnn
root@android:/data/data # cd com.android.providers.contacts
cd com.android.providers.contacts
root@android:/data/data/com.android.providers.contacts # ls
ls
databases
lib
shared_prefs
root@android:/data/data/com.android.providers.contacts # cd databases
cd databases
root@android:/data/data/com.android.providers.contacts/databases # ls
ls
contacts2.db
contacts2.db-journal
root@android:/data/data/com.android.providers.contacts/databases #

No comments:

Post a Comment