phx/sms-to-csv.sh

## sms-to-csv.sh
#/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.
	#/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.