Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?

by

As an alternative (may not be secure or even good idea though) you can always upload the sqlite3 binary to /system/bin this worked for me:

First lets mount /system/ to allow read/write (rw)

$ adb shell
$ su
# mount -o remount,rw /system

in another terminal change directory (cd) to where sqlite3 is and lets push it

$ ls
sqlite3
$ adb push sqlite3 /sdcard/

Now back to the other shell lets copy and change permissions of the binary

# cat /sdcard/sqlite3 > /system/bin/sqlite3
# chmod 4755 /system/bin/sqlite3

Now lets mount back /system/ as read only (ro)

# mount -o remount,ro /system

And now we can use sqlite3 from shell:

# sqlite3 /data/data/com.telly/databases/fun.db
SQLite version 3.7.4
Enter ".help" for instructions
sqlite> .tables
android_metadata  lulz

Note: I’m using the sqlite3 binary that comes with “SuperOneClickv1.6.5-ShortFuse”

You can always pull sqlite3 binary from emulator:

Start an emulator and then from a terminal

$ adb pull /system/xbin/sqlite3

If you are lazy like me you can download one right here for ICS or before or for Jelly Bean and later here

Make sure to use the proper one for your Android version as you may get eloc_library[1306]: 14446 cannot locate 'sqlite3_enable_load_extension'... or similar errors on execute

More Related Contents:

  1. How do I view the SQLite database on an Android device? [duplicate]
  2. How to use ADB Shell when Multiple Devices are connected? Fails with “error: more than one device and emulator”
  3. What’s the Android ADB shell “dumpsys” tool and what are its benefits?
  4. Understanding command through adb shell and through code – Android
  5. Debugging sqlite database on the device
  6. Where to find info on Android’s “service call” shell command?
  7. adb remount permission denied, but able to access super user in shell — android
  8. How to turn off Wifi via ADB?
  9. Copying files in ADB shell with run-as
  10. Android ADB commands to get the device properties
  11. How to check database on not rooted android device
  12. Launch a script as root through ADB
  13. sqlite3: not found
  14. shell/ batch scripting to direct commands to adb shell
  15. How to measure time from adb shell with milliseconds resolution?
  16. adb shell su works but adb root does not
  17. I am getting this error on my code [closed]
  18. Sqlite for Android
  19. How can I avoid concurrency problems when using SQLite on Android?
  20. Best way to work with dates in Android SQLite [closed]
  21. Eclipse error “ADB server didn’t ACK, failed to start daemon”
  22. How to resolve “Waiting for Debugger” message?
  23. unable to execute adb in Ubuntu. Downloaded file is meant for x86-64 while I have i686 [duplicate]
  24. How to implement Export sqlite To excel/csv file in android?
  25. How to store and retrieve a byte array (image data) to and from a SQLite database?
  26. SQLite Query in Android to count rows
  27. Attempt to reopen an already-closed object sqlitedatabase
  28. How to run a specific Android app using Terminal? [duplicate]
  29. How to store JSON object in SQLite database
  30. Android SQLiteOpenHelper cannot open database file

Leave a Comment