Trying to Modify the WhatsApp local database
Trying to Modify the WhatsApp local database
Motivation
So this is probably a strange request but I really want to do this. For some reason, when I restored the WhatsApp chats most of the photos there got to the private directory where it doesn't show on my android gallery. I don't know what happened but there is no official solution to get the photos back. So I thought why not do it myself.
What I already did
I rooted m phone (temporarily) to get access to the msgstore.db file so that I can change the paths of the media. I can do that easily with a sqlite query.
What I couldn't do
When I try to modify the actual database, it says that I cannot do it since the file got corrupted. I think there might be a checksum or something somewhere but I can't seem to find any information about it. Does anyone know how I can do this without tripping the integrity checker?
If the photos go to a private directory but you are now rooted you should be able to directly access that directory and copy the files out. This is assuming that they are stored as regular files in that directory instead of being solely in the sqlite db. Does that work?
Why don't you just move the photos back?
Then I can't see them in the chat since they're in a different location.
WhatsApp expects to see your images in the images folder. Move the photos into that and they should be picked up. The folder should be
Android/media/com.whatsapp/WhatsApp/Media/WhatsApp Images/
The private folder is a subfolder of WhatsApp Images, so you should just need to move them up one level.