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] Go backup restored problem

I hope it is the right forum to ask.
I've just flashed my GS2 to JB 4.1.2 and Rooted.
Before that I made a mistake and backup my files with Go backup pro.
Now I can't restored because it is not find my backup files on the path..
I have searched in your forum vertically and horizontally and I found some thread about this problem but without a solution.
Could someone please advice me how to restore my files back?
Thank you very much.
Tomer.

tomer_inbar said:
I hope it is the right forum to ask.
I've just flashed my GS2 to JB 4.1.2 and Rooted.
Before that I made a mistake and backup my files with Go backup pro.
Now I can't restored because it is not find my backup files on the path..
I have searched in your forum vertically and horizontally and I found some thread about this problem but without a solution.
Could someone please advice me how to restore my files back?
Thank you very much.
Tomer.
Click to expand...
Click to collapse
I also backup my files using Go Backup pro. The backups by default are in external sdcard ( sdcard1). After flashing a rom you reinstall Gobackup Pro from Play Store. Launch the app and you will see the two tabs onscreen : backup tab and restore tab. Just click the restore tab and you see a prompt showing all backup files. Choose the latest files and click restore.

terrynguyen said:
I also backup my files using Go Backup pro. The backups by default are in external sdcard ( sdcard1). After flashing a rom you reinstall Gobackup Pro from Play Store. Launch the app and you will see the two tabs onscreen : backup tab and restore tab. Just click the restore tab and you see a prompt showing all backup files. Choose the latest files and click restore.
Click to expand...
Click to collapse
I tried it and still I don't have any backups on screen.. :crying:

See which storage has been set as default. ( under settings - storage)
If you backed up to SD and now internal memory is made as default, it won't show the files. (as it searches only internal memory)
- - - - - - - - - - - - - - - - - - - - - - - - - -
LIFE!
IT'S WHAT YOU MAKE OUT OF IT!

Thank you for your answer.
I did backup on the SD card.
I did check and both shows no backup..

