yashsingh1/xdaforums huggingface dataset:
[Android General] Tatuck:
Hello. I have merged two WhatsApp backups using this process:

Get the keys of the two backups:

ROOT: In /data/data/com.whatsapp/files/key

WITHOUT ROOT: I used WhatsApp Key Database Extractor with this command:

python3 wa_kdbe.py -ar -to

Decrypt both backups:

I used WhatsApp Crypt14-15 Backup Decrypter with this command:

python3 decrypt14_15.py -nm newkey newmsgstore.db.crypt14 newmsgstore.db

python3 decrypt14_15.py -nm oldkey oldmsgstore.db.crypt14 oldmsgstore.db

Now I have two files: newmsgstore.db and oldmsgstore.db

Copy files from newmsgstore.db to oldmsgstore.db:

I used DB Browser SQLite:

Open newmsgstore.db and oldmsgstore.db

Click on Browse Data, then select the message table.

Select the rows of messages you want to copy from newmsgstore.db, right click -> Copy as SQL and save them into a new file like: newMessagesSQL.sql

On oldmsgstore.db remove the rows on which the _id is in the messages you want to copy, if you don't do that, you will get an error from SQLite.

Save the db

Using sqlite3:

Open a new terminal

Use these commands:

sqlite3 oldmsgstore.db

sqlite> .read newMessagesSQL.sql

Use it on WhatsApp Official APP:

Open WhatsApp for the first time if you have just installed it

Force close WhatsApp

Delete all msgstore files on /data/data/com.whatsapp/databases

Copy newmsgstore.db into that path and rename it to msgstore.db

Launch WhatsApp and make a backup
[Android General] amateurninja:
Thank you so much for this guide!
[Android General] HiJustin:
Hi, Can advice where to use the command for step2? the guide looks a bit general to me. thanks
[Android General] Tatuck:
Hello! Yes of course. After you get both keys from step 1 you have to name the key for the old database "oldkey" and the key for the new database "newkey".

Then you need to go to a directory with the files "oldkey", "newkey" and both encrypted databases. After that you can run the commands in step 2 in order to get the decrypted databases "oldmsgstore.db" and "newmsgstore.db".

Now you just need to merge the databases as you want and use the official Whatsapp app to encrypt the database.

I hope you understand better, let me know if you have any other question. Thanks!
[Android General] HiJustin:
Hi,

Thanks for the reply.

Where to run the commands in step 2? Command prompt? I'm using windows.

Thanks

Justin
[Android General] Tatuck:
Hello. Yes, you need to open a CMD terminal on the directory with the files needed
[Android General] paul_007000:
1. It doesn't seem possible to open two databases at the same time in DB Browser SQLite

2. So I opened newmsgstore.db, then CTRL-A to select all rows, then right click - > Copy as SQL.

3. How do I then save these copied rows to a new file? If I do File -> New Database I am asked to Edit Table Definition.

Please could you be more specific. Thank you.
[Android General] Tatuck:
Hello! Yes, I am sorry, I wrote this guide a long time ago and I didn't make it clear.

I think I just opened a new text file, pasted the sql code and changed the name of full filename to newMessagesSQL.sql

I have edited the step 2.3.

Do you think I should do a video so I can explain it better?
[Android General] Royal-Captain:
yes sir please make a long detailed video on this then we can understand better and copy your steps. this will be very easy and helpful for us. thank you so much.
[Android General] paul_007000:
Thanks I have created a new file. My next question is about step 4...

"On oldmsgstore.db remove the rows on which the _id is in the messages you want to copy, if you don't do that, you will get an error from SQLite."

Please clarify. It sounds like I should delete every "_id" row with a number between 1 and x where these same row numbers exist in the newmsgstore.db file, which would mean deleting all of the rows.

Perhaps a video would be very useful.
[Android General] Tatuck:
Oh, I am sorry, yes, as both databases should be from different timestamps, you should delete the messages that have the same ids in the old database.

Is that clear?

Also, I am working on the video, I want it to be very clear. Also, as I am more a Spanish speaker, I will do the video in Spanish and then make subtitles for English.
[Android General] paul_007000:
newmsgstore.db has messages with _id of 1 to 39,134. oldmsgstore.db has messages with _id of 1 to 38,889. If I delete the rows that have the same _id then I would only be left with (39,134 - 38,889) = 245 messages out of a total of 78,023 messages. I must be not understanding you correctly because this seems like I am deleting most of my messages. Could you please clarify. Thank you.
[Android General] Tatuck:
Oh I am sorry. The Ids can't be duplicated, so you just need to set the new messages with a new ID, I mean, if the last message of the old database has the ID 20000, you can add 20000 to the IDs of the new database so they aren't duplicated.

