Android adb Shell

1: Enter mode

ADB shell

2: Go to Directory

CD dir

3: View SQLite database

Sqlite>sqlite3 name.db

4: View the database with those tables, view the table names

Sqlite>. Tables

4: View table structure

Sqlite>. Schema

CREATE TABLE android_metadata (locale TEXT); CREATE TABLE record (_id integer primary key autoincrement,recordpath text,recordname text,recordtime Integer, recordduring integer,recordflags text,recordiscall integer default 0);

5: View Table contents

.

Sqlite> SELECT * FROM TableName;

1|/storage/emulated/0/recorder/New recordings 1.amr| new Recordings 1|7426851000|4060| |02|/storage/emulated/0/recorder/New recordings 2.amr| new Recordings 2|7426853000|640| |03|/storage/emulated/0/recorder/New recordings 3.amr| new Recordings 3|7426855000|580| |04|/storage/emulated/0/recorder/New recordings 4.amr| new Recordings 4|7426858000|1080| |05|/storage/emulated/0/recorder/New recordings 5.amr| new Recordings 5|7426895000|1100| |06|/storage/emulated/0/recorder/New recordings 6.amr| new Recordings 6|7426899000|1520| |07|/storage/emulated/0/recorder/New recordings 7.amr| new Recordings 7|7426903000|2660| |08|/storage/emulated/0/recorder/New recordings 8.amr| new Recordings 8|7426906000|880| |09|/storage/emulated/0/recorder/New recordings 9.amr| new Recordings 9|7426908000|500| |010|/storage/emulated/0/recorder/New recordings 10.amr| new Recordings 10|7426910000|520| |011|/storage/emulated/0/recorder/New recordings 11.amr| new Recordings 11|7426912000|420| |012|/storage/emulated/0/recorder/New recordings 12.amr| new Recordings 12|7426914000|480| |013|/storage/emulated/0/recorder/New recordings 13.amr| new Recordings 13|7426916000|480| |014|/storage/emulated/0/recorder/New recordings 14.amr| new Recordings 14|7426922000|3360| |015|/storage/emulated/0/recorder/New recordings 15.amr| new Recordings 15|7427010000|2720| |016|/storage/emulated/0/recorder/New recordings 16.amr| new Recordings 16|7427012000|700| |017|/storage/emulated/0/recorder/New recordings 17.amr| new Recordings 17|7427015000|640| |018|/storage/emulated/0/recorder/New recordings 18.amr| new Recordings 18|7427067000|1340| |019|/storage/emulated/0/recorder/New recordings 19.amr| new Recordings 19|7427776000|35320| | 0

Android adb Shell