1. Are you ready for the Galaxy S20? Here is everything we know so far!


Discussion in 'Android Devices' started by buconova, May 25, 2017.

  1. buconova

    buconova Lurker
    Thread Starter

    Hello. As the topic says I have corrupt file mmssms.db Can you fix this file or export all messages and MMS in XML or any other format?

    The size of the file is 1.15MB. When I open the file with Notepad to see it next to various hieroglyphs also my message. Not entirely otherwise. But there are ;)

    Please help me.


  2. Best Answer:
    Post #9 by buconova, May 27, 2017 (3 points)

    1. Download the Forums for Android™ app!


  3. KingOfTheNet

    KingOfTheNet Well-Known Member

    What did you do on your device before the error occured?
  4. buconova

    buconova Lurker
    Thread Starter

    I wrote and sent SMS. Immediately afterwards, the phone automatically forced switches off and then "boot loop". After that I hold the button for on / off a few moments. Yes, I myself forced restart. Then he started. Immediately after the start I went to watch the messages when sent the last message. And when I opened there was no sms more inside. And gone are the lists of calls log. And before the phone was not the root. Only then do I root and search manually mmssms.db where the folder contains mmssms.db.corrupt

    I'm sorry for English

  5. Hadron

    Hadron Smoke me a kipper...
    VIP Member

    That's the database that stores your messages. My guess is that the phone crashed while still writing to the file, which is why it's now corrupt. Very bad luck.

    If you didn't have any message backup there's probably not a lot you can do. To fix it would require being able to tell exactly what is wrong with it and know what is needed to make it readable.

    You could try a message backup app - exporting messages from the database to another format (proprietary or xml, depending on app) is what they do. If such an app can read the db file it may be able to recover some of your messages. But I cannot promise that such apps will be able to read it any more than your message app can.
  6. buconova

    buconova Lurker
    Thread Starter

    Apparently the phone is really collapsed at the very moment when I was writing the message and the message store program data into the database. It is therefore malformed. Altova DatabaseSpy not open with a reason: malformed

    Maybe I can manually "fix" part of the data mmssms.db.corrupt

    Something is only in the last part wrong. But what? :)

    Although malformed mmssms.db.corrupt renamed in mmssms.db
    the system automatically renames back :( and makes a new empty database.
  7. buconova

    buconova Lurker
    Thread Starter

    WAU! SysTools Sqlite Database Recovery!! Licenc to many cost for me :( 149€

    What a program similar to this?
    #6 buconova, May 26, 2017
    Last edited: May 26, 2017
  8. buconova

    buconova Lurker
    Thread Starter

  9. Hadron

    Hadron Smoke me a kipper...
    VIP Member

    I'm afraid I don't know much about this type of software.

    However, since you mentioned "cracks" I should remind you that the forum rules forbid discussion of software piracy, so we can't help with getting around licensing restrictions.
  10. buconova

    buconova Lurker
    Thread Starter

    I saved all SMS!

    A simple way is to work with me is:


    sqlite3 ".dump" mmssms.db | sqlite3 new.db


    then with program yaffs extractor: extract -s new.db

    and I get a *.xml file with all SMS

    Hadron likes this.
  11. Hadron

    Hadron Smoke me a kipper...
    VIP Member

    Excellent. :)

Share This Page