April 2020
Intermediate to advanced
400 pages
10h 12m
English
book
Practical Mobile Forensics - Fourth Edition
by Rohit Tamma, Oleg Skulkin, Heather Mahalik, Satish Bommisetty
Content preview from Practical Mobile Forensics - Fourth 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 the Terminal:
- Make sure that your device image is mounted as read-only to prevent changes being made to the original evidence.
- To connect to an SQLite database from the command line, run the sqlite3 command in the Terminal by entering your database file. This will give you an SQL prompt where you can issue SQL queries, as shown in the following code block:
$ sqlite3 sms.dbSQLite version 3.28.0 2019-04-15 14:49:49Enter ".help" for usage hints.
- To disconnect, use the .exit command. This exits the SQLite client and returns to the Terminal.