You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Translating a chat.db-wal File

Hi there,


I need to recover some deleted iMessages but they're 1) Over 30 days old, 2) Not on any of my backups and 3) Not on any of my other devices. I do, however, have a "chat.db-wal" file that' dates back to the necessary time frame. But, when I open it, it's just a bunch of illegible symbols, numbers and letters. I spent hours troubleshooting with some fantastic Apple Advisors on the phone, but we all remained stumped.


I downloaded "SQLite Flow" from the App Store, but when I go to open the chat.db-wal with that software, nothing generates. Does anyone know how to translate this kind of a document into something legible? Perhaps reverse engineer the data in it?


Thanks in advance for any and all suggestions.



MacBook

Posted on Aug 18, 2020 4:15 PM

Reply
2 replies

Aug 18, 2020 5:17 PM in response to PLA1029

The -wal is the write ahead log. It may have information in it, but not in a structure that may be identifiable.


https://sqlite.org/wal.html

This may help recover something, but you would still need to know SQL to read the information stored in the recovered database.

https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database

Translating a chat.db-wal File

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.