Database Info

[Q] Who has root his phone, help me plz...NEED HELP!

I'm searching for those people who have root their phones.. if you are the guy and willing to help me... please email me... I just need your help for about 10mins only... PLZ
ANYONE root his phone already? I need Help...
Very easy...
Steps: You need to
1. root your phone first..
2. install ASTRO File Manager (by metago) or other else
3. install SMS Backup & Restore created by Ritesh Sahu
4. backup all your messages by using SMS Backup & Restore and name the backup file as 1.xml
5. using ASTRO, go to /data/data/com.android.providers.telephony/databases/ and you will see a db file called mmssms.db (it is the file where all your messages stored in the phone)
6. copy the mmssms.db to your sd card (anywhere, as long as you can remember where it is)
7. copy the MMSSMS.DB (my db file, will be sent to you later if you can help) and paste it in the /data/data/com.android.providers.telephony/databases/
8. then go to messaging, check if my messages can be shown at there
9. if yes, please backup it by using SMS Backup & Restore and name the backup file as 2.xml
10. then by using ASTRO file manager, go to /mnt/sdcard/SMSBackupRestore, you will see 2 xml files, (1.xml & 2.xml)
11. please send the 2.xml file to me, thank you.
12. Recovery! go to messaging, delete all messages (my messages), then restore it by using SMS Backup & Restore, choose 1.xml
13. If failed, go to /data/data/com.android.providers.telephony/databases/, replace the db file by your own mmssms.db file which is stated in step 6...
Anyone can help me?
Some of the messages inside are my beloved messages. I wanna keep it..
if you can help, add me in Facebook (Kh Coon)(got a baby reading books)
or reply me at here...

[Q] Restore sms archive from smsmms.db file

Hi. I'm using CM9 on my Galaxy S I9000 and I accidantally installed the latest nightly of CM7 instead of CM9 on my phone. My message archive was gone, I couldn't reach it, so I backup of database folder from ../data/data/android.provider.telephony with root explorer and installed CM9 with wiping all the data.
Now when I copy smsmms.db and telephony.db to data folder and making a restart, android keeps giving me android stopped working error. and of course no messages at all.
Is there anyway that I can backup my sms archive??
Thank in advance

[Q] Unable to restore Text Messages with TitaniumBackup

Devide:LG Nitro HD
ROM: Jellybam v3.1.0
Rooted: Yes
I updated my ROM this morning and found myself unable to restore my textmessages. The backup files made by Titanium were named
"com.android.mms-20121204-(random numbers).tar"
"com.android.mms-20121204-(random numbers).proprieties"
"com.android.mms-(random HEX).apk"
How can I change the .tar and/or the .proprieties to a .XML format for me to be able to restore my text messages? I really need to figure this asap!

[Tutorial] How to restore SMS and Contacts from old CWM backup.

Normally, to restore SMS or MMS from an old backup, one can just restore the nandroid backup, use a third party SMS backup program to backup the data to sdcard or gmail, restore or install new rom, then restore the SMS from the third party backup software.
However, in my case, I had a nandroid with data on it that I wanted to keep but that wouldn't boot.
So I did some searching and others have had this problem before but I figured I'd put it here for others that may have the same problem. I am not taking credit for this I just found various pieces of info around the web and xda.
Requirement:
1. Winrar.
2. CWM backup
3. Windows
4. Brain
Here's the process:
To restore SMS/MMS from a CWM backup using MS Windows:
1. Install Winrar on your system
2. Open CWM backup folder
3. Now extract data.ext4 on your system
4. The contents of the data.img will be extracted to this folder. Wait for extraction to complete
5. Browse to data\data\com.android.providers.telephony\databases in the extracted folders
6. copy mmssms.db, mmssms.db-journal, to sdcard
7. use root explorer to copy these three files to \data\data\com.android.providers.telephony\databases
To restore contacts/call log from a CWM backup:
Repeat above process for \data\com.android.providers.contacts\databases
contacts2.db, contacts2.db-journal
Note: Be aware that replacing the existing files with those extracted from the backup will remove the existing data so if you're not 100% sure what you're doing, change the names to mmssms_OLD.db or otherwise back them up before pasting the files from the backup.
NOTE : You can also use Nandroid Browser , Nandroid Manager

Sorry to say.....not worked for me....

good work

Thank you, it works on my Samsung Galaxy S2 Gt-I9100,
you are my Hero.

I had no luck with this as the app versions seemed to differ. But there's this awesome python tool on github -- github.com - t413 - SMS-Tools -- which let's you export the db file's content into an xml file which can then be restored with "SMS Backup & Restore". That worked!

[TUTORIAL] Backup of viber messages All in One

