Database Develop

[Q] Xfer D1 texts to D3 w/ TB Pro

Hello,
I was wondering if anyone could help me transfer my sms and mms from my old droid 1 to my new droid 3. I have tried: SMS Backup and Restore, SMS Backup, My Backup Pro, and these did not work. Also, I have more than 200 texts with multiple people that I would like to keep, so some of the above apps didn't apply.
I tried to back up the [SMS/MMS/___] dialer storage with TB. Then, on my Droid 1, I navigated to the folder where the backup files were just saved. There were 3, and they were called data.data.android.providers.telephony, or something like that. I moved these 3 files to my droid 3 in the same folder, and tried to restore them using Titanium Backup on my droid 3.
After I restored them, I was able to see the that the texts were there in Handcent SMS, BUT any time I clicked on a contact to see all the texts, my phone would force close. I used root explorer to delete the mmssms.db and that fixed my phone, but I was wondering if anyone knew how to get this to work? I feel like it has to do with something regarding permissions?

jayjl3 said:
Hello,
I was wondering if anyone could help me transfer my sms and mms from my old droid 1 to my new droid 3. I have tried: SMS Backup and Restore, SMS Backup, My Backup Pro, and these did not work. Also, I have more than 200 texts with multiple people that I would like to keep, so some of the above apps didn't apply.
I tried to back up the [SMS/MMS/___] dialer storage with TB. Then, on my Droid 1, I navigated to the folder where the backup files were just saved. There were 3, and they were called data.data.android.providers.telephony, or something like that. I moved these 3 files to my droid 3 in the same folder, and tried to restore them using Titanium Backup on my droid 3.
After I restored them, I was able to see the that the texts were there in Handcent SMS, BUT any time I clicked on a contact to see all the texts, my phone would force close. I used root explorer to delete the mmssms.db and that fixed my phone, but I was wondering if anyone knew how to get this to work? I feel like it has to do with something regarding permissions?
Click to expand...
Click to collapse
Usigpng sms backup. Go into setting and change where it looks for the backup at. Its be something like /sdcard/smsbackup/
Add -ext after the sdcard. It looks like /sdcard-ext/smsbackup. Then it will find your backup and work
Sent from my DROID3 using XDA App

Is there any way to make it work with TB?
SMS Backup takes too long to upload, and gives an error after I try it. Finding the backup wasn't the problem, it just reports an error everytime

Anyone know?

[Q] SMS Backup tool that restores dates properly?

Anyone have the name of an app that does this correctly. Im using sms backup and restore but it does not restore the dates properly. And the messages are all out of order because of this.
Thanks

I am using the same and have the same problem

bump (10char)

"AppExctractor" can extract messages from previous clockwork mod recoveries.
The only flaw is that the backup has to have been made through ROM Manager.

SMS Backup+ has the same problem (basically, all messages are restored to the date and time that you restored them, not when they were sent or received). It never did on my old phone. I suspect that Motorola is doing something non-standard with the timestamp on messages.

Titanium Backup.
--
Sent from my CyanogenMod-powered TouchPad.

I had the same issue with SMS Backup and Backup to Gmail. I ended up switching to GoSMS and used its built in backup feature. The restore worked perfectly! All dates show correctly.

tetorocks said:
I had the same issue with SMS Backup and Backup to Gmail. I ended up switching to GoSMS and used its built in backup feature. The restore worked perfectly! All dates show correctly.
Click to expand...
Click to collapse
I use GoSMS myself and I can confirm that in the GoSMS app itself, the dates restore correctly. However, the stock messaging app does not restore correctly (it puts the date/time of transfer/restore as the timestamp of all messages restored) using the GoSMS restore function any more. I'm not quite sure if it's an update thing or a phone thing as I went from an X2 to a Bionic but I believe it was broken in an update to the app itself.

Handcent backup took too long for me. Since then, I have used My Backup Pro, which has done a fantastic job of restoring my 6700 messages with time stamp intact. Try giving it a shot.
EDIT: Just kidding. Sorry kiddos. Next time I reflash, I'll see if Handcent restore works.
Sent from my DROID BIONIC

