I have been looking for clues. My iOS data is about 50MB with several GB of attachments. It dates back to 2008.
If I ignore the attachments, I can see my text messages. But if I change attachment locations, it borks. What does that mean? Does it bork because there are so many? Does it bork because some do not resolve? I have 40 or so that point to /var/tmp and more that point to ~/Library/parts/
Not all of my attachments follow the same folder structure, so I have to change some like /var/mobile/Library/SMS/Attachments/ to ~/Library/Messages/Attachments. I have ignored those pointing to /var/tmp/ and ~/Library/Parts/
It looks normal and I use SQL execute like this and it all looks good. It this in two steps:
then
I was looking at differences between my iOS schema and the macOS schema.
There are 29 indices instead of 28. This is the extra one is:
there are 11 triggers instead of 10. The extra one is:
There are also small differences like leading spaces after some brackets in the schema that don't appear in my 9006 version.
There are 10 tables, of identical names in both.
Please help.
If I ignore the attachments, I can see my text messages. But if I change attachment locations, it borks. What does that mean? Does it bork because there are so many? Does it bork because some do not resolve? I have 40 or so that point to /var/tmp and more that point to ~/Library/parts/
Not all of my attachments follow the same folder structure, so I have to change some like /var/mobile/Library/SMS/Attachments/ to ~/Library/Messages/Attachments. I have ignored those pointing to /var/tmp/ and ~/Library/Parts/
It looks normal and I use SQL execute like this and it all looks good. It this in two steps:
Code:
UPDATE attachment
SET filename = replace(filename, '/Library/SMS/Attachments/', '/Library/Messages/Attachments/')
WHERE
filename LIKE '%/Library/SMS/Attachments/%';then
Code:
UPDATE attachment
SET filename = replace(filename, '/var/mobile/', '~/')
WHERE
filename LIKE '%/var/mobile/%';I was looking at differences between my iOS schema and the macOS schema.
There are 29 indices instead of 28. This is the extra one is:
Code:
message_attachment_join_idx_message_id
CREATE INDEX message_attachment_join_idx_message_id ON message_attachment_join(message_id)there are 11 triggers instead of 10. The extra one is:
Code:
delete_associated_messages_after_delete_on_message
CREATE TRIGGER delete_associated_messages_after_delete_on_message AFTER DELETE ON message BEGIN DELETE FROM message WHERE (OLD.associated_message_guid IS NULL AND associated_message_guid IS NOT NULL AND guid = OLD.associated_message_guid); ENDThere are also small differences like leading spaces after some brackets in the schema that don't appear in my 9006 version.
There are 10 tables, of identical names in both.
Please help.
Last edited:
