Cross posting from Reddit, hoping to get some help:
I've got a Droid Turbo, and manually updated it to Android 6.0 Marshmallow earlier today (it's rooted and thus I don't take OTA updates). Before updating I backed everything up with Titanium Backup and wiped my phone, as I've done in the past. Upon booting into the ROM I restored all of my apps & data, which reinstalled Google Messenger (the SMS app I use) along with all of my text messages.
However, upon opening Messenger it starts systematically deleting all of my text messages. It has all of my texts for a few seconds, but then I watch as it starts marching backwards through time, deleting all of my texts from the two years I've had this phone. The most recent text goes from being today, to a week ago, to November, back into last summer, 2015, etc.
I've tried all of the obvious things - I've disabled the other SMS programs, restarted my phone, etc. Every time I restore the data to Messenger it does the same thing - showing everything to start and then automatically deleting everything over a few minutes.
I presume this is caused by some incongruity between Messenger's history of my texts and the history of texts somewhere else on the phone, but I'm not really sure what else to do. It's so strange, especially since I've gone through wipes / updates before without this happening. I've tried several SMS Backup/Restore apps after restoring the data (before Messenger deletes it all) and they all list my phone as having zero messages / conversations to back up. This further reinforces my theory, I guess.
So what can I do? I'd rather not lose two years of texts - even a plaintext backup would be nice at this point.
THANKS GAF.
EDIT: Okay, I've done some more digging and here's what I've figured out. Essentially while I backed up and restored the Messenger apps database file (bugle.db and bugle.db-journal) I failed to back up the system's mmssms.db, stored in /data/data/com.android.providers.telephony/databases/. When Messenger boots up it sees this incongruity and tries to rectify it by deleting all messages the mmssms.db doesn't have a record of.
I have tried a few different things, all to no avail. Replacing the mmssms.db databases with those from Messenger (bugle.db, renamed in order to overwrite) stops the app from cannibalizing the messages but causes it to crash upon opening a message thread. Deleting the databases altogether has the same effect.
The question is - is there some way to migrate the bugle.db into mmssms.db?
Or is there some way to stop Messenger from consulting mmssms.db long enough to allow backing up messages?
Or is there some other way / program with which to read Messenger's bugle.db?
EDIT 2: I've discovered that I can open the bugle.db in SQLdatabase software such as DB Browser. I've figured out how to browse the list of conversations and a massive dump of every text message but haven't yet figured out an efficient way of exporting each conversation thread as an xml file or something similar. From googling around it seems like there IS a way, but I need to know more than I do about SQL databases.
Does anyone know how to make sense of these mms/sms.db files in an SQL database environment and organize them into .xml files? I may repost this separately seeing as the question has changed considerably.