[Q] mmssms.db recovery - Nexus 4 Q&A, Help & Troubleshooting

Hey I have old mmssms.db files that I want to recover but can't figure out how to do so because the files are originally from older version of Android that apparently aren't compatible with the current software. I heard you can open it in some browser and save the table as .csv then use some app to import the texts into the phone. I tried that using sqLite browser or something but could never get it to work.
Is there another method, something simpler or... ?? if not, can someone outline the steps needed to recover my old texts, thanks.

Related

Synchronizing contacts!

Hi,
I need to do a hard reset on my device and want to store all my contacts somewhere safe so I don't have to manually input them all again. The problem is I don't use outlook on my PC. Is there any way I can pull them off the Exec and store them on my PC for safe keeping?
I would normally throw them on the SIM but there appears to be no tool to add them all at once and I am not manually moving 150 contacts myself
--
Sorry for the duplicate post, I didn't mean to put it in general
Does nobody know? There must be a quick way to save your contacts somewhere safe? What does everyone else do when they need to do a hard reset?
Is there a particular folder on the Exec that may contain all of my contents? I could then copy it onto my PC and replace later.
there is a way you can backup the contacts database, i cant find it tho, i dont think it was on this forum, but there was a deffinate way to backup the databases for this kind of work
soz cant give a proper solution
It was something about taking a backup of "pim.vol" from the My Documents folder, then fiddle around trying to overwrite the empty one after you've done your hard reset, but I can't find it either....
pim.vol is found the root directory of the device, copy to sd, reboot, copy back... supposedly, havent done it, but read it. you may have to show files in ROM.
simon_darley said:
pim.vol is found the root directory of the device, copy to sd, reboot, copy back... supposedly, havent done it, but read it. you may have to show files in ROM.
Click to expand...
Click to collapse
Yeah, I read this yesterday and tried it and it works a treat. I now keep a copy of pim.vol just incase. Good practice for those who don't know it exists
One tip - make sure you've set the 'Region' in settings back to your original one before you restore the file, otherwise it won't even let you start the contacts app! Had a moment of panic there myself last night...
What all in pim.vol Just contact or like SMS and MMS to?...
Coz I am trying to find a way to take a back up of my SMS, and I dont get any software working yet.

[Q] "Contacts.db"

Hello,
So I recently rooted, backed up, and installed liberty 1.5 on my droid x. In the process I lost my contacts. I didn't see this as a problem at first because i thought the backup would store all information on my phone and I could just go back and retrieve them. I have not been able to restore them. I used titanium backup for my backup. There is a file "contact.db" that would seem to be my contact database, but I cannot figure out how to import or retrieve my contacts from the file. I did not sync to my google account, because im a dumbass and didnt know to do this. However, now i do.....
Can anyone help me?
Im new to the forums, thank you in advance.
Did you have verizon's backup assistant and did you use it?
If so, you can go to the backup assistant website and download your contacts as a csv file, then import to google contacts
As for the file, I think it's a sqlite db file.
Copy the .db file to your computer and find a sqlite db program, then try opening the file (make a backup of the file first)

Import contacts from bak file using Phone portal on CM9?

