[Q]Backup file .LBF corrupt - G2 Q&A, Help & Troubleshooting

Hi!
On LG G2 I created a backup file from setting - backup and restore - create backup. Then I copied a .lbf file to my computer and factory reset my phone.
After reset I copied backup file from computer to phone and run restore. Everything went well, except contacts/sms. error is "FAILED".
Question: How do I get my contacts from .lbf file? If I extract this file with 7zip i get a file contacts2.db but I can't open it. Tried with notepad, MS access.
Any suggestion would be great.

Probably I'm not the only one with this problem, so this is the solution:
Insall DB browser for sqllite, import contacts2.db and execute this command:
select display_name,n.normalized_number from view_contacts as c, view_phone_lookup as n where c.name_raw_contact_id=n.raw_contact_id
This will show you all names with proper phone numbers. Now you can copy-paste to excel/notepad :good:

Related

Backup / Restore Failing

I have created a backup using the ActiveSync backup utility followed by a hard reset. When I try to restore the .stg file i get the following message. 'Restore cannot be completed successfully. The selected backup file was created from a different type of mobile device. Am I missing something when I run either the backup or restore to cause thie error
You need to place the backup.stg file in the pda 's profile folder e.g (Using windows xp)Open explorer and put the file in
C:\Documents and Settings\xxxxxx\Application Data\Microsoft\ActiveSync\Profiles\pocket_pc\
Hope this helps.
Make sure you have the Regional setting the same as what you have backup.
Use Sprite Backup,,, its great :wink:
I have the regional setting the same as the backup and the backup file is in the correct folder
if you changed rom version between the backup and restore it could be that
personaly i had some issues once because i took another timezone well it were still gmt+1 but the city's they listed were different then i changed it to the one i used when i did the backup and all was well

Copy protected files

Hi,
I'm trying to copy a dll in windows\ folder but get access denied. I tried to find a solution by searching the forum and google but had no luck.
Any suggestions?
I doubt it would work, but you could try using sprite backup to copy everything and then find some way to open the resulting sprite backup file ! afaik it is effectively a zip file !

[I] How to restore cemail.vol from Sprite Backup / recover corrupted registry hive

