January 2018
Beginner to intermediate
402 pages
10h 6m
English
book
Practical Mobile Forensics - Third Edition
by Rohit Tamma, Oleg Skulkin, Heather Mahalik, Satish Bommisetty
Content preview from Practical Mobile Forensics - Third Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Connecting to a database
Manual examination of iOS SQLite database files is possible with the use of free tools. The following is an example of how to examine a database using native Mac commands in Terminal. Make sure that your device image is mounted as read-only to prevent changes being made to the original evidence. To connect to a SQLite database from the command line, run the sqlite3 command in the Terminal by entering your database file. This will give you a SQL prompt where you can issue SQL queries:
$ sqlite3 sms.dbSQLite version 3.19.3 2017-06-27 16:48:08Enter ".help" for usage hints.
To disconnect, use the .exit command. This exits the SQLite client and returns to the Terminal prompt.