Diocat said:
I use GoSMS myself and I can confirm that in the GoSMS app itself, the dates restore correctly. However, the stock messaging app does not restore correctly (it puts the date/time of transfer/restore as the timestamp of all messages restored) using the GoSMS restore function any more. I'm not quite sure if it's an update thing or a phone thing as I went from an X2 to a Bionic but I believe it was broken in an update to the app itself.
Click to expand...
Click to collapse
this is correct, i tried 3 different backup/restore apps before i realized that the problem is with the stock SMS app, not the backup/restore app. Handcent and ChompSMS do display the correct time even when the stock app does not. same problem on my Droid X too.

PhilDX said:
this is correct, i tried 3 different backup/restore apps before i realized that the problem is with the stock SMS app, not the backup/restore app. Handcent and ChompSMS do display the correct time even when the stock app does not. same problem on my Droid X too.
Click to expand...
Click to collapse
Handcent doesn't display correct time and dates for me, I used sms backup to restore sms and call logs.

GoSMS is the best one when it comes to backing up and restoring the SMS.. I have 10,000+ Msgs and while it takes about 1.5 to 2 hours to restore it's well worth it..

Ritesh Sahu, dev of SMS B&R, recently released a new version that fixed his restore mismatch dates.
What's New
What's in this version:
v4.4:
Potential fix for the incorrect Date/Time problem after restore on some Motorola phones. Special thanks to Dominick Young for his endless testing. Also thanks to John L Galt for his help.
Fixed sorting of conversations on some phones.
Added yyyy-MM-dd_HH-mm-ss as file name format.
Added a label to display the last backup date.
Click to expand...
Click to collapse
It works for me so far (and yes that is me in the notes - although I wasn't able to test it nearly as much as Dominick)

Go SMS Pro is by far the best

I had a similar problem when restoring messages to my Droid X2. It looks like the stock text messaging app for Droid is looking for the date in a column named sort_index instead of the date column that all the other apps seem to look at. This also controls the sorting of the messages. When you're restoring messages sort_index gets set to the import date and time of when the message was restored which is what breaks the stock app. To fix the problem I used Root Explorer to download a copy of /data/data/com.android.providers.telephony/databases/mmssms.db. Then I used the command line version of SQLite to run queries to update the sort_index column to have the same value as the date column. The queries looked like this:
update pdu set sort_index = date * 1000
update sms set sort_index = date
update threads set sort_index = date
Then I put the file back in place, making sure permissions were correct and then rebooted the phone. Everything was back in the correct order at this point.

Textra.... Beware!

Just a warning that there seems to be no way of backing up or saving your messages from Text's AT ALL!
So if you just back the app up on titanium like I have been your fine... Until you want to switch SMS apps.
Then you'll find you can't export messages from Tetra to anything else. They seem to force you to stay with them!
Just a warning.

Boonyard said:
Just a warning that there seems to be no way of backing up or saving your messages from Text's AT ALL!
So if you just back the app up on titanium like I have been your fine... Until you want to switch SMS apps.
Then you'll find you can't export messages from Tetra to anything else. They seem to force you to stay with them!
Just a warning.
Click to expand...
Click to collapse
SMS backup and restore always worked for backing up my text messages with textra.

DizzC said:
SMS backup and restore always worked for backing up my text messages with textra.
Click to expand...
Click to collapse
It can't find them for me, neither can I using file explorer. Have you backed up and restored using titanium?
I think that's what the issue is and I've seen a lot of people mention on here that that's what they're doing (as I was), so thought I'd warn them.

You're backing up "Messages (SMS & MMS)" in Titanium Backup and not the Textra app itself, right?

dannejanne said:
You're backing up "Messages (SMS & MMS)" in Titanium Backup and not the Textra app itself, right?
Click to expand...
Click to collapse
Because Textra keeps all your messages when backed up and restored by titanium, I had been freezing the default meaning app on the last few ROMs I'd tried.
This was fine until I want to swap to something else.
The problem is, all my messages are in Textra, but you can't get them into anything else or back them up.... I'm stuck using it!

i juse easy backup app which backups my text , call logs etc to either the internal memory , dropbox or google drive . It does a restore as well. handles everything from setting the default app etc .

krunal1981 said:
i juse easy backup app which backups my text , call logs etc to either the internal memory , dropbox or google drive . It does a restore as well. handles everything from setting the default app etc .
Click to expand...
Click to collapse
My point is though, I bet it wouldn't back them up from Textra... Only if you have them in your default SMS.

Boonyard said:
My point is though, I bet it wouldn't back them up from Textra... Only if you have them in your default SMS.
Click to expand...
Click to collapse
It does backup from the textra app as well. Have been using it since Jan 2014 without any problems. Infact just did a backup and restore last night coz i rooted my phone again.

krunal1981 said:
It does backup from the textra app as well. Have been using it since Jan 2014 without any problems. Infact just did a backup and restore last night coz i rooted my phone again.
Click to expand...
Click to collapse
Nope, just tried it. It backs up Textra with messages in it (same as Titanium), but doesn't back up messages FROM Textra so you can put them in another app.
Thanks anyway though!
I think my messages are stuck with Textra.

Confirmed from the developer, there is no way to backup messages or export messages from Textra, so everyone make sure you backup up your sms separately or you will never be able to leave!

This isn't true. I just backed up my SMS from textra using SMS backup and restore from the Play Store.. Textra itself doesn't have the capability built into the app... I have used textra, hello SMS, evolve SMS and others and I am able to restore them all. This seems to be a case of operator error.
Sent from my Nexus 5 using Tapatalk
Edit: why is this in apps and themes?

eaglesphilsphan said:
This isn't true. I just backed up my SMS from textra using SMS backup and restore from the Play Store.. Textra itself doesn't have the capability built into the app... I have used textra, hello SMS, evolve SMS and others and I am able to restore them all. This seems to be a case of operator error.
Sent from my Nexus 5 using Tapatalk
Edit: why is this in apps and themes?
Click to expand...
Click to collapse
It is user error because I backup apps with titanium backup and it'll restore all my messages and they even show up in the stock android sms app. Its annoying because I flash a bunch of roms and when i restore it'll show up in the stock messaging app and hangouts before i set textra to my default app. I've been backing up and restoring since november and it shows up on other apps when i restore with titanium backup.

Yes, but you guys clearly don't freeze or remove the default messaging app when using textra. I've read loads of people on here say they do and didn't want them to be in the same position I'm in.
You can backup from the default SMS app, and from every other SMS replacement app on the market, but not from Textra. That's from the developers mouth.

Well I haven't had any problems using Textra yet... I'm using it since I got my Nexus 5 in November 2013 and saw that Hangouts replaced the default SMS/MMS app.
In fact I'm not SMSing so much anymore and backing up SMS' ain't that important for me, but your post alarmed me a little. So I installed some of the other SMS apps from the Play Store. Every single app displays all the messages in my storage, so on my case it seems like I have a common SMS storage and I'm certain that Helium Backup & Sync offers to backup that storage.
Maybe that's an option for you?
Btw I'm running Stock 4.4.2 rooted with Xposed Framework enabled, just in case it matters
Greetz
// j_dee
Sent using Tapatalk app from my LG Nexus 5

Boonyard said:
Yes, but you guys clearly don't freeze or remove the default messaging app when using textra. I've read loads of people on here say they do and didn't want them to be in the same position I'm in.
You can backup from the default SMS app, and from every other SMS replacement app on the market, but not from Textra. That's from the developers mouth.
Click to expand...
Click to collapse
Clear data of Textra dum dum

asdf916 said:
Clear data of Textra dum dum
Click to expand...
Click to collapse
All that would do is remove my messages from Textra. I want to get the messages out and into hangouts but it won't let you.

I just deleted Textra app data and uninstalled. Installed Chomp and all texts were still there. Uninstalled Chomp and reinstalled Textra.
Hangouts, my only other installed sms app, has been frozen since day one.

Wakamatsu said:
I just deleted Textra app data and uninstalled. Installed Chomp and all texts were still there. Uninstalled Chomp and reinstalled Textra.
Hangouts, my only other installed sms app, has been frozen since day one.
Click to expand...
Click to collapse
That will be because you didn't freeze or uninstall the stock SMS app.
The lesson is, don't freeze or uninstall your stock SMS app if using Textra, or you'll never be able to move them to another app.

Boonyard said:
That will be because you didn't freeze or uninstall the stock SMS app.
The lesson is, don't freeze or uninstall your stock SMS app if using Textra, or you'll never be able to move them to another app.
Click to expand...
Click to collapse
Read the second sentence you quoted.

Wakamatsu said:
Read the second sentence you quoted.
Click to expand...
Click to collapse
Oh sorry! Mis-read that!
Hmm interesting... So yours were saved on your system even though you were only using Textra. Then where mine have gone is a real mystery add they are in Textra, but nowhere else.
Thanks for info.

How to delete the whole SMS database?

I have a big problem after I restored all my sms from my previous phone to my brand new OP3T.
The app that I have used is Superbackup and the restore was completed successfully.
But when I enter to the stock sms app I am only receiving a "Loading conversation" message and the worse part is that after that my whole phone hangs when I open apps like Google search,chrome etc
Is there any way to start fresh clean with my sms database, by removing all of the current sms saved?
Unleashed by ONEPLUS 3T rooted

Not sure if it will fix your problem, but in Titanium Backup it shows the SMS stored as "Messages (SMS & MMS)" and I've successfully backed up and restored this when migrating between ROMs on my 3T.
Not sure what the backup app you used is trying to do. Each phone manufacturer appears to store the SMS messages different, from what I've seen. My old HTC phone had them stored under a different name.

Very strange situation.
I cleared the Data from the messages app at the phone's settings and then everything was looking good, as it should have removed all sms.
Today I opened the messages app and all sms are there!
How is this possible??
Sent from my m1 note using Tapatalk

Clearing data for your choice of SMS app will only temporary hide all messages until the app restores all SMSes from the system-wide database in /data/user_de/0/com.android.providers.telephony/databases/. You have to remove that database to really start from scratch.

pitrus- said:
Clearing data for your choice of SMS app will only temporary hide all messages until the app restores all SMSes from the system-wide database in /data/user_de/0/com.android.providers.telephony/databases/. You have to remove that database to really start from scratch.
Click to expand...
Click to collapse
Came here to post this exact location.

Should have been more clear, in Titanium, there are two different entries: "Messages" app and the "Messages (SMS & MMS)". I think the latter is the same as the database location given in the 2 above responses.

Is "Like" equal "Thanks"?

[help] Lost some data after reset

So today I made a factory reset in order to solve some excessive battery draining that I had the last few weeks.
As always, I have I made sure to make a thorough backup to all my accounts and I also used the HiSuite to make a backup on my pc, HOWEVER, after I restored my backups and apps, I noticed that all my sms are missing besides some 5 sms of today and maybe 5 sms from 2013!
I tried to delete messages app data and restore them but no luck. I also tried to restore them from HiSuite and although it says restore complete I am still missing the sms. Finally I tried to restore them from an older huawei cloud backup (I suppose it also stores the sms) and but again nothing!
Can someone please guide me? how can I access my Google account sms backup and restore the last sms backup?
Tks in advance,
Thanos
Sent from my CLT-L29 using Tapatalk

I think there is a bug in the app. When I restored my messages a lot of them got stored in a conversation with "unknown number".

Yes, I also some of mine were registered as unknown number indeed.
There must be a way to recover the sms though, but what is it...
Sent from my CLT-L29 using Tapatalk

Honestly I didn't really dig deeper into it because I don't care much about text messages. Maybe transferring to another app with a backup tool and then back can solve the issue?

Gaba90 said:
Honestly I didn't really dig deeper into it because I don't care much about text messages. Maybe transferring to another app with a backup tool and then back can solve the issue?
Click to expand...
Click to collapse
The weirdest thing of them all? I used one sms backup app and it said that it backed up approx 12000sms..so it seems that they are in the device but they are not shown in the app... WTF??
Sent from my CLT-L29 using Tapatalk