25

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?

Improve this question
1

3 Answers 3

Reset to default
37

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"

Improve this answer
Sign up to request clarification or add additional context in comments.

11 Comments

Tried this but the pull command fails because it can't find the sqlite3 file. It's not in xbin. Where can I find it?
please make sure, that the physical device is not connected and your emulator is running when executing the adb pull!
I'm still doing something wrong. I did cat /proc/mounts and from the line "/dev/block/stl9 /system" I took the values. I then entered "mount -o remount,rw -t yaffs2 /dev/block/st19 /system". How do I now copy? I tried from within the adb shell but it won't accept he command. When I exit the shell and then enter the command it claims it is read-only.
Maybe you could copy the sqlite3 file to the sd-card first with the push command. Afterwards you go to the adb shell, enter su and then something like: mv /mnt/sdcard/sqlite3 /system/xbin
Ok. So I maanaged to push to /mnt/sdcard. Now when I eneter adb shell and try "su" it doesn't recognise the command.
|
7
  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
Improve this answer

Comments

0

For those who, like me, couldn't use Sqlite3, I used a workaround for this:

cat srcfile> / mnt / sdcard / dstfile

With this you can put the files into an external .db manager.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.