Skip to content

Instantly share code, notes, and snippets.

@jeffgeiger

jeffgeiger/gist:0397041a12f6b48cb494

Last active August 29, 2015 14:03
Show Gist options
  • Save jeffgeiger/0397041a12f6b48cb494 to your computer and use it in GitHub Desktop.
Save jeffgeiger/0397041a12f6b48cb494 to your computer and use it in GitHub Desktop.
Download ZIP
Messages Backup
Raw
gistfile1.txt
sqlite3 /Users/$USER/Library/Messages/chat.db <<EOF
.mode line
select ROWID, text, datetime(date, 'unixepoch', 'localtime') as date from message where handle_id = (select ROWID from handle where id = "+12223334444");
EOF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment