如何安装或得到亚行shell访问的sqlite3shell

2023-09-06 01:13:22 作者:╰つ箜格亽苼

我需要一种方法来安装或以某种方式可以访问的sqlite3在亚行的shell。我有我的根设备。

I need a way to install or somehow get access to sqlite3 in the adb shell. I have rooted my device.

我一直试图找到一个答案,但关闭的我能来是:  Why做我得到一个" sqlite3的:未发现"一个根深蒂固的Nexus One,当我尝试使用亚行外壳打开一个数据库错误?

I've tried to find an answer but the closed I could come is: 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?

但我不认为这是好主意,把我的窗户sqlite3.exe在linux系统?

But I don't think it's good idea to push my windows sqlite3.exe on a linux system?

那么,是否可以安装sqlite3的终端浏览器以某种方式?

So is it possible to install the sqlite3 terminal browser somehow?

[解决]

从不同的意见,有的询问周围#Android的开发(IRC),我找到了解决办法。首先,我复制的数据库文件到我的桌面。不过拳头我必须安装BusyBox的,因为CP不包括在内?!?之后,我跑成,我不能拉或推,从任何地方,但/ SD卡/问题。然后我可以使用/ SD卡/作为中间站拉/推我的分贝。

From the different comments and some asking around at #android-dev (irc), I found a solution. First I copied the database file to my desktop. But fist I had to install BusyBox, because cp isn't included?!? After that ran I into the problem that I couldn't pull or push from anywhere but /sdcard/ . I could then use /sdcard/ as a "middle station" and pull/push my db.

然后我被累死!我真的有我的sqlite的终端探索。然后,我得到了主意,启动模拟器拉SQLite的二进制文件从/系统/ XBIN / sqlite3的。然后重新安装/系统RW:

Then I got exhausted! I really had to have my sqlite terminal explore. Then I got the idea to start the emulator pull the sqlite binary from /system/xbin/sqlite3. Then remount /system with rw:

# mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system

和推源码到/ SD卡/,并从那里将它复制到/系统/ XBIN /

and push sqlite to the /sdcard/, and from there copy it to /system/xbin/

现在它的工作原理:D

Now it works :D

推荐答案

我用Rajath的技术......亚行拉从模拟器/设备数据库,就可以工作,那么亚行也推回上/成模拟器设备。

I use Rajath's technique... Adb "Pull" the db from the emulator/device, work on it, then adb "push" it back onto/into the emulator device.

也: 我用从Android Market中免费的SQLite编辑器。我还没有扎根我LG的盟友,并在我的SD卡使用SQLite编辑器为此只能编辑数据库表。

also: I use the free SQLite Editor from the Android Market. I have not rooted my LG Ally and therefor can only edit database tables on my sdcard with SQLite Editor.

Rajath建议使用亚行推拉的数据库,并从模拟器/设备。与Windows(或其他)sqlite3的程序,你必须在数据库上的工作。他不建议在的Pusing窗户SQLITE3到Android设备,恕我直言。

Rajath suggests using the adb to push and pull the databases to and from the emulator/device. The work on the database with the windows (or whatever) sqlite3 program you have. He does not suggest pusing the windows sqlite3 onto the Android device, IMHO.

我注意到了Java / Android的查询()将实际的SQL programmacitacly命令那些与用户输入的程序。我的结论是sqlite3的是Android的地方。

I note that java/android "query()" sends actual SQL commands programmacitacly to ones program with user input. I conclude that sqlite3 is in Android somewhere.

在使用仿真器开发工具可用,并一路下跌,在列表的底部是终端模拟器。这使得Android系统文件结构的探索模拟器。然而从PC使用亚行壳具有root权限。

When using the emulator Dev Tools is available, and way down at the bottom of the list is the Terminal Emulator. This allows exploration of file structure of Android in the emulator. However using "adb shell" from the PC has root permissions.

好运气。仙人掌米奇