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] 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

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

[Q] SMS\MMS Export file format CM 12.1

I used the Export utility in the CM 12.1 messaging app to save my SMS/MMS messages before a wipe and fresh install of Slim 4.4.4 build 9.0.
Now trying to restore these files and need to know what format they are in. Apps like SMS Backup & Restore do not recognize the files. There is no file extension...
Looking at the header of the file in a text editor I see this;
@sr com.android.mms.QMMSBackupà÷ýÖa 
L MMSListt Ljava/util/ArrayList;xpsr java.util.ArrayList
What do I need to do to restore these? Or at least be able to read them....