sqlite3: not found

Question

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?

Solution 1

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.

1. Start the emulator and use the adb command from the platform-tools in android-sdk

   adb pull /system/xbin/sqlite3

2. Mount the system partition of your device read/write after this tutorial:

   http://android-tricks.blogspot.com/2009/01/mount-filesystem-read-write.html

3. 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"

Solution 2

1. Go to Play store --> search for Titanium Backup & install it
2. adb shell
3. su
4. cp /data/data/com.keramidas.TitaniumBackup/files/sqlite3 /system/xbin/
5. cd /system/xbin/
6. chmod 755 sqlite3
7. adbd reboot (just in case)
8. Enjoy the result