phx · November 23, 2020 17:38 · phx · Nov 17, 2020
diff --git a/sms-to-csv.sh b/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.