oldjamey
9/7/2013 - 7:41 AM

Dump iOS SMS/iMessage database to CSV.

Dump iOS SMS/iMessage database to CSV.

#/bin/bash

# not an actual script - these are only commands, but the script would be basically the same.
# requires jailbroken iOS device

# get into the filesystem
ssh root:alpine@iphone

# update your package list, and install sqlite
apt-get update
apt-get install sqlite

# navigate to sms db directory
cd /var/mobile/Library/SMS

# drop the kids off at the pool
sqlite3 sms.db
# the following is for better illustration (the prompts will cause the "script" to fail):
sqlite> .mode csv
sqlite> .headers on
sqlite> .out message.csv
sqlite> select * from message;

# voila.
# write bash script using awk/grep and launchd (iOS/OSX crontab); sky's the limit.