10

I have a conversation that likely has tens of thousands of messages sent over the past year. I want to find texts 6 months ago in August. How can I go about getting back to August and scrolling through those messages? I have the conversation on both on my iPhone and my Messages on my Macbook.

  • What was wrong with going to ~/Library/Containers/com.apple.iChat/Data/Library/Messages/Archive & opening a folder from the end of August ? – Tetsujin Jan 16 '16 at 11:34
  • @Tetsujin What do you mean, "what was wrong?" Has this been suggested yet? – User Jan 16 '16 at 17:14
  • …in my opening comment – Tetsujin Jan 16 '16 at 18:47
10
+50

I found 2 ways of doing that. Depending on your needs and preferences, you choose what you want.

1. The flexible way

Open the Terminal.app And enter the following command:

sqlite3 ~/Library/Messages/chat.db

Now you are in the database of the Messages app of your mac.

Enter the following commands (but don't include the sqlite> as this one was added to this answer just to show you what you will expect at this point):

sqlite> .mode column
sqlite> .headers on
sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate >= "2016-01-12";

Replace this "2016-01-12" with the date you want to filter your messages, but keep the ""!

If you know the exact date of the message you can replace the >= with = like this:

sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate = "2016-01-12";

Or if you know a range of dates then you can also do this:

sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate >= "2015-12-10" and cDate <= "2016-01-12";

You should get your messages now filtered!

This way you can actually filter your messages in more flexible way. If you play around with the database schema, you may find a good way to filter your messages.

2. The easy way

If you want something more user-friendly then I found out that if you type this command in the Terminal.app:

open ~/Library/Messages/Archive/

Will open a folder in finder that has your messages grouped by date, which will make your life much easier, looking for your message. This has been mentioned by another user as well.

The advantage of this method, is that the messages are opened in a nice User Interface (i.e Messages) which is more readable and user-friendly.

  • open ~/Library/Messages/Archive/ says that folder doesn't exist. – User Jan 15 '16 at 14:26
  • @User depending on your OS X version, the path of your Message App messages will be different. Check that and let me know if that helped you or not. – Rafael Jan 16 '16 at 8:48
  • Version 10.11.2 El Capitan – User Jan 18 '16 at 0:50
0

For me, the easiest way I've found to search my messages, some of which go back years, is to use and continue to use iExplorer to export my Messages to various formats. I usually do PDF and TXT exports, either of which are then easily searched.

I make use of others features too and for me it was worth the cost, as it's not freeware.

  • 1
    I rather not buy something to check a single text message. – User Jan 9 '16 at 20:00
  • Apparently there is a demo version and it's been backing up messages for almost 4 hours. Is this normal? – User Jan 11 '16 at 5:06
0

You may try going to .../Library/Messages/Archive and look for the specific date/phone number. It should allow you to pull up the conversation.

Good luck!

0

I ended up getting the SQLite Browser and opening the ~/Library/Messages/chat.db file then searching and navigating through the texts there.

You must log in to answer this question.

protected by Community Feb 4 '17 at 10:56

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .