Hiya there.
Im kinda new here in this forum so greet me well . ^^
Well I juz finished searching and figured out . I would like to share how to combine multiple mmssms.db (Message Data) file into one file where the file located on /data/data/.com.android.providers/databases
So what we gonna need is these 2 file .
*[TOOL] yaffs extractor, mmssms.db & contacts2.db converter
*SMS Backup & Restore
1. Extract yaffs extractor, mmssms.db & contacts2.db converter to you main drive. (Like mine ish C:\ )
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
So theres the file that you extracted located open it up and see wether all the file extracted is same as in the pic.
2. Next we have to put the *.db file in the yaffs extractor, mmssms.db & contacts2.db converter folder,I have 2 backup *.db so I made 2 folder(Message1 and Message2) which is each mmssms.db file in each folder.
3. So now were gonna convert the *.db file into *.xml .
Run cmd and put this command . (Convert all your backup *.db cause we gonna need it , depends how many you have )
cd c:\yaffs-mmssmsdb-calls-extractor
extract -s Message1\mmssms.db
Message1.xml
Juz put anyname you like as long you put .xml along with the name .
Click to expand...
Click to collapse
And the converted file will be in the same folder yaffs extractor, mmssms.db & contacts2.db converter in the *.xml format . We gonna need those files soon just let it there .Now we're almost done , going to next step.
Next, install SMS Backup & Restore on your phone . Put all converted *.xml file in the /sdcard/SMSBackupRestore/
Now open up SMS Backup&Restore that you have install on your sdcard.
Wait till the Apps pop out and Click on Restore , you will see the *.xml file that you have copied to the /sdcard/SMSBackupRestore/ .
Now, Click on each of *.xml and restore every single of your backup message file.
And the Results ..
The Failed might be due to corrupted or unread message while backup.
Thats it ! You're done, you have merged all of you mmssms.db into one file.
Goodluck on trying , glad to help and share. ^^
Perfect
This has been a real life-saver for me. Works perfectly. Many many thanks for sharing.
Thanks a million
This is really a lifesaver,
The screen of my phone died, so all I had access to was adb and through this guide I was able to restore messages.
I did not have to merge, but it worked the same.
Thanks once again
Fantastic!
Worked like a charm! I've been different methods all week, trying to copy the old mmssms.db to the database directory, and everything failed. But not this!
Tank you!
agan TS
so what if we want to merge multiple contacts2.db? is it the same way? i am pretty sure it's not, the command would be different right?
thank you for this tutorial, very helpful
Does this merge MMS messages as well? Or does it only merge SMS text messages?
I know SMS Backup & Restore typically doesn't restore MMS so I'm thinking this method won't work for MMS.
SMS all Data with Delivered Date and Hour Backup/Merge/Restore
Hello,
I have a problem with all these sms backup programs.
I wish to get all SMS Data, like sent Date/Hour Text etc.
But also I wish to save the Delivered Time.
Does somebody know a Program the can list these Data and/or Backup this Data.
I could Backup nearly everything except the Delivery_Date and Delivery_Status.
Can somebody tell me how I can import/transfer/merge the SMS Data from my Note2 and Note4 to my new S7edge
Thanks for your help
George
I try do this but i have some error :
extract : The term 'extract' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a p
ath was included, verify that the path is correct and try again.
At line:1 char:1
+ extract -s Message1\mmssms.db
+ ~~~~~~~
+ CategoryInfo : ObjectNotFound: (extract:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
Suggestion [3,General]: The command extract was not found, but does exist in the current location. Windows PowerShell does not load commands from the current location by default. If you trust this command, instead type: ".\extract". See "get-help about_Command_Precedence" for more details.
PS C:\yaffs-mmssmsdb-calls-extractor>
Related
Its a free Root Explorer without Ads and without network use.
When busybox and root modes are enabled, you can make dumps of your nand partitions and export Kernel and initramfs (Menu/Tools)
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
https://market.android.com/details?id=fr.wdscript.yaffsexplorer
You can report here bug and feature requests...
Example : Dump and Rename The /cdrom partition (p17)
change dump file ext from .raw to .iso and you get your Windows drivers (MotoHelper 2.0.44 Driver 4.9.0 - 27 Jan 2011)
Version 1.9.9.8 attached
Awesome thanks, will def check this out.
useful tool
How can i dump the roofs?
can i restore it after backup?
Thank you.
This tool execute this command :
dd if=/dev/block/<partition> of=/sdcard/<partition>.raw ibs=8192 obs=8192 conv=notrunc
So you can do the reverse command (not in the tool because dangerous)
Update v1.1 : You can create yaffs images now
Epsylon3 said:
This tool execute this command :
dd if=/dev/block/<partition> of=/sdcard/<partition>.raw ibs=8192 obs=8192 conv=notrunc
So you can do the reverse command (not in the tool because dangerous)
Click to expand...
Click to collapse
Do you know, how to dump and remount the rootfs?
Thank you.
in fact, i dont know... rootfs is mounted before android (initrd on some devices)
Epsylon3 said:
in fact, i dont know... rootfs is mounted before android (initrd on some devices)
Click to expand...
Click to collapse
Ok, thank you.
Ok, been using this for a while now; couple suggestions.
1. Copy feature needs to work more like Root Explorer.
---- So when you long-press and copy a file, two buttons popup, Paste and Cancel - Maybe you could even add a third to paste quickly to a favourites folder without leaving working directory ?
2. Be able to change text size of file browser. I have big fingers heh.
3. Have a Mount/Unmount button similar to the Mount R/W in Root Explorer.
--- I find I cant copy anything to anywhere, am I just missing something ?
4. Select multiple files, and copy, delete, zip, move . . . . . to favourites ?
5. Compress files or folders and save zip to a saved favourites without leaving working directory.
6. Load apk icons maybe; easier to find things sometimes.
7. Show favourites picker on program startup. I'm always working in the same directories.
A built in text editor with line numbers would be awesome. Maybe an sqlite editor addon too ?
I like what this looks like so far; I really like that you can see symlinks, the dropdown with recent paths, nandroid dumps of any partitions (nice), and the favorites are cool. Just hoping it can take over for root explorer.
Keep up the great work so far. Will be keeping on eye on this for sure.
Thanks for your report
First, i dont want to copy Root Explorer or all these slow and "3 lines" explorers... So no image/movies preview... This tool is focused on system files exploration
Apk icons maybe but not in my prority (filter by name is nice), line size : not for the moment (maybe a zoom or something later)
The multiselect on click is almost ready (for files), to keep folder navigation
the Mount/Unmount will be in tools menu later (in mounted devices menu) i need to make a new window for that... but that need work (and could make lot of reports from unknown devices, like chinese ones)
Compression.... yea hmm v2.0
Hm. I tried this, but it is a lot slower than Root Explorer. Perhaps this is because it shows a lot more objects, or due to it having a lot of features I do not directly associate with a program to manage files. Still, I can not say that having more competition is a bad thing, so keep up the good work
its because the tool use a terminal process to list folders, and a new one on each refresh... I think i can optimize that if i keep the shell process opened.
but Root enabled, its 5x slower (220ms instead of 40ms)... i think there could be a problem with superuser tool, will try to uninstall it to check...
johnw.xda said:
Do you know, how to dump and remount the rootfs?
Thank you.
Click to expand...
Click to collapse
to remount In fact like others :
Code:
mount -o rw,remount,relatime -t rootfs rootfs /
This feature will be available in some minutes (v1.3.0)
But to dump... you need to skip /proc /tmp and /sys
Hi.
I´m using your app in a Samsung galaxy S.
I lost one file and I want to recover it from a CWM backup.
Your app lets me read the backup, but I cant save the needed file ...
Is there a possibility to extract it from the backup?
Thanks in advance
Its the next step yaffs extraction...
sorry, not for the moment (but soon)
just made an update v1.3.2 which really enhance exploration speed...
I hope you release it soon
Thanks
I can't Dump Partition. A circular thing shows up then it disapear and no text saying records in+out and that it finished (like in the screenshot). And there is no file on my SD card and yes I have plenty of space.
Tried several of the small 512k partitions and the Boot and Recovery partitions.
I'm running rooted froyo 3.4.2-155, few bloat APK's removed.
this feature uses busybox "dd" applet, try to set another busybox in setting window
you can search for them in other apps, do a search in /data/data/
Namiga said:
Hi.
I´m using your app in a Samsung galaxy S.
I lost one file and I want to recover it from a CWM backup.
Your app lets me read the backup, but I cant save the needed file ...
Is there a possibility to extract it from the backup?
Thanks in advance
Click to expand...
Click to collapse
Done... in v1.5.0 Single file or Folder for the moment... (file/folder context menu)
full extraction will be possible in next version... not linked
When you take a look at the original ROM file for the ACE device you will see this files below:
- hboot... bla, bla, bla (which is self spelling)
- boot.img (...no comment...)
- recovery.img (...no comment again...)
- system.img (...we all know what's inside)
...a few more files and...
- lib.img (...uhhh??? what's this???)
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
When you open the lib.img there you can find all the files which belongs to the /system/lib folder.
So far - everything seems to be O.k. BUT now my problem and question.
When I use the PD98IMG.zip to install my device and do a backup with the RECOVERY tool and create .tar files - the /system/lib folder within the backup is empty.
When I do a wipe of my device and erase EVERYTHING on it and I try to restore my backup file this fails. This was driving me nearly crazy until I have found that the /lib folder has his own partition.
First I need to restore the original PD98IMG.zip and after this I'm able to successfully restore my backup.
On the one hand this is a great thing because this will offer more space within the /system partition and this will give the DEV's more options for porting ROM's from and to other devices.
On the other hand - where the hell is the /lib folder or partition or whatever located on the DHD device???
Regards!
I think these files are from the Sense 3.0 leaked ROM for ace rite?
For some reason they've made a separate lib.img & if you want to know how exact & where it is extracted during the installation, unpack boot.img & check init.rc / init.spade.rc..
You'll see few lines in either of the files related to extraction of lib.img..
hope this helps
fshami said:
I think these files are from the Sense 3.0 leaked ROM for ace rite?
For some reason they've made a separate lib.img & if you want to know how exact & where it is extracted during the installation, unpack boot.img & check init.rc / init.spade.rc..
You'll see few lines in either of the files related to extraction of lib.img..
hope this helps
Click to expand...
Click to collapse
Yep m8, this is related to the leaked 3.06 ROM for the ACE.
I guess this might be interesting for some DEV's and this is also a thing which needs to be covered by the guy's who are developing the kernels and ramdisk for the ACE.
Also the 4EXT Recovery should be adjust for the ACE device.
From my point of view this is a good solution to get more space on the /system partition.
The next thing is /data/at folder within the original dzdata.img and the sub folders. This folders will be mounted automatically to the /system partition. Don't know how...
Let me give an example for WhatsApp.apk
The original dzdata.img contains this folder structure:
/data/app
/data/at/app
/data/at/lib
/data/at/plugin
If I store this file within /data/at/app I can use WhatsApp without creating an hard link to the /system/apps folder.
All this things might be interesting for the DEV's.
Just a quick (related) question. How do you unpack dzdata.img?
It might not be a hidden/new partition. Quite the contrary. Notice that with the 3.06, there's a new hboot shipped. I'm theorizing, that it changes the partition layout, chopping up /system into smaller partitions. Now, as we all probably use the eng hboot and a custom update-script for unsigned roms, this doesn't concern us.
Or at least that's my theory. I remember in the sapphire/magic days, the new radio would allot more flash space to /system to fit in SenseUI, while old radio would allot more space to /data.
Delete
Thank you very much for sharing
Thanks for sharing. But I can not see any system img files via 7zip without previously repaired. May I use repaired system img files?
You must be doing something wrong. I've tried WWE and Orange PL and both extract without repairing.
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Thanks for sharing.
thank u!
Thanx mate later that day ill extraxt System dump an share it with you guys.
Thanks for the DiskInternals thingy
Since i never needed to extract a System.img I never looked for a method but I will remember this. Seems fairly straightforward.
And thanks for the creds.
I will try this one.
Btw, i made a backup with twrp. Ia there any way to get the backed up system.emmc.win file extracted? Renaming it to .tar doesn't work.
What I try to achive is an extracted ROM so I can deodex the apks
DroidShift79 said:
I will try this one.
Btw, i made a backup with twrp. Ia there any way to get the backed up system.emmc.win file extracted? Renaming it to .tar doesn't work.
What I try to achive is an extracted ROM so I can deodex the apks
Click to expand...
Click to collapse
add .tar to the end of each image and under Linux or cygwin use tar -xvf xxxx.tar
Hmm... Hoped there's anything for win 8.1
...setting up cygwin
Edit: @LeeDroid
Nothing happens when doing the command in the cygwin window...
Worked like a charm
I did have to edit the ConvertHima.bat and remove the line set wf=%cd%\ for it to work
but everything else was spot on .. thanks!!
Anyone need the 0PJAIMG_HIMA_UL_L50_SENSE70_ATT_NA_Gen_Unlock_1.32.617.6_R2_Radio_01.01_U11440221_59.04.50303G_2_F_release_426167_signed.zip
System.img or Dump
Worked great I think. I did get an error, and I received this error 4 times for sparse.img, 2,4,6,8. Here is the error: - "1 [main] sparse2img 7912 find_fast_cwd:". It also says "WARNING Couldn't compute FAST_CWD pointer. Please report this problem to the public mailing list [email protected]". I wrote cygwin, and got a reply from a Marco stating, "Dear Hal, Same answer as given last month to another guy". Then gave me this link https://cygwin.com/ml/cygwin/2015-05/msg00318.html. Followed by, "Please report the solution to whom provided the ConvertHima.bat". The answer in the link basically says a utility called rsync is being used, and the person who provided it is bundling it with an old version of the cygwin kernel. I did however get a new system_hima.img, and I started ConvertHima.bat. After completion I have what appears to be a complete system image. It's 3.53Gb in size, and has the folders - app, bin customize, etc, fonts, framework, lib, lib64, lost+found, media, priv-app, tts, usr, vendor, xbin, and has the file build.prop. It appears to have all the Deodexed APK's in app and priv-app. This is from the T-Mobile RUU. I'm using Window 8.1.
I'm trying to create a system dump (1.40.708.9)but was stuck at step 2. Where can I download my ROM.zip?
xunus said:
I'm trying to create a system dump (1.40.708.9)but was stuck at step 2. Where can I download my ROM.zip?
Click to expand...
Click to collapse
i think you misunderstand what this is for
flex360 said:
i think you misunderstand what this is for
Click to expand...
Click to collapse
That could be true. Seems like this is to extract M9's rom from an RUU and not from the phone itself.
Mr_Bartek said:
You must be doing something wrong. I've tried WWE and Orange PL and both extract without repairing.
View attachment 3226483
Click to expand...
Click to collapse
Can you send me the file system.img_01 ?
htsang08dqt said:
Can you send me the file system.img_01 ?
Click to expand...
Click to collapse
https://forum.xda-developers.com/one-a9/development/decrypt-ruu-ruu-decryption-script-htc-t3282562
Is there a Linux version of the sparse2img.exe? I am in need of this because I don't have the system.img but I have the system.img_xx chunks from the RUU ZIP.
Hello people
Today I flashed the Xiaomi EU android 11 to check it out and saw some bugs and wanted to downgrade to android 10.
I flashed the stock rom as I was downgrading and installed TWRP, Fully wiped the phone and wanted to restore my backup, but it says " extractTarFork() process ended with ERROR: 255 " when restoring the data. Needless to say, I had to type my password when I booted to recovery and I had Fingerprint and Pincode enabled when I was backing up. now I checked the recovery log and the error is
Code:
==> extracting: //data/misc/recovery/ (mode 40770, directory)
tar_extract_file(): failed to extract //data/misc/recovery/ !!!
When I browse that Directory there is some files named Fingerprint so looks like this is making some issues.
Could someone please help me out how I am able to delete this directory and try restoring my Data ?
I have tried any way of wiping and installing stock rom but still I get this error.
Looks a recovery error. Is the back up made with different recovery? Looks like it cannot find or extract it from the back up. Can you get back to where you were when you made the back up and restore from there?
If not, looks like a format and start again.
Sathelp said:
Looks a recovery error. Is the back up made with different recovery? Looks like it cannot find or extract it from the back up. Can you get back to where you were when you made the back up and restore from there?
If not, looks like a format and start again.
Click to expand...
Click to collapse
Yeah it is from the same recovery.
It is a common error when you google it. but the fix they have mentioned does not work for me. It is like I should somehow delete that folder or files causing the issue from the backup and restore it.
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
You'll need to mount it on a pc, extract the folder and compress it again or delete it from the archive and save. I would make a copy first though.
Sathelp said:
You'll need to mount it on a pc, extract the folder and compress it again or delete it from the archive and save. I would make a copy first though.
Click to expand...
Click to collapse
ok I am able to extract it with WinRar. but how should I compress so the TWRP will not face issues? on Winrar I have RAR,RAR4 and ZIP that I think will not work.
Use 7 zip.
To create a tar file, you can highlight the files you'd like to archive, right-click, and go to 7-Zip > Add to archive. In the 'Add to Archive' menu, just select 'tar' as your archive format and click OK.
Did you get it fixed?
Sathelp said:
Did you get it fixed?
Click to expand...
Click to collapse
No, it didnt work. When i extracted the file using 7zip I got errors for everyfile. I think the issue is with the pincode and the data being encrypted. So next time I should remove the lockscreen and backup my data.
Goos thing I had backed up on Google Account.
Thanks for letting us know but good luck my friend
im having the same error in my realme xt... I have a twrp backup of system image vendor image data boot recovery persist but im unable to recover because it shows an error extract tar fork process ended up with error 255{i too have locked the phone with pincode during backup} ....i also have a backup of my internal storage in twrp but im not able to restore because of this error.... kindly help me
Some of the TWRP we use on Mi 10 ultra, dont able to decrypt data using Fingerprint or pin, you need to use pattern, this is a TWRP bug.
What a bull**** bug. There should be warnings about this at least when people go to create a backup.
Hello, I can't find cache/data folder on android phone.
In android system settings opera takes 500mb of data (cache and user data). But in File Manager , phone storage>Android>data>com.opera.browser , this folder only takes 40kb of space.
I don't need to delete it, I need to access it's cache.
Maybe you can help to find opera cache folder on Android? Thank you.
MisterMonitor said:
Hello, I can't find cache/data folder on android phone.
In android system settings opera takes 500mb of data (cache and user data). But in File Manager , phone storage>Android>data>com.opera.browser , this folder only takes 40kb of space.
I don't need to delete it, I need to access it's cache.
Maybe you can help to find opera cache folder on Android? Thank you.
Click to expand...
Click to collapse
You can find the Folder containing Cache for Opera at:
Code:
/data/data/com.opera.browser/cache/cache/Cache_Data
good luck
Slim K said:
You can find the Folder containing Cache for Opera at:
Code:
/data/data/com.opera.browser/cache/cache/Cache_Data
good luck
Click to expand...
Click to collapse
Thanks for answering, but I cannot find this folder.
Android>Data>com.opera.browser
I see only two folders here:
Cache and Files.
In Cache folder there are:
adxads folder and adxlib folder.
adxads is empty, and adxlib has only one file called omsdk.js and its size is 40 kilobytes.
MisterMonitor said:
Thanks for answering, but I cannot find this folder.
Android>Data>com.opera.browser
I see only two folders here:
Cache and Files.
In Cache folder there are:
adxads folder and adxlib folder.
adxads is empty, and adxlib has only one file called omsdk.js and its size is 40 kilobytes.
Click to expand...
Click to collapse
The aforementioned Folder at /data is only accessible with Root access (UID 0) or a system app. In android, Data folders for apps are only accessible to the corresponding App (meaning opera itself, not your file explorer, which is a separate app). If you don't have root, you can get away with setting selinux to permissive and trying.
Here is a screenshot without root:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
and here is the one with root: (now you can see user apps)
Here is the inside of the folder path:
If you can't change selinux or don't have root, then it's impossible to access. Sorry
Slim K said:
The aforementioned Folder at /data is only accessible with Root access (UID 0) or a system app. In android, Data folders for apps are only accessible to the corresponding App (meaning opera itself, not your file explorer, which is a separate app). If you don't have root, you can get away with setting selinux to permissive and trying.
Here is a screenshot without root:
View attachment 5610225
and here is the one with root: (now you can see user apps)
View attachment 5610227
Here is the inside of the folder path:
View attachment 5610229
If you can't change selinux or don't have root, then it's impossible to access. Sorry
Click to expand...
Click to collapse
Omg, thank you for such a detailed post !! Big big thanks to you.!
Never heard abuot selinux. Is it dangerous to modify it ?