Restore mmssms.db on non-rooted 6T - can it be done? - OnePlus 6T Questions & Answers

I have backed up my mmssms.db file from my (screen broken) original OnePlus One. To do this backup, through ADB, I needed to be root to access the data partition.
I'm set to receive the new 6T (didn't like the size of the 7pro) in the mail today.
Using ADB is there a way to restore my SMS/MMS database file without rooting the new 6T? If not, that's fine, I'll unlock and root the phone. I purchased direct through OnePlus so I shouldn't have any T-Mobile issues (paying off and waiting 40 days before unlock code/token is given).
Thanks in advance!

I don't know if you could take a .db file from one device and install it on the another. However, what you could do is place the .db file on your new device and use an app like SqLite DB Reader and open it and view it.

Related

[Q] Cannot delete some folders

So I have a few folders which cannot be deleted. ES file explorer just says xxx cannot be deleted. I can rename the folder but not move or delete. I'm guessing there is a problem with one of the files in the folder but there are loads.
I origionally rooted the nexus 7 so I could use sixaxis but found too much lag compared with plugging in the controller so decided to return to a stock image. I did an app+data+sd card backup with nexus tools and it was after doing this I have had this problem. (also most of my games which I backed up lost their saves - wheres my water, dead trigger + others is this normal for these games?)
Any advice much appreciated
(oh since applying the stock image I no longer have root)
Could be a file permissions problem, try rooting your device again then changing permissions on the files to give yourself full read/write access to these files.
If this doesn't work you could try deleting them through the command line, but this would also require you to root your device again.
Hope I helped.
Hi thanks for your suggestion. I completely forgot I posted this. Anyway I rooted my device using the toolkit and all worked well. But I still cannot delete many folders and files and also some apps don't seem to be able to save properly.
Does anyone have any ideas on what could be wrong? Apart from this the system is stable and I would rather not do a fresh install because of all the games I have (long downloads and I have had problems backing up and restoring saves in the past) is there a way to just set all the files and folders on my phone to read / write (es file explorer reports these files have the required permissions but maybe setting them might do something)
Sent from my Nexus 7 using xda app-developers app

[Q] mmssms.db recovery

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.

[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.

How to edit the /sbin/.magisk/config file to do seamless OTA with Magisk

After rooting with Magisk, users of Moto G6 are faced with the “Stock Rom does not exist” error at the Restore Images step of Magisk’s OTA Upgrade Guide. However, the following suggestion was made in the discussion following issue #1870 on Magisk’s git-page:
The backups should be kept in /data (/data/stock_boot_<hash>.img.gz)
You could probably edit /sbin/.magisk/config to point to the backup you want by putting your <hash> after SHA1=
Click to expand...
Click to collapse
With Solid Explorer, I found different directories called /data in Root and in Internal Memory, but only the one in Root had a ./data/ subdirectory. Is that the one to which I should download the stock rom
ALI_RETAIL_9.0_PPSS29.118-15-11-9_cid50_subsidy-DEFAULT_regulatory-DEFAULT_CFC.xml.zip
which was posted in March, before the latest OTA release? Do I extract this zip, create an img.gz file from the .xml file and rename it stock_boot_<hash> before putting it there? Is <hash> blank-notation for any name that I give it, and which I then add after the “SHA1=” in /sbin/.magisk/config?
Finally, how do I edit the config file? I was able to get to it with Solid Explorer after checking the option to show hidden files in /sbin/. However, I couldn’t send this file to my computer by sharing it through email or messaging apps, as they all denied sending it. Apparently, it’s being blocked by anti-viruses. In this case, is there a safe way to transfer it to a computer, where I’ll be able to more comfortably edit it? Alternatively, if I just omit <hash> in naming stock_boot_.img.gz, can I leave config the way it is?
Best regards!

Open Source SMS/MMS Backup

Hello everyone and Happy New Year !
I was just given a NON-rooted Galaxy J5. I would like to recover the SMS and MMS to return them to its former owner in a readable form (HTML or individual files and also extract the images from the MMS). I just tested Epistolaire under F-Droid and I recovered the JSON export with adb under Linux, but I cannot convert to HTML. I do not want to synchronize with GAFAMs, I want a local solution. I saw another solution wich consists to recover with adb the sqlite database of SMS/MMS but I can not do it because it requires root privileges (but to root, you have to make sure that the data is saved before ?!? => it bites the tail ).
Do you have a solution for me?
With adelphity,
lnj

Categories

Resources