Thursday, October 30, 2014

how do I select message data from my iPhone backup?

don't worry, it's easy (promise)

Messages on the iPhone are stored in a sqllite file inside of the backup. If you have no idea what a sqllite file is, well, then you have a little more homework to do, namely install sqllite so you can... read a sqllite file. :)

Once you have that installed, you need to grab the file within the latest subdirectory you can find inside the directory Library/Application\ Support/MobileSync/Backup/ called 3d0d7e5fb2ce288813306e4d4636395e047a3d28. This file has your texts in it. I suggest you copy it somewhere else in case you corrupt it by mistake using sqllite. Once you have it, just run sqllite [your backup filename] to load the data.

getting the data

The following query will retrieve the texts stored in this file, in a nice pipe-delimited format:

If there's more data you're looking for, this will tell you the columns in the table (sqllite doesn't use desc or describe):

The output you get should be usable in Excel or any other number of tools if you want a different backup of your texts.


  1. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. iPhone case

  2. The store has been solving problems for me, the service is very patient, and it is a perfect shopping. Replica Breitling watches When I received this watch, I thought it was a good replica watch.Replica Breitling bentley watches I like this online store, this watch is simple and generous. Very satisfied with this purchase.


  4. Valentine's day, the day of love, which falls on 14th February every year is celebrated by the couple all across the globe. Here is the world famous valentine day website visit here: Happy Valentine’s Day Breakup

  5. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. odzyskiwanie danych

  6. Great post, you have pointed out some fantastic points , I likewise think this s a very wonderful website. iphone mockup

  7. custom crew socks wholesale
    Crew socks is a kind of sock with the length of the sock body up to 5cm on the foot, covering the whole foot when wearing, is a kind of sock, suitable for people of all ages, very comfortable and beautiful to wear, keep the feet warm, reduce the friction between feet and shoes, most of them are made of cotton or nylon.  The socks that buy newly is put in warm water soak 10 minutes, after swinging dry with the dryer, low temperature irons, can improve the durability of socks.

  8. IEC 61897
    The applicable characteristics of OPGW are:
    (1) the line with high voltage over 110kV has a large gear distance (generally above 250M);
    (2) Easy to maintain, easy to solve the problem of line crossing, its mechanical characteristics can meet the large line crossing;
    (3) THE outer layer of OPGW is metal armored, which has no effect on high voltage corrosion and degradation;
    (4) OPGW must be cut off during construction, and the loss of power failure is large, so OPGW should be used in new high-voltage lines above 110kV;
    (5) the performance of the OPGW, short-circuit current, the greater the need to make armoured with good conductors, the corresponding reduced the tensile strength, the tensile strength of certain cases, to increase the short circuit current capacity, only more metallic cross-sectional area, leading to the cable diameter and cable weight increase, thus puts forward security issues on the intensity of line tower.

  9. blood pressure watch professional in R&D wearable blood pressure monitor, in the innovative form of a wrist watch, proactively monitors your heart health by turning real-time heart data into heart.
    mason jar lids canning lids supplier. offer canning Lids in different style and size
    Cervical spine massager We aim to create a healthy lifestyle that assists every individual to de-stress, relax. unwind and streamline a pain-free life and at the same time feel and look amazing.
    sex machine for her Choose Sex Machine to Get Orgasm and Enjoy Life|
    neon light for roomNeon Signs Light Is One-of-a-Kind Activities Designed and Hosted by Expert Locals. All Experiences are Vetted for Quality.

  10. sex machine Online Shop
    fucking machines Online Shop
    sex machine for her Online Shop
    patio heater Online Shop
    canning lids Online Shop
    dog training collars Online Shop
    food truck Online Shop
    silk durag Online Shop
    sewing machine Online Shop