Disclamer: I haven't tried this as deleting some of the messages worked for me.

I hope that works.
[Android General] shayeight:
yes sir.. do you post that video yet?
[Android General] Stambec:
For the _id collision one can easily run an sql command in db browser as Tatuck said, instead of deleting colliding messages.

If im not wrong, sql command (on new.db):

UPDATE TABLE message SET _id=_id+ x ;

where x is the maximum _id present in old.db.

Although, im not sure if that could disrupt some internal references - a message replying to another message, or a media linked with a message? I am both new to sql and first time peeking into msgstore.db, I gotta say frankly it's kind of hard to read thru it.

Tatuck, is it correct to assume that the table message only contains ordinary messages info and not media of any kind?

I need to make a full database merge, everything by hand (for funny reasons)
[Android General] Pacote-san:
No video yet? =/

Will try the currect guide later but will try this tool to merge them

GitHub - natario1/whatsapp-database-merger: Small command-line utility to safely merge multiple WhatsApp backups (msgstore.db) into one.

Small command-line utility to safely merge multiple WhatsApp backups (msgstore.db) into one. - natario1/whatsapp-database-merger

github.com
[OnePlus 7T Questions & Answers] Hemant Dhiman:
Hey guys!

so i was using my mobile OnePlus 7T (Glacier Blue, 8GB RAM, Fluid AMOLED Display, 256GB Storage, 3800mAH Battery) from 2019 till now it suddenly goes into Qualcomm Crash dump mode i was using Instagram (watching reels) and then suddenly it hangs and pink color line appear on screen (horizontal) and rebooted crash dump mode.

its software all stock no custom ROM, no custom recovery locked boot loader.....i didn't even try any of this on my device just battery performance get low with the updates of oxygen OS (Last updated to Android 11).

free storage space when it goes into this state around: 13 to 14GB.

i am able to do following.

Boot to Fast boot mode

Boot to recovery mode (ver 2.0)

Able to charge the phone battery. (WARP charging with blue Bold symbol on switch off screen is visible)

Also attaching screenshots:

Boot process stuck usually here (2 times its boot till lock screen but when i enter my pin to unlock, its get hang and reboot to Qualcomm crash dump):

some time this screen appear all normal and hangs with different pixelated color screen (like its struggling with rendering or something, i will try to take a pic of the same and post here if it comes again.)

View attachment 5733655

Other attachment:

Qualcomm crash dump (without other info just these three words every time)

View attachment 5733657

i can boot into Fast boot mode with (vol up + vol down + power button for few sec)

View attachment 5733659

i can boot into recovery as well with (vol down + power button for few sec)

View attachment 5733661

Not able to boot into safe mode! because only one way i can find to boot into safe mode from switch off menu, which can be access once its get booted successfully.(so luck regarding boot into safe mode)

i need help regarding to save my data. i don't want to loose all my data, if we can restore this OS then please help in that at least i am able to boot into current OS so that i can recover my google auth as well and other apps as well, please anyone help me to recover my data from this issue..after that only i can perform to stock ROM installing process which will i think wipe all my data.

ALSO if anyone can suggest macOS instruction so please suggest...else i have to arrange the windows system for the same.
[OnePlus 7T Questions & Answers] HueyT:
No macOS work around. Needs win10.

Try to switch slot and see if it boots:

While in fastboot mode, type fastboot set_active other, fastboot reboot (if no go, do it again to switch to other slot). If no go, there is no way to save data as unlocking BL will wipe data. To save phone you may have to use msmtool and EDL mode which will also wipe data. You can try to fastboot flash all partitions from oos11 for same variant model (hd1901, Indian variant?) while in fastbootD mode (fastboot reboot fastboot) but may not be doable with locked BL (don't do "fastboot -w" as it'll wipe data)
[OnePlus 7T Questions & Answers] Hemant Dhiman:
@HueyT thanks for the above info...but i really want to save the data on my device anyhow!

I know about the adb and fastboot commands (some basics only for other operation i would take help from here and from google)!

but i didn't get your statement here "You can try to fastboot flash all partitions from oos11 for same variant model (hd1901, Indian variant?) while in fastbootD mode (fastboot reboot fastboot) but may not be doable with locked BL"???? 🤔

I know through adb and fastboot we can run some operation on device!

could you please elaborate more about this command you mention :

fastboot set_active other (what this actually will do?) (does it change my current slot to other?)

fastboot reboot (this will reboot my device normally!)

i know about fastboot, but don't know what is fastbootD mode you mention?

