Hey, I have a .FILE that I would like to open/import because it contains my database of old iphone text messages and I want to retrieve some of them.
I did some quick research and guess that this could be read as an SQL file? When opened in notepad here is the first line:
Code
SQLite format 3 @ ¡@ » < ¡@ -â û äûÏ#
Š k ¬
œ |`^;®F¢ ñ …*Š+tablemessagemessageCREATE TABLE message (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, address TEXT, date INTEGER, text TEXT, flags INTEGER, replace INTEGER, svc_center TEXT, group_id INTEGER, association_id INTEGER, height INTEGER, UIFlags INTEGER, version INTEGER, subject TEXT, country TEXT, headers BLOB, recipients BLOB, read INTEGER, madrid_attributedBody BLOB, madrid_handle TEXT, madrid_version INTEGER, madrid_guid TEXT, madrid_type INTEGER, madrid_roomname TEXT, madrid_service TEXT, madrid_account TEXT, madrid_flags INTEGER, madrid_attachmentInfo BLOB, madrid_url TEXT, madrid_error INTEGER, is_madrid INTEGER, madrid_date_read INTEGER, madrid_date_delivered INTEGER)!'‚ triggerdelete_piecesmessageCREATE TRIGGER delete_pieces AFTER DELETE ON message BEGIN DELETE
Notice the CREATE TABLE.
I am a complete newbie in everything related to this and just want to retrieve some text messages. Could anyone possible help me?