GoBackup doesnt recognize old backup files problem solved!
OK...got something for all of u punks like me out there. After installing new ROM i couldn't restore my backuped upfiles with GoBackup coz app couldn't recognize or find old backup files. I really had some important stuff there and wasn't intending to just give up. I have read many forums but everyone said to just give it up and forget it. Said hell no! So after few days of trying (reinstalling rom,gobackup,deleting caches and god knows what else i have tried) i came a cross of this lame idea . I actually opened GoBackup files on my GoogleDrive(so.... i had backup but app couldn't find it or recognize it to be able to restore it) and checked what i had installed. Made a list and installed all apps i had when i was making backup. Then i installed apps and made backup via gobackup. And here it goes... i copyed old backup files in latest backup directory , renamed old backup files using names from new files. So u get your old backup using file names of latest backup. Now app will recognize your old backup coz u renamed them. App thinks your old backup is actually latest backup. U just go into app and restore your things.
So:
1.Check out your GoBackup directory where u have your backup files (which after rooting app doesn't find or recognize) and make a list of apps u wanna restore
2.Install apps from your list
3.Make new backup of all apps u wanna restore later(old ones u had installed)
4.Now open backed up files that u wanna restore and open latest backup directory and rename old files using names from new backup files.
5.After renaming old backup files, move them into latest backup directory replacing latest backup files with renamed ones.
6.Go to GoBackup app and make restore of latest backup which is actually old one .

Found an easy solution
1. Connect your phone via cable.
2. Open SD card, locate GOBackup folder and press copy.
3. Go to local memory and press paste.
Now open GOBackup on your device, and its a miracle, all your backup there

[BACKUP][PC][ADB][BATCH-INSTALL-APK][NO-ROOT]ADB Toolbox

This project was made by me while playing around with the basics of Batch and ADB
It uses the native Android backup framework
Tested until the latest 4.2.2 firmware in Xperia L
Check Attachments for download
Features:
1.Backup App data along with apks
2.Backup system apps data
3.Backup SD app data
4.Restore *.ab ADB backups
5.Batch install any number of apks by placing in the folder provided
note:
>Does not backup user accounts or synced contacts and other sensitive data though messages etc will be backed up
>Enabling apk backup in first option will backup system apks also in the case that system backup is enabled
>Run the batch file at least once so as to create folders
>ADB Debugging must be enabled
>All backups must be in the required folder so as to restore
>You will need to activate the process in the phone so please keep your screen unlocked
>While installing apks the name must not contain multiple '.com' or unwanted symbols(such files will be omitted)
>Existing apps will be reinstalled with your apk without loss in data

Can we do selective backup ? Or we can only backup as a whole nice tool
Sent from Sony Xperia L

Navneet Suresh said:
Can we do selective backup ? Or we can only backup as a whole nice tool
Sent from Sony Xperia L
Click to expand...
Click to collapse
thanx
Backup of user data is done by default
-but u can choose to do it along with apk and sd data
-u can also backup system data
-also remember if 1st option is chosen ie..with apk..system backup if chosen will also be done with apk
this is bacause of how adb backup command works.

Thanks man! Very useful tool this is!

RESTORE .APKs FROM CWM

Hello Friends This is my first TUTORIAL.
DO, ANYONE RATHER THAN ME (AS A NOOB) NEEDS SOME SYSTEM OR USER INSTALLED .APKS from CWM (clockwork mod) Backups? It would be easy to get them just by Re-installing the Backups. But in some Cases we don’t want to restore the whole system backup instead of SOME APPS or DATA Only.
So Here’s the Tutorial to Extract the .APKs or DATAs From the Backups which is in the .tar format. (CWM RECOVERY only.) found By ME. (I don’t know if anyone Other than me have already found this Method. Coz I Didn’t find any.)
Steps:-
1. The BACKUP of your ROM (from which you want to Restore .APKs / DATA)
2. A Computer / Android Device.
3. 7 – Zip installed (for a Computer PC) / 7 zipper (free in the Play Store) Installed (for a Android Device)
4. Now go the Backup folder and Open It.
5. If you want to restore System (Pre-installed) .APKs of CWM RECOVERY find the File Named “system.ext4.tar.a”
6. If you want to restore your USER INSTALLED .APKs of CWM RECOVERY find the File Named “data.ext4.tar.a”
7. Open it with the Respective Installed “7-Zip | 7 Zipper” via the Device you have.
8. And Navigate to the Folder “system --> app” for Pre-Installed | and for USER installed APK.s “data --> app”
9. Now you’ve got to the Respective Place and you have the Whole .APKs of your Android. Restore / Copy them Which ever you want.
10. By this Method you can obtain much more than just APKs. Coz it has simply all the Vital Data or Information of your ROM.
Note: For Installing SYSTEM APPS you have to put it to your Root/System/App folder. And give it the Appropriate PREMISSIONs.
I hope You find it Helpful Noobs. just like me.
Thanks. & Regards,
v_singh (VIPIN SINGH)

v_singh said:
Hello Friends This is my first TUTORIAL.
DO, ANYONE RATHER THAN ME (AS A NOOB) NEEDS SOME SYSTEM OR USER INSTALLED .APKS from CWM (clockwork mod) Backups? It would be easy to get them just by Re-installing the Backups. But in some Cases we don’t want to restore the whole system backup instead of SOME APPS or DATA Only.
So Here’s the Tutorial to Extract the .APKs or DATAs From the Backups which is in the .tar format. (CWM RECOVERY only.) found By ME. (I don’t know if anyone Other than me have already found this Method. Coz I Didn’t find any.)
Steps:-
1. The BACKUP of your ROM (from which you want to Restore .APKs / DATA)
2. A Computer / Android Device.
3. 7 – Zip installed (for a Computer PC) / 7 zipper (free in the Play Store) Installed (for a Android Device)
4. Now go the Backup folder and Open It.
5. If you want to restore System (Pre-installed) .APKs of CWM RECOVERY find the File Named “system.ext4.tar.a”
6. If you want to restore your USER INSTALLED .APKs of CWM RECOVERY find the File Named “data.ext4.tar.a”
7. Open it with the Respective Installed “7-Zip | 7 Zipper” via the Device you have.
8. And Navigate to the Folder “system --> app” for Pre-Installed | and for USER installed APK.s “data --> app”
9. Now you’ve got to the Respective Place and you have the Whole .APKs of your Android. Restore / Copy them Which ever you want.
10. By this Method you can obtain much more than just APKs. Coz it has simply all the Vital Data or Information of your ROM.
Note: For Installing SYSTEM APPS you have to put it to your Root/System/App folder. And give it the Appropriate PREMISSIONs.
I hope You find it Helpful Noobs. just like me.
Thanks. & Regards,
v_singh (VIPIN SINGH)
Click to expand...
Click to collapse
or easier just restore from nandroid manager

ngoralph said:
or easier just restore from nandroid manager
Click to expand...
Click to collapse
hmm... thanks for your advice sir.
but does it offers to restore odex files.?
and other kind of files like built.prop etc.?

[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?