Just recently my device decided to fail and only a hard reset could get it back to life again. No problem I thought - weekly automated backups with Sprite Backup - will be back in a few minutes, just loosing a few days of activity.
Sadly the restore of my most recent backup failed as one of the registry hives seems corrupt and nothing is restored, except the files :-(. So I had to find my latest working backup (which I all keep) which is about 4 months old and restored the device to that state. A start at least...
Now how to get my text messages back from the latest backup? None of the options I found (renaming the original, messing with registry settings of HKCU\Software\Microsoft\Mapi, Mortscript in Startup folder) have worked for me - the original seems to stay no matter what I did.
So I decided to more closely observe how Sprite Backup does the trick and I found a time-window to exploit for my purposes - here is how:
- unpack the latest cemail.vol from the backupfile via Sprite Explorer
- wonder about its size (and cryptic content) -> packed?
- try out usual packers, starting with tar -> rename to cemail.vol.tar -> success (!)
- get cemail.vol in original form
- copy to root folder of device with name cemail.volx
- restore device with a failing backup file (select to restore only cemail.vol) and leave it connected to PC
- observe (via remote connected PC) that reboot after initial settings (so in the actual restore phase) has no cemail.vol in the root folder
- rename the previously copied cemail.volx to cemail.vol
- restore fails (leaving the cemail.volc - tar compressed cemail.vol behind) but cemail.vol is now the one I want
- reboot
- report that Restore failed
- but have cemail.vol that I wanted
- external Backup of SMS
- restore external backup to original folder
- done
To continue where I left off - so what if you need some settings that are inside the corrupted registry hive? I spent hours of searching and trying to dump the corrupt hive to something readable and finally found one tool that works reasonably well. You find it at MSDN here: http://blogs.msdn.com/b/ce_base/arc...registry-hives-and-cedb-database-volumes.aspx
While rgucomp.exe simply hogs the CPU forever and produces no output, above tool at least delivers some output you can re-use. For my hive it seems to come to a loop-like situation as well (you need to Ctrl-C to end it) but the output until ending with "Finished registry walk" is delivering all you may need. It looks like:
Code:
hKey=0x00000EA9 hNext=0x00000E5F [HKEY_CURRENT_USER\Software\Microsoft\QuickApp] hSubKey=0x00000000 hVal=0x00000EC3
hVal=0x00000EC3 hNext=0x00000EC2 "1"="{6D48AB52-635C-4c6a-8508-9D32A0F07863}"
hVal=0x00000EC2 hNext=0x00000EC1 "2"="{2ABD8635-9808-4c4c-943B-8173B805FD40}"
hVal=0x00000EC1 hNext=0x00000EC0 "3"="{0D519EC6-315A-4693-AF1B-B2DA865AC1C7}"
hVal=0x00000EC0 hNext=0x00000EBF "4"="{69E9215B-91B0-461b-A3B6-165EBA32DAE1}"
hVal=0x00000EBF hNext=0x00000000 "5"="{B7A5E609-3E46-442d-8D32-65926EDA6795}"
So you can copy / paste to another file for later use. Datatypes are correctly identified in usual rgu syntax.

[GUIDE] Extract and Restore Contacts, SMS, Call logs from nandroid backups(TWRP)

So yesterday My phone, Sony Xperia S, decided to go into bootloop and not boot at all, no matter what I did. Tried flashing stock PRF, stock firmware, some stock based firmware, but it would get stuck in bootloop. The reason for this being I was not formatting the data partition, which I needed to preserve since it had all My sms, contacts, call logs and other app data. Luckily, I had a working recovery(TWRP) and was able to take a backup. Then using that I was able to recover My contacts, sms, call logs and app data. After a lot of Google searches, I was finally able to work it out. The process is as follows:
Needed software:
Code:
yaffs-mmssmsdb-calls-extractor.zip from [URL="http://forum.xda-developers.com/showthread.php?t=1585957"]here[/URL].
Firefox Browser
Firefox addon of SQLite manager : [URL="https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager"]link[/URL].
Excel macro to convert .db contacts to .csv : [URL="http://thydzik.com/downloads/convert-contacts2.db-data-to-vcard-vcf.xlsm"]link[/URL].
Software for csv to vcard conversion (Windows) : [URL="http://www.csvtovcard.com/"]link[/URL].
CSV to vcard conversion (online) : [URL="http://labs.brotherli.ch/vcfconvert/"]link[/URL].
SMS Backup & Restore android app : [URL="https://play.google.com/store/apps/details?id=com.riteshsahu.SMSBackupRestore"]link[/URL].
Call Log Backup and Restore app : [URL="https://play.google.com/store/apps/details?id=com.riteshsahu.CallLogBackupRestore"]link[/URL].
The procedure is a lot crude as of yet, I would update as more universal and convenient options are found.
I know there is Titanium backup app which can restore contact, sms etc from nandroid backups, but You need a paid version of the app.
First we need to extract the data partition of nandroid
Rename the data.ext4.win to data.ext4.tar.gz . If Your files are like data.ext4.win000, data.ext4.win001, then rename each of them to data.ext4.tar.gz in separate folders.
On windows, now You can directly extract them using WinRaR or 7zip application, although You don’t need to extract it entirely.
On linux, You can do so using the following command. It is recommended to store the file in a separate folder as the file gets extracted directly.
Code:
tar –xf data.ext4.tar.gz
Now we need to find two files contacts2.db and mmssms.db . The contacts2.db files is for contacts as well as the call logs and the mmssms.db is for messages. The contacts2.db is constant across most ROM’s and OEM firmware apps. The mmssms.db file may vary as per app and ROM’s. So what You need to do is look for a .db file inside the SMS app You have been using with the firmware/ROM.
We will restore the SMS and Call logs first.
Currently it is limited to Windows OS only.
Extract the contents of yaffs-mmssmsdb-calls-extractor.zip to a folder.
Copy the mmssms.db file and contacts2.db file to the above folder.
Now open a command prompt at location of the above folder. This can be done by opening the folder, right clicking using shift key pressed in blank space. You get the “Open command window here” option.
In it type:
Code:
extract -s mmssms.db
It will ask You to enter a name for the output .xml file, You can press enter to let it give a default name. This will convert Your sms to a .xml file .
Then type:
Code:
extract –c contacts2.db
It will also ask You to enter a name for the output .xml file, You can press enter to let it give a default name. This will convert Your call logs to a .xml file .
Copy both of these files to Your newly formatted phone and then use the two before mentioned apps (Call Log backup& Restore and SMS Backup & Restore) to restore Your SMS and call logs.
Now retrieving contacts. It is a bit lengthy, but simple process.
Start firefox browser. In it, after You have installed the addon do following to enable the addon
Go to options (3 horizontal lines).
Select “Customize” and drag the “SQLite Manager” to the blue bordered box.
Now open options and select SQLite Manager. In it select Database>Connect Database. In the opened dialog box, select All Files(*.*). Then select Your contacts2.db .
From the left side tree structure in the SQLite Manager window, right click on “data” and select “Export Table”.
Now in right side part of the window, You will get CSV tab and SQL tab. Under CSV tab, simply press OK button without changing any other options.
It will ask You to save Your .csv file. Save it.
Now if You try to open this file directly, You will notice that file is not properly arranged.
To arrange it properly, open the convert-contacts2.db-data-to-vcard-vcf.xlsm file. If You don’t know how to enable Macros, then do the following:
It will show You a warning “Security Warning Macros have been disabled. Options..”
Press the Options button. Select “Enable this content” and press ok.
Now Press the office button present at left top corner. In it select “Excel Options”.
Select Customize tab from left side. Then from “Choose commands from:” drop down menu, select Macros.
Now add convertDatatoContacts and writeContactstovCard to right pane from left pane by selecting them and pressing add. Press OK button.
Now as You can see two white square icons have been added at top right corner next to save undo redo options.
Select the first white square icon. Select “Enable Macros” button. Now select Your .csv file in the opened dialog box.
Now the file must have opened in a separate excel. The format should be 4 rows with they being First Name, Last Name, Phone 1 and Phone 2.
Then select Save As>Excel Workbook>Save Type as CSV(Comma delimited).csv . Press ok and yes on the two warnings generated.
At the left bottom, right click on “contacts” sheet and press delete. Save and close the file.
Run CSV to vCard software and open the above saved .csv file. Here You can save all contacts as single vCard file or separate files.
In the “Properties” section on the window, in front of “Phone 1” and “Phone 2” select “Mobile Phone” from options. Press “Convert” button.
Alternative to above two steps, You can also convert .csv to vcard using the website.
Now a .vcf file will be created where the .csv file was stored.
Now simply copy the .vcf file to phone and import using the phone contacts app!
Done!
Credits and sources:
@abbot2
[TOOL] yaffs extractor, mmssms.db & contacts2.db converter
http://thydzik.com/export-android-contacts-contacts2-db-to-vcard-vcf-on-windows/
Reserved.
This is complicated, but youre great mate...
Sent from my C6903 using Tapatalk
odie70 said:
This is complicated, but youre great mate...
Sent from my C6903 using Tapatalk
Click to expand...
Click to collapse
Ah yes, it's a lot complicated, but the need of recovering data was a lot important too!
Praise to you for saving me !
And if I may, I'd like to state my experience, which brings a few interesting facts into light:
1/ I was unable to open my tar.gz archives with 7-zip v9.20. It kept displaying an error message. Only the v15.14 version could handle them flawlessly.
2/ as a textra user, I discovered that it stores a duplicate sms database, which IS NOT compatible with yaffs-mmssmsdb-calls-extractor (which screams a message about a "missing sms table" or something) (praise to the author as well)
BUT, the system sms database can be found here, and is fully handled by the extractor tool:
data\data\com.android.providers.telephony\databases\mmssms.db
Now my sms are back and I can resume my thread about the best knitting techniques.
Thanks again
Add this cool service Online converter contacts2.db to vCard
OP - you're a deadset legend.
This is damn useful! :good:
Even if I do not need it right now but it is very good to know that there is a way.
Hello @Mirhawk, I am having this error when running the macro. What could be the issue?
http://i.imgur.com/baUmFci.png
Thanks for this. I wanted to comment to help others using Microsoft Office 2016 & now that Firefox Quantum has made old extensions incompatible. Call logs & SMS are easily imported by Nandroid Manager app (god bless the dev). This a short summary of steps to restore contacts, presuming you have the contacts2.db file extracted:
- Install Firefox 39 from here. Might work with FF 57, but did not want to take chances.
- Download the Excel Macro [which will help us later correctly arrange our data via pre-set changes, aka macros, on the Excel spreadsheet][see link above]
- Install & enable the SQLite extension in Firefox (already linked above by OP)
- Follow OP's steps until you obtain the .csv file
- Open the macro file you had downloaded earlier & click enable the content
- In Excel 2016, you need to add Developer Tab to your top menu: Go to File -> Options -> Customize Ribbon -> Check mark Developer option on the right side column. Click OK.
- Now we need to run the macros: Click on Developer Tab at the top -> Macros -> Run the first macro: convertDatatoContacts
- Select the .csv file & proceed
- Now run the second macro: writeContactstovCard
- Vcard (.vcf) is saved to same folder as your original macro file.
In Nougat, Contacts app can open and import .vcf file or you can use third-party app.
Great tutorial, thank you very much! This saved 6000 SMS when Titanium Backup had messed up. ??
Thank you very much! With your guide I could recover my SMS from a phone with a bootloop (TWRP bootable) but I did a different process:
1. TWRP Backup
2. Transfer it to PC
3. Rename the data.ext4.win to data.ext4.tar.gz . If Your files are like data.ext4.win000, data.ext4.win001, then rename each of them to data.ext4.tar.gz in separate folders.
4. Open each file in BandiZip program and search for mmssms.db
In my case it was in: data/user_de/0/com.android.providers.telephony/databases/
5. Copy this file to the same folder in spare phone / same phone after factory reset.
6. SMS appear now!
mmssms.db not found
I guess since Android 5+ mmssms.db is deprecated, refer https://forum.xda-developers.com/showpost.php?p=74784136&postcount=3 to extract sms to xml file
owzm tutorial
tks for A DETIALED TUTORIAL
try this forum for retrive contacts ,given a easy method by "StefanPutureanu"
https://forums.androidcentral.com/ask-question/459773-how-do-i-retrieve-my-contacts-twrp-backup.html
Thanks for valuable infomation.I'd like to share my experience that I have use Android recovery program to extract and recover sms,contacts,call logs from backup files.It has powerful method and the operation is easy.
my samsung s9+ deleted all my contacts, slowly like 20 a month lol, no idea why, ****ty sammy soft and auto sync deleted em from sammy cloud too...
i had problems even extracting contacts2.db /Failed to extract calls: no such table: calls/
so i found a better way: just convert your contacts2.db right into vcf here: http://gsmrecovery.ru/db2vc/index.php?lang=en
all my contacts are back
Mirhawk said:
Reserved.
Click to expand...
Click to collapse
Any way to get attachments on SMS back ?
Cause i get all my sms back, but no more pics

Restore from backup (.lbf) on Lineage 17?

I needed to update my LG G3-D855 to a the version Lineage 17 since some apps stopped working on the old version.
However, in ignorance the LG backup/restore feature was used to backup the phone, creating a .lbf file on PC. Now it appears there is no way to restore from the file on Lineage. I have enabled the developer options and USB debugging, but the LG bridge tool does not even recognize the phone (no device detected). Is there any way to extract information from the backup?
Thank you for thy great help.
I was able to extract all the files from the backup .lbf using https://forum.xda-developers.com/android/general/tool-lg-restore-com-lge-bnr-lbf-file-t4053579/ as guide.
However, this presents a new problem. The contacts, messages and call logs are _DB files (not .db files, the file type is "file"). How to convert these to something that can be imported by Lineage 17?
Ok, so the _DB files are actually .tar files containing the .db files. But now there is again a new issue, how to import the .db files to Lineage?
I tried to directly copy and paste the contacts2.db to the contact database directory, but this breaks the contacts entirely on the phone. I also installed SQLite Expert, checked the user and scheme version on the new and old .db file and edited the old .db to match. No difference...
Apparently the .db can be converted to .vcf which can be directly imported by the phone. However, I did not find any way to convert the .db to .vcf on windows...

Categories

Resources