can i unlock my OP7T bootloader without wiping out the user data.

i have done some research for "SDK Platform Tools release" for macOS or else i will arrange the WINDOWS pc if not worked:

through which i can run at least following commands (but not sure didn't try yet first i need information about these commands):

fastboot getvar current-slot (to determine what slot you are on.)

fastboot --set-active= (a or b) (to change to other slot)

AS I HAVE ALREADY MENTIONED ABOVE I HAVE TO SAVE MY DATA ANYHOW, WILL TRY EVERY POSSIBILITY!
[OnePlus 7T Questions & Answers] HueyT:
Yes, switching slot may let u boot using above command. "Fastboot flash boot boot.img" for example will reflash boot sector and let u boot
[OnePlus 7T Questions & Answers] Hemant Dhiman:
so which commad should i use?

which u told me "fastboot set_active other"??

or this one "fastboot getvar current-slot" (to determine what slot you are on.) and followed by "fastboot --set-active= (a or b)"??

and through this process my data will not wipe out??
[OnePlus 7T Questions & Answers] HueyT:
Mine switch slots while yours display current slot. This will NOT wipe data. Most of cases crashdumps are from erroneous slot switching to blank slot--data is shared on both slots
[OnePlus 7T Questions & Answers] Hemant Dhiman:
@HueyT thank you for the explanation, so as i was using my device more than three year and done 2 to 4 official updates of Oxygen OS. still there might a chance that other slot will come out to blank??

because before that i never switch slots manually, this crashdumps error just comes up suddenly when i was using instagram and it hangs up and restarted to crashdumps.
[OnePlus 7T Questions & Answers] HueyT:
Not sure, just try it and see.. Mismatched oos version can cause crashdump also
[OnePlus 7T Questions & Answers] sanket_b:
Hi Hemant,

I also faced the same issue QCDM right on the laxmi poojan evening (:D)

I also want to recover the data first. I want to know if you had any success?
[OnePlus 7T Questions & Answers] Hemant Dhiman:
no luck i was busy in some other task but will update here if i got that issue resolved.
[OnePlus 7T Questions & Answers] AhmedB.:
hello i have same problem

View attachment 5755877
[OnePlus 7T Questions & Answers] tech_infinity:
Hi, were you able to find the solution to this? My friend has the exact same issue. It is fine if data is lost
[OnePlus 7T Questions & Answers] HueyT:
Msmtool will unbrick
[OnePlus 7T Questions & Answers] vvezani:
Hi, I'm having the same issue, how do I know more about Msmtool? Any good tutorial or advice? Is this a hardware or a software issue? I erased all phone data and factory reset and still got it again
[OnePlus 7T Questions & Answers] HueyT:
https://xdaforums.com/t/op7t-oos-11...estore-your-device-to-oxygenos.3994835/unread
[OnePlus 7T Questions & Answers] jerrymani33:
Hi i have same problem as Ahmed mentioned and i tried flash os using msmdownloader still issue is persist. Is this hardware issue or software only?
[OnePlus 7T Questions & Answers] jerrymani33:
I tried to change slot but my mobile bootloader is locked.

.\fastboot.exe --set-active=b
Setting current slot to 'b'...
FAILED (remote: Slot Change is not allowed in Lock State
)
finished. total time: 0.015s
[OnePlus 7T Questions & Answers] jerrymani33:
Did u find any solution?
[OnePlus 7T Questions & Answers] AhmedB.:
It's not software issue it's hardware issue I get a motherboard from broken phone and get phone work

I will give the old board to maintenance to fix it if possible I just want to salvage the data from it
[OnePlus 7T Questions & Answers] editorhuman:
have you found a solution for it?

im facing same problem
[OnePlus 7T Questions & Answers] HueyT:
No saving data with MSMtool to unbrick
[OnePlus 7T Questions & Answers] dARKaRK1002:
Will this method wipe out your data?
[OnePlus 7T Questions & Answers] dARKaRK1002:
T_T

Is their ANY way to recover data from the user partition after the MSM tool format?

I mostly just want my images lot of which I didn't back up.
[OnePlus 7T Questions & Answers] HueyT:
You can try to "fastboot flash..." all individual partitions except data and see if it'll boot to save data. Chances are it won't until MSMtool which will revive phone to factory fresh state losing all data
[OnePlus 7T Questions & Answers] surasuriya:
Guys !! i am in same position right now . Tell me if anything worked . taking the phone back to life without losing data. Please .
[OnePlus 7T Questions & Answers] surasuriya:
i

The last time i was in xda forum , i was using samsung galaxy pop and we were using odin and flashing cyanogen mod ROMs. After those days i was completely on stock ROM till now . Kindly help me with every basic step . Thanks guys in advance
[OnePlus 7T Questions & Answers] Nikhitha_Pithani:
Hello all, my One plus 7T ran into same issue now. I am worried about the data in it, checking if any of your issue got resolved. Please do reply if you found the solution. Thank you.
[OnePlus 7T Questions & Answers] surasuriya:
Not yet . If u got any solution for it kindly let us know .
[Google Pixel 7 Pro] aaronc_98:
I used to do it to flash firmwares but that does not seem to be prevalent any more, so why do I need to root?
[Google Pixel 7 Pro] jaseman:
I know this is a developer/modding site but I have to agree with the OP.

I come here for the general forum information that is "usually" more technical for obvious reasons. But to risk a very expensive tool for unlocking and modding....the risks far outweigh the benefits...IMO...YMMV
[Google Pixel 7 Pro] cd993:
App & system theming (with Substratum + Swift Black, Repainter for pure system AMOLED black & Project Themer for different notification styles, lockscreen clock etc.). System-wide equaliser (currently with JamesDSP but will await VIper4Android working on A13 hopefully), system-wide ad-blocking. Revanced Youtube for background play etc.

Plus with AOSP Mods via Magisk it adds tons on features like customisable quick toggle column/row quantities + label text size, clock position, removing carrier label from status bar, long press power button screen off for torch and so much more! Plus not to mention custom rom support which whilst sometimes buggy, come with a wealth of benefits. I like to stick to stock these days with AOSP Mods & Magisk, as that module has many features and saves having any custom rom bugs (e.g. on Pixel 6 Pro, a custom rom would lose Magic Eraser whereas having a modded stock, retained it)/

I get the risks, but we do plenty of research and tread carefully and all is generally ok!

Got my Pixel 7 Pro just today and bootloader unlocked after the first OTA came through. It's now rooted and without passing safetynet currently, all cards successfully added to my Google Wallet.

Running like a dream

:)
[Google Pixel 7 Pro] Beefheart:
I used to root every one of my previous phones, but I've not done so on my Noted 10 Plus as I find Samsung Pay too useful. And rooting destroys it forever. Not sure if Google Pay still works when rooted, that may nudge me to do it.

