
Now open options and select SQLite Manager. Select “Customize” and drag the “SQLite Manager” to the blue bordered box. In it, after You have installed the addon do following to enable the addon It is a bit lengthy, but simple process.Start firefox browser. Ĭopy both of these files to Your newly formatted phone and then use the two before mentioned apps (Call Log backup& Restore and SMS Backup & Restore) to restore Your SMS and call logs. xml file, You can press enter to let it give a default name. It will also ask You to enter a name for the output. It will ask You to enter a name for the output. You get the “Open command window here” option.

This can be done by opening the folder, right clicking using shift key pressed in blank space.

Now open a command prompt at location of the above folder. We will restore the SMS and Call logs first.Ĭurrently it is limited to Windows OS only.Įxtract the contents of yaffs-mmssmsdb-calls-extractor.zip to a folder.Ĭopy the mmssms.db file and contacts2.db file to the above folder. db file inside the SMS app You have been using with the firmware/ROM. The mmssms.db file may vary as per app and ROM’s. The contacts2.db is constant across most ROM’s and OEM firmware apps. The contacts2.db files is for contacts as well as the call logs and the mmssms.db is for messages. Now we need to find two files contacts2.db and mmssms.db. It is recommended to store the file in a separate folder as the file gets extracted directly. On linux, You can do so using the following command. On windows, now You can directly extract them using WinRaR or 7zip application, although You don’t need to extract it entirely.

If Your files are like 000, 001, then rename each of them to in separate folders. I know there is Titanium backup app which can restore contact, sms etc from nandroid backups, but You need a paid version of the app.įirst we need to extract the data partition of nandroidRename the to. The procedure is a lot crude as of yet, I would update as more universal and convenient options are found. After a lot of Google searches, I was finally able to work it out. Then using that I was able to recover My contacts, sms, call logs and app data. Luckily, I had a working recovery(TWRP) and was able to take a backup. The reason for this being I was not formatting the data partition, which I needed to preserve since it had all My sms, contacts, call logs and other app data. Tried flashing stock PRF, stock firmware, some stock based firmware, but it would get stuck in bootloop. Extract and Restore Contacts, SMS, Call logs from nandroid backups(TWRP) So yesterday My phone, Sony Xperia S, decided to go into bootloop and not boot at all, no matter what I did.
