1, in the PC environment to start a simulator (not mobile)
2. See if the simulator/systen/xbin has sqlite3 command
ADB shell
Cd/system/xbin
Ls
3. Copy the simulator/system/xbin/sqlite3 command file from the simulator to the PC
ADB pull/system/xbin/sqlite3 E:/eclipse
4. Turn off the simulator and connect the Android phone to the PC
5. Get read access to Android phone/system folder
ADB Shell # mout-o remout, Rw-t yaffs2/dev/block/mtdblock3/system (a lot of people based on their device online is this)
6. Copy the E:/eclipse/sqlite3 file on the PC to the/system/xbin/directory of the Android phone
ADB push E:/sqlite3/system/xbin
If prompted permission denial
ADB shell
chmod 777 system/
CD system
chmod 777 XBin
Then execute the push above
If not, go straight to Eclipse DDMS filter Explore/system/xbin
Drag the data you use directly from your computer to the/system/xbin.
7. Modify the permissions of the Android real-computer/system/xbin/sqlite3 command
ADB shell
chmod 4755/system/xbin/sqlite3
then enter Sqlite3
Go to SQLite and you can do it.
Titanium Backup installed, Set the variable
%sqlite3 to "/data/data/com.keramidas.titaniumbackup/files/sqlite3".
I actually copied the titanium backup sqlite3 binary to System/xbin and it had been working for me since.
A Symlink is an alternative solution, if you want the binary in your PATH (/system/xbin) and your system-rom is nearly ful L.
For example there are only 200KB free space left in The/system of my Nexus 7 after installing Lollipop + SuperSu + Busybox .
su
mount -o remount,rw /system
ln -s /data/data/com.keramidas.TitaniumBackup/files/sqlite3 /system/xbin/sqlite3
mount -o remount,ro /system
Symlink has only a. B and the binary has a KB.
Use the attached sqlite3...extract & copy it to the /system/xbin folder...give Execute Permissions [ 0755] and it should work
http://forum.xda-developers.com/attachment.php?attachmentid=2246063&d=1378751634
After the copying file, you need to reboot.
How to set the SQLITE3 command environment for Android phones Titaniumbackup