Install sqlite3 on your rooted Google Nexus One / Nexus S

August 5, 2011

Please note that all credit goes to Sun Chen for this solution (blogpost here: http://chensun.net/android-development/install-sqlite3-on-google-nexus-one/54/).

I simply applied the same technique to my Nexus S and have reproduced the steps below for my own future benefit.

[Notice! You must have root access on your Nexus One / Nexus S.]

1. Download sqlite3, which comes with SuperOneClickv1.7-ShortFuse, and copy it to your SD card.

2. Connect your phone to your computer. Open a Command Prompt, and type the following commands:

adb shell
$ su
# mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
# dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
# chmod 4755 /system/bin/sqlite3
# mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system

Done! Now you can use sqlite3 to examine database on your Nexus One / Nexus S from a Remote Shell or even from an Android Terminal Emulator.

Advertisements

2 Responses to “Install sqlite3 on your rooted Google Nexus One / Nexus S”

  1. th0m4d Says:

    Thanks for the post. I followed your instructions, but after installing and running sqlite3 Im getting the following error:

    reloc_library[1306]: 8008 cannot locate ‘sqlite3_enable_load_extension’…

    Im using a rooted nexus s. I also tried to take the sqlite3 from the emulator and copied it to my phone. It yields the same error. Any idea on what I am doing wrong?

  2. chauxcedric@gmail.com Says:

    no you re not using it wrong , it s because each version of android has his own sqlite3 version . It just means it s not the right version.
    I couldn t find mine ( 4.4.4 )


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: