Database Info

expand a nandroid img file

for those who do not know how to do this yet, follow directions given here.
Just took this info from the web. None of this except for the guide is written by me.
I am not responsible for anything please do not contact me if a green sludge starts attacking your neighborhood eating one person at a time.
************************************************************
************************************************************
************************************************************
http://code.google.com/p/unyaffs/downloads/list
made for linux, but if you know a bit of c, you can probably change it to work with windows, maybe I will do that if I have some time this week.
********OR********
http://jiggawatt.org/badc0de/android/unyaffs-x86-win.zip
or http://www.4shared.com/get/fgryPnPx/unyaffs-windows.html
for windows..... instructions below apply for both
if not included in the zips above, cygwin1.dll and unyaffs.exe are included as an attachment of this reply.
open up a command line, in windows vista/7 just press start and then type cmd press enter and change the directory to the folder with the unyaffs and the img in it. in xp press start>run>cmd... then the same
the usage is: unyaffs /path/to/img
example:
(if unyaffs.exe and system.img are both in c:\temp)
"c:\temp> unyaffs /temp/system.img"
note: the '/' is the way linux determines the pathname of a file and since it is built using cygwin(a file allowing for windows) it is preferrable that the path to the actual file is in unix POSIX format ie: / instead of \ between folders and files.
*********WARNING************
this will extract to directory that unyaffs binary is in.

That's so weird -- I was gonna post the same thing tonight. Thx for writing this up. It's odd that more people don't talk or ask about this tool!

I remember reading this stuff back when I got my G1, and tonight I was trolling the themes and apps section cause I couldnt sleep. (which I rarely look at)
I was baffled that this wasnt common knowledge. I figured if there was no threads about it that people just knew how and didnt have any problems with it. My mistake lol...
enjoy.

can you please explain what is it? what it does? thanks

ericizzy1 said:
can you please explain what is it? what it does? thanks
Click to expand...
Click to collapse
Umm, it expands nandroid img files not sure how else to explain it. Clockworkmod backups are in the img file format. This process allows you to extract those files to get stuff out of them
Sent from my SPH-D700 using XDA App

When you create a backup in Clockwork recovery, it leaves you with a folder like this:
2010-11-18.08.52.49
As you can prob figure out, I made that backup on 11/18 at 8:52am
Inside that folder are .img files, such as: data.img and system.img
Those files basically contain your data (like apps you've installed from market) and system (..system apps that might've come with the phone).
In the orig post, he's explaining how to extract the files from these large .img files.
To give an example, I had a couple of corrupted clockwork backups, and wanted to ONLY pull out some database files (like text messages and call logs) which were not corrupted. Even tho the backup was messed up, I could still extract the files I needed by using the method above, then copied them manually to my phone.

decalex said:
When you create a backup in Clockwork recovery, it leaves you with a folder like this:
2010-11-18.08.52.49
As you can prob figure out, I made that backup on 11/18 at 8:52am
Inside that folder are .img files, such as: data.img and system.img
Those files basically contain your data (like apps you've installed from market) and system (..system apps that might've come with the phone).
In the orig post, he's explaining how to extract the files from these large .img files.
To give an example, I had a couple of corrupted clockwork backups, and wanted to ONLY pull out some database files (like text messages and call logs) which were not corrupted. Even tho the backup was messed up, I could still extract the files I needed by using the method above, then copied them manually to my phone.
Click to expand...
Click to collapse
thx
Sent from my SPH-D700 using XDA App

smeyerhuky said:
Umm, it expands nandroid img files not sure how else to explain it. Clockworkmod backups are in the img file format. This process allows you to extract those files to get stuff out of them
Sent from my SPH-D700 using XDA App
Click to expand...
Click to collapse
Right, like if you wanted a file or a few files from clockworkmod img backup, then this process would give you an extended file system, other than what you would normally use to extract the img files. Just trying to understand this so, please correct me if im wrong.... I've been trying to get more knowledge of this, so im still learning.
I prolly sound like a complete idiot, lol...

Sweet! Thanks for this man. I'd been looking for how to do this for some time and kept ending up learning about emulation or some other tangential topic. This is the basic functionality I was looking for. Thanks for posting!

