How to repair whatsapp corrupted database (msgstore.db) please help - Android Q&A, Help & Troubleshooting

Im sorry but i need urgent help with my WhatsApp .
I did a full backup of my whatsapp in the morning using titanium backup and its said backup complete 100% then around 5PM my whatsapp crashed and started saying initializing untill it started up on the "Agree to continue " stage which meant it had started over againand at that time my whatsapp data got wiped ... I tried restoring my earlier backup using titanium back again but it failed (although it says restore complete ) as soon as i try to open whatsapp it crushed 3 times till it wiped the restored data again.
I dont have the mgstore.db.crypte12 files cz i delete them never seeing id need them like now... It seems my unencrypted database is still with me but (512mb size) but is now like mgstore.db.corrupt and whatsapp won't read the file but i need all the chats back. If anyone can help me please i have some locked away chats and willing to pay if i can recover them
My phone is rooted and i tried backup whatsapp again and its restoring back to nornal now but without my old chats!:crying: i want a way to restore chats in thad mgstore.db.corrupt file please.
Thank you in advance..Ive attached the a screenshot of the corrupt file.
Ps; i have spent all night researching about this but cant find anyway to repair the (msgstore.db) database please any help??..Im gonna try data recovery software for sqlite seeing thag its the same as the database whatsapp uses but i want a positive fix plz

Have you tried merging messages with sqlite?

Android.Play said:
Have you tried merging messages with sqlite?
Click to expand...
Click to collapse
Is there a way to add them back to db format after merging?

Related

[Q] Viber messages backup anyone?

