Restoring db files back to Android phone - General Questions and Answers

Hello gang,
Its been a while since I got on this site. Here's my situation; I was able to back up my sms and it was saved as a db file. I had lots of important messages and pics that were sent to me and I would like to retrieve it. I have an Android phone at the moment and installed Airdroid and sms backup & restore app, but I just can't seem to get this to work. How do I get my db files back on the Android phone and be able to see my messages?

Hmmm ...
How did you backup the messages in DB ?

karandpr said:
Hmmm ...
How did you backup the messages in DB ?
Click to expand...
Click to collapse
Its been a while since I did this so I forgot how. I thought I backed everything up on a SD card.

johnny quest said:
Its been a while since I did this so I forgot how. I thought I backed everything up on a SD card.
Click to expand...
Click to collapse
Hmmm..... What kind of database is it ?
Sqlite or something else ?
Encrypted or open?
Can you upload the db here ? (or atleast the db with one record.)

karandpr said:
Hmmm..... What kind of database is it ?
Sqlite or something else ?
Encrypted or open?
Can you upload the db here ? (or atleast the db with one record.)
Click to expand...
Click to collapse
I've downloaded apps to open db files and I can see some of the text but there were pictures which I can't see. All I know its all db files, has either a "exec" icon or a "document" icon.

Related

SMS database file

Hi all,
Wondering where the SMS DB file is stored and how to access it.
Rooted phone.
Thanks
nnila said:
Hi all,
Wondering where the SMS DB file is stored and how to access it.
Rooted phone.
Thanks
Click to expand...
Click to collapse
Try Backing up all SMS with any sms backup software, and then check its backup..
Not sure about where it is stored in ROM
/data/data/com.android.providers.telephony/databases/mmssms.db
Any particular way to access it?
Most my tools are showing the data folder as empty?
nnila said:
Any particular way to access it?
Most my tools are showing the data folder as empty?
Click to expand...
Click to collapse
You need to use a root file manager such as Root Explorer or Super Manager. I've never tried looking inside the SMS file but presume the database is stored in SQLite3 format.
When you got the file you can read it with this program:
http://sourceforge.net/projects/sqlitebrowser/

Recover deleted texts?

Is there any way to recover deleted texts? I accidentally deleted the wrong thread of messages.
Not unless you already had a backup of them...
A backup with an app, no. A copy of the database file right after I deleted them, yes. I see they're still there, just wanna know if there's a way to get them to be viewable again.
I really miss having a deleted items for texts like back in WM6
what format is the database file?
sqlite i think.
located here on all android phones:
/data/data/com.android.providers.telephony/databases/mmssms.db
When you delete the thread, it still remains in this db?

Blackberry problem

Hello xda,
I have a problem with my Blackberry Backup File. I currently don't have my Blackberry and I want to transfer my contacts from Backup File (One without .IPD just .BBB) to my new Android phone. I have tried many software but only one that can open the new Backup File must be registered to export the contacts. I also tried with IPDextractor and I get blank fields. Any one here can help?
Thanks alot!
P.S. I had Blackberry Bold 9900 with Desktop Software 7.1
bump
brigate011 said:
bump
Click to expand...
Click to collapse
bump please its urgent
In which formate is ur backup..
Just open it via any apps likw winzip,7zip,notepad++ etc..etc..
Try all these if u can see some names and number,just take down.......
sanjaykumar.sanjay69 said:
In which formate is ur backup..
Just open it via any apps likw winzip,7zip,notepad++ etc..etc..
Try all these if u can see some names and number,just take down.......
Click to expand...
Click to collapse
The backup is the newest version on .bbb , I can't get IPD out of it. I tried with 7Zip but nothing extracted.

[Q] HTC Sensation problems after some random reboot

