sqlite3: not found
adb, android, sqlite
Solution
Some manufacturers deliver the devices without sqlite being installed on them. You can copy the sqlite program though from a emulator to your device if the device has an arm processor.
Start the emulator and use the `adb` command from the `platform-tools` in android-sdk
`adb pull /system/xbin/sqlite3`
Mount the system partition of your device read/write after this tutorial:
http://android-tricks.blogspot.com/2009/01/mount-filesystem-read-write.html
Use the `adb` command to copy the sqlite3 file to your device
`adb push sqlite3 /system/xbin/`
After you reboot your device the `sqlite3` command should work.
Edit (copy from linked page - in the case link becomes invalid). The instructions for step 2 are:
adb shell
su
mount -o rw,remount -t yaffs2 /dev/block/mtdblock3 /system
"Replace /dev/block/mtdblock3 & /system with appropriate device path and mount point, as obtained from cat /proc/mounts"
Problem
I am trying to reach the sqlite database on my device using the procedure described here: How can i see SQLite Database (No emulator)? However, I keep on getting sqlite3 not found. I assume I am meant to be entering the commands with the hash (#) sign at the start of the line. I tried with it and got nothing. Without it I get the error message. The sqlite3.exe file is definitely there and in the path. Do I have to install something?