Hello,
I've recently been working to backup all of Viber messages/conversations along with media files.
Came across multiple threads and solutions. Wanted to gather them up here for everyone struggling with it, so we don't waste time again.
Here are solutions:
1. Posted by @rsadalarasu https://forum.xda-developers.com/showpost.php?p=54406849&postcount=51 :
rsadalarasu said:
Hi, I have been trying to restore the viber messages whenever i change phones but i never had possible solution to fix the problem.
Today i was trying something and interestingly it worked!! Try to follow the below mentioned steps it might work for you too..
1) Take a backup of the viber using Helium ( https://play.google.com/store/apps/d...a.backup&hl=en ). This app works both for rooted and non rooted phones. For non rooted phones you have to connect to computer to activate the backup mechanism.
2) Install Helium in your new phone and select restore and sync option and then select the old device ( which will show up if you are in same wifi) and then select viber app and restore it.
3) Now open the viber app - Viber as usual ask for activation, just activate the it. This time you will not get the restored messages.
4) Again try to repeat the step 1 and step 2
5) reboot the phone and open the viber app. dont be surprised it will again ask for activation. Activate it again, but this time you will see all the old messages in viber.
6) to get the pictures and videos, copy the Viber Images/ Viber Videos from SDCARD -- > viber --> media from old phone to new phone.
Hope it works for all
Click to expand...
Click to collapse
2. Posted by @MeraVeer https://forum.xda-developers.com/showpost.php?p=63105431&postcount=81 :
MeraVeer said:
Fool Proof Guide to fix Viber crash and restore messages/data
Force Stop Viber
In TitaniumBackup folder find com.viber.voip-(some numbers).tar archive
Open \data\data\com.viber.voip\.\databases using file explorer in android or transfer the .tar file to computer and open with WinRar program.
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 --
And change the "group" and "owner" to same as the com.viber.voip folder - these are the permissions needed for the Viber app to access those files or it will constantly crash.
Restart phone and that's it, you will have all your messages
Click to expand...
Click to collapse
3. Posted on StackExchange by @gabor_ http://android.stackexchange.com/questions/68796/how-to-transfer-viber-message-history-to-a-new-phone/123260#123260 :
You can do it without root access
Requirements:
Install ADB and OpenJDK 8 (I had nothing to do with security extension) by following adb backup guide on XDA
Download adbextractor
Then do
Code:
sudo apt-get install openjdk-8-jre-headless
sudo apt-get install android-tools-adb android-tools-fastboot
Now, do the following
Connect the old mobile, create backup with adb backup (disable WiFi and data and forget the old phone)
Code:
sudo adb backup com.viber.voip -f /home/user/Downloads/viberoldphone1.ab
sudo java -jar abe.jar unpack /home/user/Downloads/viberoldphone1.ab /home/user/Downloads/viberoldphone1.tar
Install Viber on new phone and activate Viber, connect the new phone and create backup with adb backup
Code:
sudo adb backup com.viber.voip -f /home/user/Downloads/vibernewphone2.ab
sudo java -jar abe.jar unpack /home/user/Downloads/vibernewphone2.ab /home/user/a/vibernewphone2.tar
Open TAR archives in an archive manager (found Archive manager for GNOME 3.14.2 on my Lubuntu LiveCD). Copy files below from viberoldphone1.tar DB directory to vibernewphone2.tar
viber_data
viber_data-journal
viber_messages
viber_messages-journal
Repack to .ab and restore data to phone
Code:
sudo java -jar abe.jar pack /home/user/a/vibernewphone2.tar /home/user/Downloads/vibernewok.ab
sudo adb restore /home/user/Downloads/vibernewok.ab
Works like a charm. I have just tested on Android 4.1 and 5.0. I run into problems on Win7 with adb so finally used Lubuntu.
You can try to edit Viber DB files with SQLite editor. Probably DB files could be restored directly but I had no time to test
References:
http://dbremes.wordpress.com/2013/02/11/how-to-get-a-backup-of-your-android-applications-database-in-windows/
http://stackoverflow.com/questions/2078710/android-adb-access-to-application-databases-without-root
Click to expand...
Click to collapse
4. Posted by @kmmc https://forum.xda-developers.com/showpost.php?p=53093637&postcount=2 :
kmmc said:
Smile Fixed! Android Viber Backup and Restore Successful
Okay, thank Jesus I managed to get this fixed and this is what it took.
This solution required a Rooted device.
Restore Viber backup (for me I did this using MyBackup Pro)
Install SQLite Debugger from the Play Store
Using SQLite, try locating the Viber database files by selecting App then choosing Viber from the list (if you want to locate the database manually, for me it was under /data/data/com.viber.voip/databases)
Choose the "viber_data" database
Open the database, scroll to the bottom, choose "Create backup"
Save the backup somewhere on your SD card (not inside the viber folder or else it will get deleted)
Repeat the same steps for the "viber_messages" database
Uninstall Viber (or if you are using MyBackup Pro, go under Toolbox and "Wipe the Cache & Data" for Viber)
Reinstall Viber so that a fresh, clean working set of databases are generated by the app (or re-open Viber)
Do the usual setup of entering your phone number, letting it sync contacts etc
Once Viber has settled down, close it
Re-open SQLite Debugger
Navigate back to the "viber_data" database
This time, choose Restore Backup
Select the backup file from your SD card
Kill Viber if requested and wait for the restoration
Rinse and repeat for the "viber_messages" database
Once it is all done, reboot your device and hopefully, the next time you open Viber, the old messages & calls are all there! Unfortunately for me, presumably due to the change in ROMs, the photos sent in Viber messages are in my Gallery but NOT in Viber itself.. I suspect this can be fixed if the path is saved somewhere in the messages database - but right now, I'm just glad to have the text back.
If you get repeated errors from Viber during this process, try freezing the app using MyBackup Pro Toolbox (I believe Titanium Backup also has this option)
====
If this helped you, please click the THANKS
Click to expand...
Click to collapse
5. Posted by @lordalireza https://forum.xda-developers.com/showpost.php?p=56294723&postcount=62 :
lordalireza said:
Thumbs up This one is gold
OK Guys this is the only 100 percent way and after restore the activation screen wont ruin every thing
first: u need you backed up com.viber.voip .tar.gz file
second : u creat an empty zip file by right click . create zip
third: you drag the data folder that was in .tar.gz file and drop it in the zip file
fourth: you rename the zip file the same az .tar.gz file
fifthpen the zip file go into "com.viber.voip" folder inside the zip file and remove everything exept "database" folder
sixth:go inside "database" folder and remove everything exept "viber_messeges" and "viber_messeges-journal"
ok now and this is the most important part
seventh: go to www zamzar com convert zip-to-tar.gz and convert your zip file to *.tar.gz file
eighth:copy the converted .tar.gz file to the "go backup" or "titanium backup" folder (be careful the name of your file must match the original name)
ok now your good to go just go inside "go backup" or "titanium backup" on your phone and restore viber
THIS GUIDE WONT DISAPOINT YOU
Click to expand...
Click to collapse
5*. Additionally Posted by @pellajl https://forum.xda-developers.com/showpost.php?p=59361419&postcount=69 :
pellajl said:
I have used this method many times with great success. If both the old and new devices are rooted, all you have do is:
First - Activate Viber in the new device
Second - copy /data/data/com.viber.voip/databases/viber_messages to the same location on the new device.
Third - copy the entire contents of /sdcard/Viber to the same location on the new device.
Fourth - Reboot the phone
Job done......
Click to expand...
Click to collapse
6. Posted by @Sera_6969 https://forum.xda-developers.com/showpost.php?p=55691471&postcount=54 :
Sera_6969 said:
Thanks to everyone posting here. I tried all the suggestions and nothing worked, Viber would boot and ask for authorisation then crash every time after i had copied files into the databases folder.
What eventually worked for me was...
- Back up with Titanium and restore as normal in your new device
- Let Viber go through the activation code procedure
- Unpack the com.viber.voip.xxx-date-xxx.tar.gz in the Titanium Backup folder using ES FIle Explorer
- Unpack the subsequent com.viber.voip.xxx-date-xxx.tar file with ZArchiver
- Use File Explorer to copy the "viber_messages" file from the newly created data/data/com.viber.voip/databases folder into the main /data/data/com.viber.voip/databases folder on the device
- Change "viber_messages" permissions to rw- rw- ---
- Change owner from root to the same as it is for other files in the folder (on my device this was changed to u0_a142)
- Change group from root as well (on my device this was also changed to u0_a142)
- Restart Viber
Click to expand...
Click to collapse
Bonus. short one Posted by @dracula8275 https://forum.xda-developers.com/showpost.php?p=67377118&postcount=91 :
dracula8275 said:
Hi all, problem resolved with the copy of the old files from data. After signing in with the new number must close viber, copy the old message history on viber file and all it's ok
Click to expand...
Click to collapse
PS: some of them might be similar, check whats best for you and share

That's a fine collection. Thanks!
I was hoping to find something that would backup and the messages and convert them to some other format to read them without Viber...

In 2018 we should not have to root our devices and jump through hoops on PCs to have something basic as an automatic backup-restore of app data. Viber is bad, and its developers should feel bad.

ai.unit said:
That's a fine collection. Thanks!
I was hoping to find something that would backup and the messages and convert them to some other format to read them without Viber...
Click to expand...
Click to collapse
That's easy: burger menu -> Settings -> Calls and Messages -> Email message history
But, since Viber now for some time has a backup option (to Google Drive), did anybody succeed in restoring messages and afterwards having images/pictures shown inside the conversations?