So I had backed up my files and messages from sony xperia phone and saved all files in the computer....

Now I need to open the messages file in the backup folder which has the format of .bk...

I tried to use 7 zip to extract the .db file...

But when I opened the .db file in Notepad it appeared haphazardly with many characters and the messages were there but were jumbled in between the characters...

So I want to view them in a proper format..... Any suggestion or advice?


.db files are not plain-text files, so Notepad is the wrong approach. Those are SQLite databases, so you will have to use some SQLite browser for the task. The linked Wiki page gives you some more details. SQLiteman would be a good choice, and there's even a portable version available. For an alternative, there's also SQLite Browser.

| improve this answer | |
  • I tried SQLite but i dont know how to handle it..... – Ishan Taneja Dec 30 '16 at 11:42
  • I mean to say I opened the file in the software but there were so many options like tables,indices,triggers ...etc which I could not understand anyhting about......I need to view the message part from it.....if that is relevant – Ishan Taneja Dec 30 '16 at 11:44
  • 1
    @IshanTaneja We can't teach SQL here since that is obviously off topic. Izzy explained as much as he can explain while staying on topic. Search internet for more relevant information about .db files and database browsers. – SarpSTA Dec 30 '16 at 12:28
  • @SarpSTA Ok then............but I was hoping for a more organised user friendly gui..... – Ishan Taneja Dec 30 '16 at 12:31
  • @IshanTaneja browse the tables, that's where the data is. Ignore the rest. You'll have to do some digging on your own, we cannot tell how to extract the messages. I don't even know whether those are stored "in one piece", or spread across multiple tables/columns/rows: each application handles that in its own way. – Izzy Dec 30 '16 at 12:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.