I have no plans to root my 7 Pro when it arrives. But that may change.
[Google Pixel 7 Pro] Annie the Eagle:
Naughty boy client for Pokemon GO and system-wide AdBlock
[Google Pixel 7 Pro] davidgro:
For me the main thing is working app backup, since the Google solution is absolutely unreasonable (I have several non-play-store apps that I have had on every smartphone I've owned, and data generally isn't saved with Google anyway) But also tons of little things like being able to set a limit on battery charge level, full (to the extent still possible) filesystem access, a floating CPU monitor I like, Greenify, Island, Tasker stuff, etc.
[Google Pixel 7 Pro] rester555:
System wide as blocking since 2012. No other phone does it better and easier.
[Google Pixel 7 Pro] hey_malik:
How about Banking? I ditched rooting since all Banking apps denied to work. Workaround didn't work anymore.
[Google Pixel 7 Pro] roirraW "edor" ehT:
Custom kernels that save on battery

Better Internet Tiles

ACC (Advanced Charging Controller) and AccA (Advanced Charging Controller App)

@siavash79's thread [MOD][Xposed+Magisk][Pre-Release] AOSP Mods - System modifications for AOSP-based Android 12+. This is a big one for me, personally.

Classic Power Menu

Swift Backup
[Google Pixel 7 Pro] EtherealRemnant:
Just use their website? Or switch banks? I have my primary bank with a local outfit that doesn't care about rooting (although that's not why I got them, it certainly helps keep me there) if I need to deposit a check and everything else can be done on their mobile website.
[Google Pixel 7 Pro] bryan1854:
My main reason would be for the custom Kernels and for Viper4Android. I didn't have a bunch of $ to fork out for 2 new phones so I went with Verizon so I won't be getting either unless I hit the lottery and then buy a Google Version of the P7P.

Anyone remember what made us able to root/ unlock the bootloader On the OG Verizon pixel?

Any chance of that happening on this device or should I just go ahead and do the system update that's waiting? For instance, I know the Samsung Galaxy Note Ultra 20 5G on Verizon(The Device I'm switching from) was locked down but apparently some guy on XDA started an Unlock service and would unlock it for ~$100.
[Google Pixel 7 Pro] galaxys:
I root since it's my XDA addiction! 📱💻⌚🎛️😁

