Android

27530 readers

188 users here now

DROID DOES

Welcome to the droidymcdroidface-iest, Lemmyest (Lemmiest), test, bestest, phoniest, pluckiest, snarkiest, and spiciest Android community on Lemmy (Do not respond)! Here you can participate in amazing discussions and events relating to all things Android.

The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:

Rules

1. All posts must be relevant to Android devices/operating system.

2. Posts cannot be illegal or NSFW material.

3. No spam, self promotion, or upvote farming. Sources engaging in these behavior will be added to the Blacklist.

4. Non-whitelisted bots will be banned.

5. Engage respectfully: Harassment, flamebaiting, bad faith engagement, or agenda posting will result in your posts being removed. Excessive violations will result in temporary or permanent ban, depending on severity.

6. Memes are not allowed to be posts, but are allowed in the comments.

7. Posts from clickbait sources are heavily discouraged. Please de-clickbait titles if it needs to be submitted.

8. Submission statements of any length composed of your own thoughts inside the post text field are mandatory for any microblog posts, and are optional but recommended for article/image/video posts.

Community Resources:

We are Android girls*,

In our Lemmy.world.

The back is plastic,

It's fantastic.

*Well, not just girls: people of all gender identities are welcomed here.

Our Partner Communities:

!android@lemmy.ml

founded 1 year ago

MODERATORS

MargotRobbie@lemmy.world

Rooki@lemmy.world

Thekingoflorda@lemmy.world

L3s@lemmy.world

_MoveSwiftly@lemmy.world

Trying to Modify the WhatsApp local database (lemm.ee)

submitted 9 months ago by spookedbyroaches@lemm.ee to c/android@lemmy.world

8 comments fedilink hide all child comments

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?

all 11 comments

sorted by: hot top controversial new old

[–] stifle867@programming.dev 8 points 9 months ago (1 children)

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?

[–] spookedbyroaches@lemm.ee -1 points 9 months ago (1 children)

I can but then the photos are gonna be duplicates which would take up a lot of space

[–] Tippon@lemmy.dbzer0.com 6 points 9 months ago (1 children)

Why don't you just move the photos back?

[–] spookedbyroaches@lemm.ee -1 points 9 months ago (1 children)

Then I can't see them in the chat since they're in a different location.

[–] Tippon@lemmy.dbzer0.com 5 points 9 months ago

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.