I just installed CM9 on my moto Defy which is great, but I previously created a bak file with all my contacts numbers, I'm trying to use "phone portal" to restore that file into my phone but it always tells me "server error" so I cannot do the process on the computer, it normally gives you an url where you can see everything you have in your phone through your web browser on the pc, is not working anymore on CM9? thanks!
EDIT: If there's any other way than using Moto Phone Portal(to import a bak, csv, vcf) file please let me know thanks!
Why didn't you export your contacts to SD card in vcf format using inbuild backup feature??
anyway, if its .vcf file then just copy it on root of sd card and run it via contacts>Inport contacts from sd card>import one v card(if you have one vcf file) or import all v cards( if you have more than one v cards. Thats it.
I always did it like I said, however, never installed a custom ROM before, anyway, THANKS A LOT for the help, I will give it a try tonight It will save me a lot of time >_<
EDIT: Done! thank you!

[Q] Will rooting wipe the mmssms.db file?

In the need to recover a deleted SMS thread, I have recently found out that the SQLite database file mmssms.db retains deleted data, which means that I could, in theory, recover the conversation thread which had vital information that I need back. The problem is that this file is located somewhere in an area inaccessible without rooting the phone, and doing so seemingly will erase the file, making this whole process pointless.
I have done some research and realized most backups only save the com.android.providers.telephony.json and .ab files, which only have data from non-deleted texts. Also, please correct me if I am wrong, but it seems I am only capable of backing up files from the "sdcard" folder and nothing from other folders such as "root" and "data" (which on my unrooted phone appear empty), the two possible locations for the mmssms.db file. I would like to know if there is any possible way of accessing this file without having to root the phone or if I am safe to root the device without the risk of wiping mmssms.db.
Thanks in advance. Recovering those messages would greatly help my cause.
henriliveira said:
In the need to recover a deleted SMS thread, I have recently found out that the SQLite database file mmssms.db retains deleted data, which means that I could, in theory, recover the conversation thread which had vital information that I need back. The problem is that this file is located somewhere in an area inaccessible without rooting the phone, and doing so seemingly will erase the file, making this whole process pointless.
I have done some research and realized most backups only save the com.android.providers.telephony.json and .ab files, which only have data from non-deleted texts. Also, please correct me if I am wrong, but it seems I am only capable of backing up files from the "sdcard" folder and nothing from other folders such as "root" and "data" (which on my unrooted phone appear empty), the two possible locations for the mmssms.db file. I would like to know if there is any possible way of accessing this file without having to root the phone or if I am safe to root the device without the risk of wiping mmssms.db.
Thanks in advance. Recovering those messages would greatly help my cause.
Click to expand...
Click to collapse
You can recover ur sms before the rooting because after rooting ur phone would left with 0 sms's.
D_RiDeRs said:
You can recover ur sms before the rooting because after rooting ur phone would left with 0 sms's.
Click to expand...
Click to collapse
How would I go about recovering deleted text messages without having root access?
henriliveira said:
How would I go about recovering deleted text messages without having root access?
Click to expand...
Click to collapse
While googling for more than half an hour I got the solution to ur problem. Here:-
1.
2.
You can try the first one first because it has trial version available.
Best of Luck!! :good:
Thanks for the help, but I have already tried both, the former does not support MTP phones and the latter needs root access.
henriliveira said:
Thanks for the help, but I have already tried both, the former does not support MTP phones and the latter needs root access.
Click to expand...
Click to collapse
Good to know. MTP is a blessing and a curse.
is possible to root without wiping data, this is a security issue, but for you it's fine:
http://forum.xda-developers.com/showthread.php?t=2266928
having a custom recovery will make you able to install the necessary files to root your phone.
EDIT: Reading the previous thread, there was a comment with another way of rooting the phone, without wiping data, try the one that is easier for you.
http://forum.xda-developers.com/showthread.php?t=2300480
moxtrom said:
is possible to root without wiping data, this is a security issue, but for you it's fine:
http://forum.xda-developers.com/showthread.php?t=2266928
having a custom recovery will make you able to install the necessary files to root your phone.
EDIT: Reading the previous thread, there was a comment with another way of rooting the phone, without wiping data, try the one that is easier for you.
http://forum.xda-developers.com/showthread.php?t=2300480
Click to expand...
Click to collapse
Thanks a lot man, I tried the second one and it worked perfectly.
Also. You can adb pull the file without root as long as you know it's location.
Adb pull /data/data/com.android.providers.telephony/databases/mmssms.db
You would need root to modify and replace it though.
And when you put it back you also have to chmod and chown it
Sent from my Nexus 4 using xda app-developers app
You can also download go sms from play store, it has a backup feature, so you can backup before wiping, it will create a backup file on your "sd card", then wipe, install go sms again after wiping, restore, and eventually delete go sms if you don't want it that's what I do, and it works
Sent from my Nexus 4 using xda app-developers app
gallardo5 said:
You can also download go sms from play store, it has a backup feature, so you can backup before wiping, it will create a backup file on your "sd card", then wipe, install go sms again after wiping, restore, and eventually delete go sms if you don't want it that's what I do, and it works
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
It backs up deleted text messages?
Guessing you didn't read the OP.
Sent from my iPad 4

[HOWTO] extract and import sms from old NAND backup to your new device

Long story short : I needed to get my sms from my old motoG and transfer them to my new motoG5. Here is how:​
This can be done without any third part app, only a capable recovery and adb is needed.
Get your old SMS
take you Nand backup you hopefully did before your device died.
find the mmssms.db file that you can find in :
Code:
data.f2fs.win000
Use :
Code:
tar –xf data.f2fs.win000.tar.gz
Android 6:
Code:
/data/data/com.android.providers.telephony/databases/
Android 7:
Code:
/data/user_de/0/com.android.providers.telephony/databases/
Copy mmssms.db to your computer.
Import your database to your new device
==> root is needed for that operation
Push mmssms.db to your device (depending on you android version, see above)
e.g.:
Code:
adb push ./mmssms.db /data/user_de/0/com.android.providers.telephony/databases/mmssms.db
Delete any journal.db you may find in the same folder.
Wipe cache and art-cache
Reboot.
Delete sms-mms application data
Start the sms-mms app
Voilà!
An alternative way that doesn't require root is available here. (thx to @Mirhawk)
also thx to @dlegit for the new directory.
If you could convert the db file into xml format you should be able to use an app to restore without needing root
Edit
Just noticed you posted another guide which mentions that
TheFixItMan said:
If you could convert the db file into xml format you should be able to use an app to restore without needing root
Edit
Just noticed you posted another guide which mentions that
Click to expand...
Click to collapse
Yeap, I just wanted to do it without third party software
I didn't say this 'how to' is super useful, I just shared the way I did it.

Categories

Resources