Also add Titanium to the attached list!😎
[Google Pixel 7 Pro] roirraW "edor" ehT:
From memory on the Verizon Pixel 1, there was a bug on Android 7.10, I believe it was, that fully just allowed us to toggle OEM unlocking on. From there it was a done deal. They patched it in 7.11. Again, from memory but it was either that or 7.11 before and 7.12 after.

And no, not likely to happen again. It would be very, very rare and like hitting the lottery. Didn't happen on the Pixel 6 Pro.
[Google Pixel 7 Pro] bryan1854:
Maybe I will contact the guy doing it for the note 20 ultra and see if he thinks whatever he's doing to those phones is possible here.

Thanks for the reply.
[Google Pixel 7 Pro] simplepinoi177:
holy crap, when you mention "Titanium", do you mean the backup?! or even the "tweaker"? either way, aren't those EOL for years???
[Google Pixel 7 Pro] hey_malik:
I don't see how that again helps with tan apps. But sure just don't use it is always an option.
[Google Pixel 7 Pro] EtherealRemnant:
The reality is that forced hardware attestation and the Play Integrity API will soon put an end to the tricks used to get around detection so people will have to figure out what root is worth to them. I decided awhile ago that I can live without it. Adb pull /sdcard does a nice enough backup job for me and Google's cloud backup pulls partial app data and will restore it where applicable.

Of course it does seem that there isn't a way to disable 5G SA on Pixels without disabling 5G altogether so I may have a use for root in the end anyway, time will tell, as I get sick of being stuck on T-Mobile's slow as molasses SA when midband is available.
[Google Pixel 7 Pro] abhi0502:
Well i have rooted every other phone and rooting, installing kernel or roms solve some problem where oem is lazy or will not solve. Previously i was using OnePlus 7 pro with unlocked bootloader initially with Android 9. During Android 10 i prefer to lock bootloader again as during that time i was damm busy and getting time for root and transfer data was not possible. During Android 11 Oneplus had really ****ed up, device was getting hot like frying pan in summer. I really had no choice but to unlock bootloader and installed a stable custom rom(CR Droid) . Everything was perfect. After 9-10 months i thought i willl go to stock again and lock bootloader. But to my surprise cts profile was not getting matched. My phone was constantly recognized as Google pixel 6 pro (no NFC payment and play store dont recognize netfix) . Only safety net fix with Magisk was able to fix it. What really surprise is when i again installed Oxygen OS 10 cts profile was showing match with locked bootloader and with Oxygen OS 11,12 will show CTS profile mismatch. I really don't know what i had done wrong and there is no solution for locked bootloader.

So my suggestion is if anybody really want to unlock bootloader and have magisk prefer with your secondary device.
[Google Pixel 7 Pro] rosic:
Is it possible to unlock 5G in another countries with root while having functional google wallet?
[Google Pixel 7 Pro] trainfire:
I only do it for AdAway. Would be wonderful if I could avoid rooting for blocking ads since it makes a few apps unusable (specificly Norwegian with no rooting community support). But I'll probably root my P7P when I get it on monday.
[Google Pixel 7 Pro] xChickens:
I've been using Titanium Backup for years lol... I'm only just hearing of Swift X_X
[Google Pixel 7 Pro] galaxys:
Haha, yes it's infamous oldy & not updated TB!

I still find it useful for system & user app lists, freezing & defrost apps, uninstalling some user apps, and having bulk options!😉

Google Store "Laws" turned these ground breaking Developers Off & they told Google to take a hike!😁
[Google Pixel 7 Pro] xChickens:
Also wanted to ask, what system-wide ad blocking are you guys using? I typically use AdAway, but when I search up best ad blockers on Google most people say to use the Private DNS feature, which I don't think needs root.
[Google Pixel 7 Pro] cd993:
Yeah still using Adaway
[Google Pixel 7 Pro] Beefheart:
QQ I've not owned a Pixel before, I take it that if you root then unroot, there is no permanent marker left behind to show it has been done, ala Samsung and their hateful Knox flag?

Also, I take it Google Pay can still be made to work whilst rooted?
[Google Pixel 7 Pro] hey_malik:
I use blokada or netguard for mobile usage. At home I simply use pihole on a dedicated raspberry for the entire LAN.
[Google Pixel 7 Pro] Ducter:
You are correct, you can unroot and return to 100% stock and be as it was never rooted. Currently, it appears Google pay does work.
[Google Pixel 7 Pro] Beefheart:
Cheers.

I take it there is a bright res warning on the boot screen when the bootloader is unlocked/phone is rooted?
[Google Pixel 7 Pro] cd993:
Correct.

In the Samsung Galaxy S21 Ultra someone had modded that bootloader unlock screen, would be great if that could be achieved on our device