Hello to all,
I need some help.
After some random reboots I don't have any of my contacts, all the widgets and icons from the panels are disappeared. :crying:
I attached a screenshot from my home panel.
It is any possibility to fix this problem ???
Phone: HTC Sensation
Kernel: Faux 123 010b7
Rom: Android Revolution 7.2 XE
Thanks.
try to flash the rom without wipe
rzr86 said:
try to flash the rom without wipe
Click to expand...
Click to collapse
Hi there,
I try it like you suggested me, to reflash without wipe, but no changes
All my panels are clear like in the picture from the first post and no contacts.
I would like to save only the contacts .. and after to make a clean install.
Thanks for your help
DBDexter said:
Hi there,
I try it like you suggested me, to reflash without wipe, but no changes
All my panels are clear like in the picture from the first post and no contacts.
I would like to save only the contacts .. and after to make a clean install.
Thanks for your help
Click to expand...
Click to collapse
try to download an app from play store(such as mobile backup II) and see if it will backup any contacts
also if you have stored your contacts in your gmail account don't worry you won't lose them
rzr86 said:
try to download an app from play store(such as mobile backup II) and see if it will backup any contacts
also if you have stored your contacts in your gmail account don't worry you won't lose them
Click to expand...
Click to collapse
I used Mobile Backup II to backup my contacts but is only seeing what I have on my SIM and nothing more.
Are the contacts in a database ??? Where can I find this database and how can I recover it ???
I don't have any backup on google
Thank you again for your time and help.
DBDexter said:
I used Mobile Backup II to backup my contacts but is only seeing what I have on my SIM and nothing more.
Are the contacts in a database ??? Where can I find this database and how can I recover it ???
I don't have any backup on google
Thank you again for your time and help.
Click to expand...
Click to collapse
when you were storing a contact where you were choosing to store it?
google account,sim or phone?
go to dialer if you can in contacts tab and in the top you will see options for showing contacts
there you will see where they are stored
rzr86 said:
when you were storing a contact where you were choosing to store it?
google account,sim or phone?
go to dialer if you can in contacts tab and in the top you will see options for showing contacts
there you will see where they are stored
Click to expand...
Click to collapse
I always saved my contacts on the phone, not SIM or Google.
On the contacts tab I have selected SIM ( 9 numbers from my Carrier ) and Phone ( 0 )
Can you tell me please if the contacts are saved in a file and if so, what is the name of the file and what is the path to the file.
Thanks.
DBDexter said:
I always saved my contacts on the phone, not SIM or Google.
On the contacts tab I have selected SIM ( 9 numbers from my Carrier ) and Phone ( 0 )
Can you tell me please if the contacts are saved in a file and if so, what is the name of the file and what is the path to the file.
Thanks.
Click to expand...
Click to collapse
select also your google account and see if the conatacts are stored there too
unfortunately i don't know where the file could be or what is the path
rzr86 said:
select also your google account and see if the conatacts are stored there too
unfortunately i don't know where the file could be or what is the path
Click to expand...
Click to collapse
I found it one of itsme_4ucz's posts:
The contacts are stored in a SQLite3 database file so the file format is ".db"
The development tool Android Debug Bridge (ADB) can be used to extract the file from an EMULATOR
ADB can also extract the file from a phone but it must be rooted first AND the ADB drivers must be installed on your machibe as well
(Rooting is NOT for beginners though)
The contacts.db file is stored in the protected system memory, the file path is:
data/data/com.android.providers.contacts/databases/contacts.db
Click to expand...
Click to collapse
In << /data/data/com.android.providers.contacts/databases/ >> I have no contacts.db file
This is the list of the files from my databeses folder:
Code:
contacts2.db
contacts2.db-journal
contacts2.db-mj073D7E1F
profile.db
profile.db-journal
Can I recover my contacts from this files ???
DBDexter said:
I found it one of itsme_4ucz's posts:
In << /data/data/com.android.providers.contacts/databases/ >> I have no contacts.db file
This is the list of the files from my databeses folder:
Code:
contacts2.db
contacts2.db-journal
contacts2.db-mj073D7E1F
profile.db
profile.db-journal
Can I recover my contacts from this files ???
Click to expand...
Click to collapse
probably with an adb command but i don't remember that command
rzr86 said:
probably with an adb command but i don't remember that command
Click to expand...
Click to collapse
I used Sqliteman-1.2.2 to open contacts2.db and after a basic query to contacts table I can only see the contacts from SIM
DBDexter said:
I used Sqliteman-1.2.2 to open contacts2.db and after a basic query to contacts table I can only see the contacts from SIM
Click to expand...
Click to collapse
see here
http://forum.xda-developers.com/showthread.php?t=726051
second post it has an adb command
best wishes
rzr86 said:
see here
http://forum.xda-developers.com/showthread.php?t=726051
second post it has an adb command
best wishes
Click to expand...
Click to collapse
I don't know why I have contacts2.db instead of contacts.db.
Is correct what I have?
Thank you for your help.
DBDexter said:
I don't know why I have contacts2.db instead of contacts.db.
Is correct what I have?
Thank you for your help.
Click to expand...
Click to collapse
i don't know mate
maybe a second back up or something like that?

How to open backed up Whatsapp chat DB.crypt8

I accidentally deleted some important conversations from my Whatsapp on my Galaxy note 4 and iam trying to find out if its possible to restore them. I went to my root folder to whatsapp/databases and inside there are encrypted files, each one of several kb,of my conversations for example: msgstore.db.crypt8. I even sent these files to my email to have them available in the future. So my question is if its possible to open there files somehow? Thanks.
bobesko said:
I accidentally deleted some important conversations from my Whatsapp on my Galaxy note 4 and iam trying to find out if its possible to restore them. I went to my root folder to whatsapp/databases and inside there are encrypted files, each one of several kb,of my conversations for example: msgstore.db.crypt8. I even sent these files to my email to have them available in the future. So my question is if its possible to open there files somehow? Thanks.
Click to expand...
Click to collapse
Yes, but you first need to extract the key. See: WhatsApp Key/DB Extractor
Hi, can we decrypt a db.crypt8 file without a key?

Categories

Resources