"sqlite3 not found"

最新推荐文章于 2016-05-06 14:10:32 发布

程序员小梦

最新推荐文章于 2016-05-06 14:10:32 发布

阅读量569

点赞数

文章标签： sqlite3 sqlite3 not found android sqlite android 开发

5 篇文章 0 订阅

订阅专栏

在android开发时，使用adb shell 进行sqlite调试，出现“sqlite3 not found”错误信息。原因是手机里面/system/xbin/目录下没有sqlite3。从模拟器中pull一个出来，再push到手机中。具体方法如下：

原文：http://stackoverflow.com/questions/3645319/why-do-i-get-a-sqlite3-not-found-error-on-a-rooted-nexus-one-when-i-try-to-op

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.4Enter ".help" for instructions
 sqlite> .tablesandroid_metadata  lulz

You can always pull sqlite3 binary from emulator:

Start an emulator and then from a terminal

$ adb pull /system/xbin/sqlite3

关注

专栏目录