Android 9 Pie where are SMS stored please? What is the path to the SMS database?

Question

Android 9 where are SMS stored please? What is the path?

/data/user_de/0/com.android.providers.telephony/databases/mmssms.db — alecxs, Aug 19 '20 at 20:54
Here is my current path:
/moto g(8) plus/Internal shared storage/Android/data
I cannot see anything at the moment with user_de — user1554264, Aug 19 '20 at 20:56
Internal storage /storage/emulated/0 is just a view of /data/media/0 - as you can see that is a subdirectory of /data - for that you need root access — alecxs, Aug 19 '20 at 21:00
Right it's a moto G8 plus. Wondering what the easiest way to root is, sorry about this but need help — user1554264, Aug 19 '20 at 21:01
rooting requires unlocking bootloader (which performes factory reset) — alecxs, Aug 19 '20 at 21:03

score 2 · Answer 1 · answered Aug 20 '20 at 12:41

As mentioned by @alecxs, the sms are stored in the database: " /data/user_de/0/com.android.providers.telephony/databases/mmssms.db" which need root privileges to access it or edit it.

If you don't have root access, you can interact with the table sms in this database using ADB:

list all SMS

adb shell content query --uri content://sms

list SMS from +2121212121

adb shell content query --uri content://sms --projection address:date:date_sent:body --where 'address=+2121212121'

Android 9 Pie where are SMS stored please? What is the path to the SMS database?

1 Answers1

Linked