Can any of the Viber users or soft dev guru help on this little problem.
I love Viber and I love my SGS2, now after few months of owning and learning, I want to start playing around specifically changing my Rom and what not.
Now my problem is i have 13,000+ exchange messages with my GF on viber and I really wanna keep it, as i understand that when I change my Rom I have to do a data wipe and all. I know there's a backup/restore function but is there a guarantee that i can restore Viber with all the messages still there?
Can someone provide a walk around? I have tried google for solution and used the search here but there was nothing except the android team saying its something that they "might" incorporate in the future - that's backing up of the messages.
I hope other users are on the same ship with me here. thanks in advance...
It is posible via Titanium backup, but you need get root on your SGS2 first.
On a rooted phone copy the /data/data/com.viber.voip/databases/viber_messages file to sd-card or whatever.
After new install, put the file back, make sure it has the right permissions and do a compleate restart of Viber.
Done and done.
(Its very lazy of Viber to not include a backup-functionality of messages, as this is SQLite databases that could very easily be dumped out to disc and imported)
Olangu said:
On a rooted phone copy the /data/data/com.viber.voip/databases/viber_messages file to sd-card or whatever.
After new install, put the file back, make sure it has the right permissions and do a compleate restart of Viber.
Done and done.
(Its very lazy of Viber to not include a backup-functionality of messages, as this is SQLite databases that could very easily be dumped out to disc and imported)
Click to expand...
Click to collapse
good trick, agree that viber is lazy
viber message storage
I could not find /data/data/com.viber.voip/databases/viber_messages in my LG CM7.2 Android.
I need help, Please can anyone confirm me again please where viber is stored messages locally?
Olangu said:
On a rooted phone copy the /data/data/com.viber.voip/databases/viber_messages file to sd-card or whatever.
After new install, put the file back, make sure it has the right permissions and do a compleate restart of Viber.
Done and done.
(Its very lazy of Viber to not include a backup-functionality of messages, as this is SQLite databases that could very easily be dumped out to disc and imported)
Click to expand...
Click to collapse
I have the same problem with backup and restore old Viber messages. I managed to backup (or rather email messages history) from my old HTC Desire but could not restore them on my new Samsung S3). What's the use of backup without restore function?
Oh! I can't find /data/data/com.viber.voip/databases/viber_messages on SD card too. Any suggestions?
Thanks,
Copying the database doesn't work for me. Here's what happens:
When I make a fresh installation of viber and replace the empty (fresh) /data/data/com.viber.voip/databases/viber_messages database file with my backup (old) one, viber crashes every time I launch it. I was careful to set permissions to rw- rw- --- as the fresh file has them.
What can I do - maybe export the records in the backup db file and reimport them into the fresh one?
If the previous question has no easy answer, at least can someone tell me what's happening so I can try to figure out an alternative approach?
Hello,
I've successfully backuped and restored Viber on my S III but I've got an issue with contact names: it randomly picks another contact name instead of the real one.
Anybody had the same issue? How did you solve it?
thanks!
tizio84 said:
Hello,
I've successfully backuped and restored Viber on my S III but I've got an issue with contact names: it randomly picks another contact name instead of the real one.
Anybody had the same issue? How did you solve it?
thanks!
Click to expand...
Click to collapse
I have the exact same problem. Once upon a time, I had an older version of the software saved on TiBu which I was able to restore and the messages stayed to the right person. Unfortunately, I don't have that version or backup anymore. I just downloaded another older version of the software from a thread here on XDA and I'm about to install it and see if it fixes the messages list problem...
Update: That version wouldn't open on my phone, it just FCed (could be because I'm running the vzw jellybean leak). Off to search for another version...
aungsan said:
I could not find /data/data/com.viber.voip/databases/viber_messages in my LG CM7.2 Android.
I need help, Please can anyone confirm me again please where viber is stored messages locally?
Click to expand...
Click to collapse
Only Root Explorer can see that folder, worth the $3.75 i paid :good:
Restore from viber message.zip
Hello, i got a different problem on restoring my messages, i tried rooting my android and i got the back up and restore from the TI back up and it worked good, but my prob is, is there a way that i can restore the viber message .zip which is sent to me from email, back to my viber, cause i thought when i backed it up, i can also restore it, and i didnt know that time that viber doesnt have a restore function, so i deleted all my messages and i those messages are very important, can someone help me please? Thank you in advance!!
elitebetan said:
Hello, i got a different problem on restoring my messages, i tried rooting my android and i got the back up and restore from the TI back up and it worked good, but my prob is, is there a way that i can restore the viber message .zip which is sent to me from email, back to my viber, cause i thought when i backed it up, i can also restore it, and i didnt know that time that viber doesnt have a restore function, so i deleted all my messages and i those messages are very important, can someone help me please? Thank you in advance!!
Click to expand...
Click to collapse
The file on the phone is an SQL Lite database.
Probably you could copy it to your PC, import the data, copy it back and have the database repaired.
I just restored the whole "com.viber.voip/databases" folder, and it works perfectly. all messages etc are there.
Hello I also have a problem with backuping my Viber messages.
Today I've done a software update. I'm using Samsung I9105P (SGS II+ with NFC). The update was from 4.1.2 to 4.2.2. I did a normal copy of data\data\com.voip.viber\ and full app+data backup with Titanium Backup.
So this is what happens:
Everytime I restore data with Titanium the app starts normally and then I'm always asked to type in my phone number and the activation code. Before doing that all messages do exist. I know that because I am able to close these dialog windows with "back button" and look on the messages but I'm unable to normally use viber (I mean send and recieve msgs). After applying the activation code the message tab appears without any message. It happens like this everytime.
I also tried to just paste the "databases" folder or just the "viber_messages" file but both of these actions end with appcrash and then i need to reinstall it or just back up data with titanium (and then it's all the same as I wrote above - I mean activation code etc.).
I have several thousands of messages and I don't really want to lose them. Especially looking on the fact, that I've restored up my viber messages for a few times when I've been using Samsung Galaxy S (i9000) and also transferred them on this phone.
Any ideas for a solution? I'd be grateful. :fingers-crossed:
Same problem here! I can see the messages at first (after restoring APK + data from titanium or mybackuppro), but Viber wipes them when it asks me to reactivate. This whole thing is a mess. Anyone know a possible solution? I also have lots of messages that are important and I would like to restore.
I have exactly the same problem with the one the two last users are dealing with.
As soon as i got updated to Android 4.3 and restored Viber and its data with Titanium Backup, the first time i run Viber i can see my messages for 1 or 2 secs and then activation screen appears. After finishing app's activation i can't see my messages anymore..
Swyped from my Nexus 4 using Tapatalk 4
ajoh99 said:
Same problem here! I can see the messages at first (after restoring APK + data from titanium or mybackuppro), but Viber wipes them when it asks me to reactivate. This whole thing is a mess. Anyone know a possible solution? I also have lots of messages that are important and I would like to restore.
Click to expand...
Click to collapse
tsiftsism said:
I have exactly the same problem with the one the two last users are dealing with.
As soon as i got updated to Android 4.3 and restored Viber and its data with Titanium Backup, the first time i run Viber i can see my messages for 1 or 2 secs and then activation screen appears. After finishing app's activation i can't see my messages anymore..
Swyped from my Nexus 4 using Tapatalk 4
Click to expand...
Click to collapse
If you have a titanium backup, unzip the backup file and extract the viber_messages file and replace the one in /data/data/com.viber.voip/databases/viber_messages by root browser. It worked for me.
seawind107 said:
If you have a titanium backup, unzip the backup file and extract the viber_messages file and replace the one in /data/data/com.viber.voip/databases/viber_messages by root browser. It worked for me.
Click to expand...
Click to collapse
Yeah that's the way to do it, but it didn't work for me and the other 2 guys who wrote below my post.
Syfeeq said:
I also tried to just paste the "databases" folder or just the "viber_messages" file but both of these actions end with appcrash and then i need to reinstall it or just back up data with titanium (and then it's all the same as I wrote above - I mean activation code etc.).
Click to expand...
Click to collapse
+1
Have the exact problem with TB and activation process, messages are gone after activation, but i have the solution that worked for me:
In TB folder find com.viber.voip-(some numbers).tar archive
open \data\data\com.viber.voip\.\databases
find both "viber_messages" AND "viber_messages_journal" files
copy them to \data\data\com.viber.voip\databases on the phone
change permission for viber_messages to RW RW --
change permission for viber_messages_journal to RWX RW --
restart phone and that's it, you will have all your messages
zoozth said:
Only Root Explorer can see that folder, worth the $3.75 i paid :good:
Click to expand...
Click to collapse
You can do this with ES file explorer, just go to settings/display settings/ and tick "show hidden files", great program and it's free :good:
Got my messages back, but the photos/doodles are not displayed in the chat-thread. empty images. when you click on them to view them bigger, they are displayed.
any idea how to get the thumbs in chat back?
Try to reboot phone, or delete cache in settings/applications/viber. For me everything is ok.

[Q] HTC Explorer SMS deleted on booting

Dear Masters,
I have a problem that some of my SMSs are getting deleted after reboot, might be due to default cache clear or something else, but I am really stucked at that, please do help...
Can I recover the deleted SMSs? I dont have any backups as well as no backup softwares, please do guide.
Chin2. :cyclops:
chin2h said:
Dear Masters,
I have a problem that some of my SMSs are getting deleted after reboot, might be due to default cache clear or something else, but I am really stucked at that, please do help...
Can I recover the deleted SMSs? I dont have any backups as well as no backup softwares, please do guide.
Chin2. :cyclops:
Click to expand...
Click to collapse
First off check out these three guides for recovering deleted texts:
1. How to Find Saved Text Messages on SIM Card
2. How to Retrieve Text Messages from Someones Phone
3. How to Restore Deleted Text Messages
Next I would get an application like SMS Backup + this will backup and restore your SMSs to Gmail and Google Calendar you can also schedule it to backup up your SMSs automatically.
Finally after you have safely backed up your current SMSs find the application and select clear default cache and see if that works. Hope this helps you

Viber restore problem

Hey guys!
I have done this a million times earlier but now facing a rather annoying problem while restoring Viber's data with Titanium Backup Pro. I had made a backup, but then something went wrong and I had to format the my OB. Now, when I am trying to restore the data on a fresh install of Viber (using .apk file) using Titanium Backup, it restores the data well but then it within a half a second, sends me back to the 'Enter your mobile number' page. The backup that I am trying the restore from was made on the same ROM and the same version of Viber. I have been able to do the same thing so many times earlier but now. I cannot really verify the number as it has expired already but that's my contact number for Viber with everyone around contacting me with that number on Viber/Whatsapp. Please help! I have tried deleting data/data/com.viber.voip and then reboot. Tried deleting viber folder in the sd-card. I have tried copying the com.viber.voip directory from an update.zip created earlier to the data/data directory but to no avail. I have 2-3 backups of viber data but none seem to be working. I really need your help. While whatsapp is working with that number but for calling purposes, I require Viber to be working on that number.
Thank you - awesome people!
slyfth said:
Hey guys!
I have done this a million times earlier but now facing a rather annoying problem while restoring Viber's data with Titanium Backup Pro. I had made a backup, but then something went wrong and I had to format the my OB. Now, when I am trying to restore the data on a fresh install of Viber (using .apk file) using Titanium Backup, it restores the data well but then it within a half a second, sends me back to the 'Enter your mobile number' page. The backup that I am trying the restore from was made on the same ROM and the same version of Viber. I have been able to do the same thing so many times earlier but now. I cannot really verify the number as it has expired already but that's my contact number for Viber with everyone around contacting me with that number on Viber/Whatsapp. Please help! I have tried deleting data/data/com.viber.voip and then reboot. Tried deleting viber folder in the sd-card. I have tried copying the com.viber.voip directory from an update.zip created earlier to the data/data directory but to no avail. I have 2-3 backups of viber data but none seem to be working. I really need your help. While whatsapp is working with that number but for calling purposes, I require Viber to be working on that number.
Thank you - awesome people!
Click to expand...
Click to collapse
Same problem. Were you able to restore them now?
danipan said:
Same problem. Were you able to restore them now?
Click to expand...
Click to collapse
No, I wasn't able to restore the backup. However, I blame it on the corrupted backup data as there's no other reason I can think of. Maybe that is what happened with your backup file too!
Condolences! :angel:
slyfth said:
No, I wasn't able to restore the backup. However, I blame it on the corrupted backup data as there's no other reason I can think of. Maybe that is what happened with your backup file too!
Condolences! :angel:
Click to expand...
Click to collapse
I'm sorry to hear that. But I was able to restore mine. It is definitely not corrupted. I can't remember the exact steps but unzip the viber backup in titanium and copy viber messages and viber messages journal and paste it to data/data/com.viber.voip
If you were unable to follow my steps, then maybe you could search it here in xda. Good luck!

Restore Whatsapp from msgstore.db

I tried to backup/extract my whatsapp database using this tutorial. The extraction also worked, however the restoring afterwards failed and now I have an empty whatsapp, a decrypted whatsapp chat and lost all information of the last 7 years.
Is there any way of restoring whatsapp fron the extracted files (chatsettings.db, msgstore.db, wa.db, whatsapp.cryptkey)? It would be so painfull if all of the data is gone (even though, I have it as a db - it would be gone in Whatsapp which would still be insanely sad).
I hope that anyone can help me, because I'm really desperate. If you need any more information, please feel free to ask.

FMWhatsapp crypt14 database reader, Please HELP

Hi, I need help regarding reading my FMWhatsapp Database that is .crypt14, Now this is what happened with me and I am helpless from all sides..
I was using Fmwhatsapp from last 1 year, Just last week, My phone number which I was using for my business in FMWhatsapp stopped working so I decided to change my number, I changed my number then and sent a message to almost 20-30 people at once.. After sending msgs, immediately i got a error showing you cant use whatsapp for spamming.. something like this. FmWhatsapp shuts down then and when i reopen it, it again shuts down without any interface, it happened everytime i tried to open it. So i decided to copy my FMWhatsapp folder to sd card, and decided to uninstall it and install whatsapp, after I done it, When i tried to restore chats in whatsapp, it again and again said, We cant restore your chats, please try with old chats.. I checked everything to read my whatsapp database and everything pointed me to toot my device first, I rooted my device, for that i had to reset my phone to unlock bootloader, in which i think i lost my key file for fmwhatsapp..
Now , i got the reason why i cant restore chats are because, i have changed the number and backup was made on old number. For reading database, i need key file which i dont know how i can get appropriate key bcz it was deleted while resetting... Can anybody help me by any means please...?

Categories

Resources