Use the ADB shell to open a database file on the mobile phone and prompt "sqlite3: Command not found"

Cause: There is no sqlite3 file in the/system/xbin folder on the mobile phone.

Solution: Generally there are some in the simulator, so the task is to drag sqlite3 from the simulator to the mobile phone device.

1. Mount the mobile phone first to make/system/read/write (RW)

$ ADB Shell

# Mount-O remount, RW-T yaffs2/dev/block/mtdblock3/System

2. Open another terminal and drag the sqlite3 file from the target directory to the/system/xbin directory.

$ ADB push E:/sqlite3/system/xbin

Note: The premise is that I put the sqlite3 file in the simulator under the root directory of the E disk. Now you can find the SQLite file under the/system/xbin directory of your mobile phone.

3. Now re-open the last terminal, change its binary license, and mount change/system/to read-only status (RO ).

# Chmod 4755/system/xbin/sqlite3

# Mount-O remount, ro-T yaffs2/dev/block/mtdblock3/System

So far, we can use sqlite3 to view the database files on the mobile phone.

# Sqlite3/data/COM. mobisync. Android/databases/Sync. DB

SQLite version 3.6.22

Enter ". Help" for instructions

SQLite>. Tables

Android_metadata file sync_status

Note: Here is an English solution. 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?