Np. I'm working on writing some stuff on top of the source code that should allow you to browse and pull just one our more file
Its been a but since I looked theory source code so it might take a while... Maybe in between semesters?
Sent from my SPH-D700 using XDA App

Dode you saved my as** thx big thx

Great, now how can I re-compress back to .img after I've made the changes that I want?
EDIT: Nevermind. I just made a zip of the new system folder and flashed it in CWM.

This worked great for me.
Thanks,
Bud

Man, I do not know how to thank you. I was able to recover some important stuff off of my cwm recovery backup. THANKS!!

[Q] How to extract SMS from ROM backups?

Hi all,
well, the heading says it all - I need to extract the text messages stored in my several ROM backups and maybe integrate them with my current ROM if possible. The backups were done with 4EXTrecovery
So far I found the info that these text messages are stored in /data/data/com.android.providers.telephony/databases/mmssms.db - but how do I get to those inside the backups? Anyone here know a way to combine several of these files into one?
Any help greatly appreciated

i'm interresting too wait for any anwsers !

This question has been asked and answered many times, you can do a search to find many possible solutions.
If you have root and are comfortable playing around with the files, the file you listed is a simple sqlite database. You can extract it and merge it on a PC using an sqlite manager application. (Be sure not to duplicate any repeated messages!) Copy the merged file back to /data/data/com.android.providers.telephony/databases/ and you're done!

superatrain said:
This question has been asked and answered many times, you can do a search to find many possible solutions.
If you have root and are comfortable playing around with the files, the file you listed is a simple sqlite database. You can extract it and merge it on a PC using an sqlite manager application. (Be sure not to duplicate any repeated messages!) Copy the merged file back to /data/data/com.android.providers.telephony/databases/ and you're done!
Click to expand...
Click to collapse
I'm glad I found this reply, but I got stuck at the stage where sqlitemanager asks me for a password as the data.yaffs2.img file is encrypted. My backup was performed using CWM backup and I figured that I'll find the "com.android.providers.telephony/databases/" under there but as I already said, I can't open the data.yaffs2.img to access "com.android.providers.telephony/databases/".
Please help

I too was wondering the same thing, that's awesome! I will give it a try...
Sent from my Galaxy Nexus using xda premium

Opening fastboot files

Hi everyone,
I know Motorola changed the file format recently to some type of ext4, in the fastboot images. Do we know how to open them yet? I want to grab a couple of files, thanks!
Sent from my XT894 running ICS

I used 7zip to extract. I used safestrap to make a backup which created a system.ext4.win file. I then used 7zip to extract which then gave me the files in the traditional format.

007shark said:
I used 7zip to extract. I used safestrap to make a backup which created a system.ext4.win file. I then used 7zip to extract which then gave me the files in the traditional format.
Click to expand...
Click to collapse
Are you using Windows or Linux?
Also I don't have a RAZR M, I just wanted to grab some files from the system folder to use we with a CM10 ROM.
Sent from my Nexus 7 using Tapatalk 2

[Q] Multipart Archive File

I would like to create a .ZIP file of a large folder of files (~6 GB). In order to meet the upload requirements of a cloud service I use, the largest a single file can be is 1 GB. So, I need to create a multipart .ZIP file with each part being say, 512 MB.
I have found a few apps that say they can do this. The other requirement I have is that the process has to be either scriptable or automated in some way. That part I can't seem to figure out how to accomplish.
I have Tasker and I'm rooted so I hope there is a way to do this.
Thanks for any pointers, links, app suggestions, etc.

SJMarty said:
I would like to create a .ZIP file of a large folder of files (~6 GB). In order to meet the upload requirements of a cloud service I use, the largest a single file can be is 1 GB. So, I need to create a multipart .ZIP file with each part being say, 512 MB.
I have found a few apps that say they can do this. The other requirement I have is that the process has to be either scriptable or automated in some way. That part I can't seem to figure out how to accomplish.
I have Tasker and I'm rooted so I hope there is a way to do this.
Thanks for any pointers, links, app suggestions, etc.
Click to expand...
Click to collapse
Search RAR in the play store. It might do what you want. Unfortunately it can only be in the .rar format.
Edit: link here
Sent from a Nameless fellow licking Lollipop.
Singaporean Oppo Find 7a
Click that "Thanks" button if I helped you!

SJMarty said:
I would like to create a .ZIP file of a large folder of files (~6 GB). In order to meet the upload requirements of a cloud service I use, the largest a single file can be is 1 GB. So, I need to create a multipart .ZIP file with each part being say, 512 MB.
I have found a few apps that say they can do this. The other requirement I have is that the process has to be either scriptable or automated in some way. That part I can't seem to figure out how to accomplish.
I have Tasker and I'm rooted so I hope there is a way to do this.
Thanks for any pointers, links, app suggestions, etc.
Click to expand...
Click to collapse
Use WinRAR software to create a multipart RAR file and also choose self-extract option while creating part.
There will be one of all parts which is used to extract all parts automatically but you have to place all parts in same folder for extraction.
Then upload each part into cloud .

Irwenzhao said:
Search RAR in the play store. It might do what you want. Unfortunately it can only be in the .rar format.
Edit: link here
Click to expand...
Click to collapse
An .RAR is fine...I should have mentioned that it doesn't have to be a .ZIP.
I do see that this app will create a multipart .RAR but I don't see how to do this in an automated fashion...?

dkchalotra said:
Use WinRAR software to create a multipart RAR file and also choose self-extract option while creating part.
There will be one of all parts which is used to extract all parts automatically but you have to place all parts in same folder for extraction.
Then upload each part into cloud .
Click to expand...
Click to collapse
Unfortunately, WinRAR isn't going to help. I need to run the archive operation on the phone.

SJMarty said:
An .RAR is fine...I should have mentioned that it doesn't have to be a .ZIP.
I do see that this app will create a multipart .RAR but I don't see how to do this in an automated fashion...?
Click to expand...
Click to collapse
When you choose a file/folder, under Advanced Options, type in the size of a single part, then click OK. It's automated (unless I'm mistaken on your meaning of automated)
Sent from a Nameless fellow licking Lollipop.
Singaporean Oppo Find 7a
Click that "Thanks" button if I helped you!

Irwenzhao said:
When you choose a file/folder, under Advanced Options, type in the size of a single part, then click OK. It's automated (unless I'm mistaken on your meaning of automated)
Click to expand...
Click to collapse
I have a Tasker profile that creates a TWRP Nandroid backup using Online Nandroid Backup. Then, I'm using FolderSync to upload the backup to one of the cloud services. Since the service I'm using has a 1 GB single file size limit, the upload fails.
So, what I need is a shell script (or Tasker plug-in) that can combine all of the files in the TWRP Nandroid into a multipart archive. I have to be able to add the shell script/plug-in to the tasks for this profile. I would insert it in between the Nandroid backup and the cloud sync.
HTH clear it up a bit.

SJMarty said:
I have a Tasker profile that creates a TWRP Nandroid backup using Online Nandroid Backup. Then, I'm using FolderSync to upload the backup to one of the cloud services. Since the service I'm using has a 1 GB single file size limit, the upload fails.
So, what I need is a shell script (or Tasker plug-in) that can combine all of the files in the TWRP Nandroid into a multipart archive. I have to be able to add the shell script/plug-in to the tasks for this profile. I would insert it in between the Nandroid backup and the cloud sync.
HTH clear it up a bit.
Click to expand...
Click to collapse
Ahh, I see. I don't really use Tasker, so you'll have to figure out that part on your own. Sorry.
Sent from a Nameless fellow licking Lollipop.
Singaporean Oppo Find 7a
Click that "Thanks" button if I helped you!

How do I manually extract the backups I made using TWRP?

Hello,
In the ROM'ing journey, I backed up everything using TWRP on a OnePlus6.
I have all the files shown below here, but I am not sure how do you view them on the PC, as in what tool do I use? Using a archive tool doesn't work, from what I can see there are multiple part files and the archive tool doesn't seem to detect it.
I basically just want my DCIM, and Audio recordings out of it as of now.

rename data.ext4.win files to tar (or tar.gz) and open with 7-zip. these files aren't multiple part files. open each file on its own.
pictures are in data/media/0/DCIM/Camera and therefore not included in TWRP backup.

Oh, I see. Never thought they wouldn't be included by default, I thought backing up backs up absolutely everything

there's a warning on phone screen
also in documention
https://twrp.me/faq/backupexclusions.html