Database Info

[Q] spb backup problem

my phone has been destroyed .
how can I return my contact from spb backyp file to windows pc.

Use the SPB PC app to open & view backup file contents & then go to PIM section open contacts & save them to a CSV file that can be used to import them across various softwares & platforms.
You can also load pim from the backup into Windows Mobile device emulator to view PIM & save it via varying PPC softwares you prefer for future restore to PC/PPC or other platform mobiles.

Mister B said:
Use the SPB PC app to open & view backup file contents & then go to PIM section open contacts & save them to a CSV file that can be used to import them across various softwares & platforms.
You can also load pim from the backup into Windows Mobile device emulator to view PIM & save it via varying PC softwares you prefer for future restore to PC/PPC or other platform mobiles.
Click to expand...
Click to collapse
thanks a lot

My file didn't worked, since it's only an address book file....
I don't know what to do now.... OMG

i've the same problem .. someone can help us ?
thanks in advance

leodido22 said:
i've the same problem .. someone can help us ?
thanks in advance
Click to expand...
Click to collapse
PM me the file & I will convert it to a CSV contact file you can easily use on PC, PPC, most mobiles ect.
Although if backup file is from SPB you should be able to view & export contacts with PC software in link in previous post.

Hi.. I have the same problem.. My Galaxy s phone is broken and replaced by the store and they offered me an LG optimus x2 instead.
The problem is that all my contacts is locked inside kies in .spb files and i haven't been able to transfer or convert to my new phone..
Do anyone have any idea how to solve this.
I would be very grateful if anyone has a solution to this..

Hi.. I have the same problem.. My Galaxy s phone is broken and replaced by the store and they offered me an LG optimus x2 instead.
The problem is that all my contacts is locked inside kies in .spb files and i haven't been able to transfer or convert to my new phone..
Do anyone have any idea how to solve this.
I would be very grateful if anyone has a solution to this..

[TOOL] Merjapp - merge whatsapp databases

If you ever lost your phone due to an accident, or just had to use a temporary phone for some reason...
And you're one of those who hates to lose history, even if you know you hardly look at it...
This tool is for you.
Pre-requisites:
Neither of your phones where your whatsapp is installed need be rooted.
You must enable USB debugging on both devices
You must have Android SDK, we will be using the Android Debug Bridge (ADB)
Have Android Backup Extractor ready, we will use it.
Instructions:
Connect the phone which holds your old database to your computer, and enable USB debugging.
Use ADB to make a backup of the whatsapp database
Code:
adb.exe backup -f whatsapp.ab com.whatsapp
Use 'Android Backup Extractor' to extract whatsapp.ab to whatsapp.tar
Open whatsapp.tar with 7zip (or any other compression utility) and extract the file called 'msgstore.db'
Rename the file to 'old.db'
Repeat the above steps for your new phone, but rename the file to 'new.db'
Run merjapp in the following fashion:
Code:
java.exe -jar merjapp.jar -old old.db -new new.db
You can also use the -simulation mode if you like, it will not create any output database, and you will be able to read the log created in the working directory.
If you want extra debug information you can use the -debug mode.
If everything went correctly and "Done!' is displayed, rename output.db (which is your merged database) to msgstore.db
Connect your new phone to your computer, open the Whatsapp/Databases directory on the internal SD card and backup its contents to some other location.
Copy msgstore.db created in the previous steps to this directory
Clear whatsapp's data from your new phone and force stop it.
Open whatsapp and when prompted, elect to restore from backup, and voila!
Download
Download merjapp v141201 (runnable jar file)

Backup
Backup

Just registered to say thank you. It works!
Official whatsapp method wasn't working for me: "unable to recover chat history". So your tool saved me. Thanks!

namnoops said:
If you ever lost your phone due to an accident, or just had to use a temporary phone for some reason...
And you're one of those who hates to lose history, even if you know you hardly look at it...
This tool is for you.
Pre-requisites:
Neither of your phones where your whatsapp is installed need be rooted.
You must enable USB debugging on both devices
You must have Android SDK, we will be using the Android Debug Bridge (ADB)
Have Android Backup Extractor ready, we will use it.
Instructions:
Connect the phone which holds your old database to your computer, and enable USB debugging.
Use ADB to make a backup of the whatsapp database
Code:
adb.exe backup -f whatsapp.ab com.whatsapp
Use 'Android Backup Extractor' to extract whatsapp.ab to whatsapp.tar
Open whatsapp.tar with 7zip (or any other compression utility) and extract the file called 'msgstore.db'
Rename the file to 'old.db'
Repeat the above steps for your new phone, but rename the file to 'new.db'
Make back-ups of both old.db and new.db, as merjapp will make changes in them
Run merjapp in the following fashion:
Code:
java.exe -jar merjapp.jar -old old.db -new new.db
You can also use the -simulation mode if you like, it will not change your databases and you will be able to read the log created in the working directory.
If you want extra debug information you can use the -debug mode.
If everything went correctly and "Done!' is displayed, rename old.db (which is your merged database now) to msgstore.db
Connect your new phone to your computer, open the Whatsapp/Databases directory on the internal SD card and move its contents to some other location
Copy msgstore.db created in the previous steps to this directory
Clear whatsapp's data from your new phone and force stop it.
Open whatsapp and when prompted, elect to restore from backup, and voila!
Download
Download merjapp v141005 (runnable jar file)
Click to expand...
Click to collapse
A pretty neat tool!
I was trying to merge two databases. It seemed that everything went okay and all with the "Done!" message. However, there seems to be no changes made two any of the database. Their filesizes remains the same for old.db and new.db.
I tried loaded the old.db anyway since you said that is the merged one. However, I am getting only the old one.
Please advise.

And you didn't use the '-simulation' flag by chance, right?
Can you attach the log file?

Hi,
I think I have done everything as instructed above. But the phone doesn't seem to recognize the new mgstore.db backup file.
I notice that the new file isn't crypt7 as the original mgstore.db file from the internal drive. Is that causing my problems? How do I fix it?
Greetz

clevernam said:
mgstore.db
Click to expand...
Click to collapse
Did you make a typo with the file like you did here? It should be msgstore.db, not mgstore.db.
No, it doesn't have to be encrypted in order for whatsapp to recognize it.

namnoops said:
Did you make a typo with the file like you did here? It should be msgstore.db, not mgstore.db.
No, it doesn't have to be encrypted in order for whatsapp to recognize it.
Click to expand...
Click to collapse
Nope, that's not it, just checked.
Do i have to put it into the msgstore.tar file? Where i extracted new and old from?
Greetz (thanks for helping btw., if this works, its a realy big help to me!!)

Nope, you just have to place msgstore.db inside the 'whatsapp' directory on your internal SD card (I'd make sure it's the only file there).
Then clear data on whatsapp, force close it, and run it.
Is that exactly what you're doing?

Multiple Databases
Can this app merge multiple databases...
Like if i want to merge 3-4 old databases into one? is it possible? if either one of these databases have same data, will that be duplicated?

It can merge more than one, but that's under the assumption they're mutually exclusive (in terms of messages - i.e., no message appears twice)
So if you used one phone (1), started with a clean whatsapp on a second phone (2), then another clean whatsapp on a third (3), and so on...
You'll merge (1) as 'old' and (2) as 'new', then use the output as 'old' and merge it with (3) as 'new', etc.

namnoops said:
Nope, you just have to place msgstore.db inside the 'whatsapp' directory on your internal SD card (I'd make sure it's the only file there).
Then clear data on whatsapp, force close it, and run it.
Is that exactly what you're doing?
Click to expand...
Click to collapse
Yes, thats exactly what i did. Any other idea what could be wrong?

I'm sorry - it should be under WhatsApp/Databases like the opening post says...

namnoops said:
I'm sorry - it should be under WhatsApp/Databases like the opening post says...
Click to expand...
Click to collapse
That's what i figured, because I was already thinking about all the other files with dates like msgstore-2014-10-12.1.db.crypt7 that i took out of the Database folder.

namnoops said:
I'm sorry - it should be under WhatsApp/Databases like the opening post says...
Click to expand...
Click to collapse
The output file, that I renamed to msgstore.db has "gear wheels" as an icon, but the msgstore file from the database of the phone has no icon at all. Is that somehow significant? Does that maybe lead you to my mistacke?

The fact the the output file has the 'gear wheel' icon just means Windows detects it as a database, I think it's quite meaningless...
The other files it didn't give this icon are *.db? Or are you referring to the encrypted databases? They encrypted ones probably won't have this icon.
It seems to me you're doing everything right:
Renaming the file to 'msgstore.db'
Put it in your internal SD card under WhatsApp/Databases
Making sure there's no other file there except this file
Force closing whatsapp, clearing data, opening the app...
So you're doing all this, and when whatsapp loads it initializes from scratch and doesn't tell you a backup has been found?
It just goes on to initialize an empty database as though you just installed whatsapp for the first time?

namnoops said:
The fact the the output file has the 'gear wheel' icon just means Windows detects it as a database, I think it's quite meaningless...
The other files it didn't give this icon are *.db? Or are you referring to the encrypted databases? They encrypted ones probably won't have this icon.
It seems to me you're doing everything right:
Renaming the file to 'msgstore.db'
Put it in your internal SD card under WhatsApp/Databases
Making sure there's no other file there except this file
Force closing whatsapp, clearing data, opening the app...
So you're doing all this, and when whatsapp loads it initializes from scratch and doesn't tell you a backup has been found?
It just goes on to initialize an empty database as though you just installed whatsapp for the first time?
Click to expand...
Click to collapse
Precisley. Nothing comes, when I reinstall whatsapp.
It is not like when I put the normal backup data back in the databse folder. Then whatsapp realises that there is a backup file in the internal memory and gives me the option to restore the history. Not so with the merged file.
Btw. I have no sd card. I connect the phone with usb. I figured that it is an unessencial diffrence? Am I wrong? My phone btw. is Motorola Moto G. If that helps
I'll check, if the old an new are mutually exclusive. I think in the progress I got a message on the new and old one. What would happen in that case? Would your program do the job, but then creat a bad "output" file?
If the only problem was, that I messed up the historys, I'm sorry, namnoops.

Are you using the latest version of whatsapp?

iclumyc Doctrine
namnoops said:
Are you using the latest version of whatsapp?
Click to expand...
Click to collapse
Well if I didn't then, now I do. And it still doesn't work

I checked if there are any intersecting messages... It turns out there weren't any.
@namnoops: Does the oldest message in the new history have to be more recent then any old message from the old history? I mean: Is it a problem for merjapp if the timelines intersect in any way, although there are no double messages?
Thanks for your help in advance

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

HiSuite Encrypted backup Help!

Hi,
I recently used HiSuite to backup my honor 6x. When I backed-up the phone I chose to use a password to encrypt the files. The files are saved as .enc format. For example I have pictures saved as XXXXXXX.jpg.enc on my PC.
Here is the problem:
I lost my phone... And now I'm trying to go to the backup on my PC to recover my valuable contact information and pictures. How can I decrypt those .enc files and access my backup files?
Standing by for help.
Thank you!

Charley_CS said:
Hi,
I recently used HiSuite to backup my honor 6x. When I backed-up the phone I chose to use a password to encrypt the files. The files are saved as .enc format. For example I have pictures saved as XXXXXXX.jpg.enc on my PC.
Here is the problem:
I lost my phone... And now I'm trying to go to the backup on my PC to recover my valuable contact information and pictures. How can I decrypt those .enc files and access my backup files?
Standing by for help.
Thank you!
Click to expand...
Click to collapse
You just need any other huawei device to decrypt the files by restoring it.....

Khan ubaid said:
You just need any other huawei device to decrypt the files by restoring it.....
Click to expand...
Click to collapse
Good to know! I will try that out. Thank you!

Need help too
I have a similar problem and I already bought another Huawei... I did a backup with a Huawei p20 and lost it...
Get a new p20 but my files look like a mess is not a zip file when I open hisuite and try to restore the files, the program don't open the files or anything so I really need to get access to my back up
Hope someone can help me to sort it out.

I can help you.
If you know the password used for the backup, you can help decrypt it.
If you send encrypted backup folder and password by e-mail, we will decrypt and send it.
[email protected]

I did the same thing (backed up using HiSuite and password). Got extension .enc in every single file. Now, I'd like to open the file (video - .mp4) on my computer. So, I want to convert the .mp4.enc to just .mp4. How can I accomplish that? Thanks!

marret said:
I did the same thing (backed up using HiSuite and password). Got extension .enc in every single file. Now, I'd like to open the file (video - .mp4) on my computer. So, I want to convert the .mp4.enc to just .mp4. How can I accomplish that? Thanks!
Click to expand...
Click to collapse
Not sure if it will work but select the file, double click and select the option rename and then delete the .enc part. Before trying this copy the file to another location

marret said:
I did the same thing (backed up using HiSuite and password). Got extension .enc in every single file. Now, I'd like to open the file (video - .mp4) on my computer. So, I want to convert the .mp4.enc to just .mp4. How can I accomplish that? Thanks!
Click to expand...
Click to collapse
HI MArret,
I faced this unpleasant situation in August, on this I wrote an article on Linkedin, no login or account required
If you follow carefully my guide you will be able to see files content.
Here you are
linkedin.com/pulse/huawei-backup-decrypt-gherardo-magnini
bye
G

Here there are a Python3 script by dfirfpi and my "porting" to C# for latest HiSuite / KoBackup v9.x
Enjoy it!
Huawei backup decryptor
GitHub - RealityNet - kobackupdec - Huawei backup decryptor
GitHub - wizardgsz - kobackupdec .NET

hi, how do i open it? i am noob sorry

hi, how do i open it? i am noob, sorry but i tried to use both and i don`t know

caster74 said:
hi, how do i open it? i am noob sorry
Click to expand...
Click to collapse
Google for Perl, it is a programming language. You can also use my C# porting.
https://www.perl.org/
https://en.wikipedia.org/wiki/C_Sharp_(programming_language

which file should i edit in strawberry perl?

caster74 said:
which file should i edit in strawberry perl?
Click to expand...
Click to collapse
Here there is the Perl script, contact the author or ask to Perl developers for further info:
https://github.com/RealityNet/kobackupdec

And how restore if I tried rename it from ***.jpg.enc to ***.jpg . after unsucceed try I renamed it back to ***.jpg.enc
BUT NOW BACKUP PASSWORD NOT WORKING. SOMEBODY HELP.

pms91 said:
I can help you.
If you know the password used for the backup, you can help decrypt it.
If you send encrypted backup folder and password by e-mail, we will decrypt and send it.
[email protected]
Click to expand...
Click to collapse
What do i do if i forgot my password to my backups. Is there anyway i can decrypt the backup.....

Any guidance much appreciated
Hi all, thanks for all your time and input. Is there a way of decrypting the hisuite backup folder on a pc and then somehow transferring that data to a non-huawei phone?
Probably not, so maybe my best bet would be to borrow a spare Huawei phone and recover to that and then transfer phone to phone, I have the password.
Ps. Wish I hadn't changed over phones so fast

Hi,
I recently used HiSuite to backup my honor 8pro. When I backed-up the phone I chose to use a password to encrypt the files. The files are saved as .enc format. For example I have pictures saved as XXXXXXX.jpg.enc on my PC.
Here is the problem: now I'm trying to go to the backup on my PC to recover my valuable contact information and pictures. How can I decrypt those .enc files and access my backup files?
Thank you!

As the information is scattered all over, here is the latest summary of the steps to decrypt your HiSuite backup folder (thanks to all the previous contributors):
The example steps assume you are running Windows 10 64 bit and running python 3.8.6:
1. Download python windows 3.8.6 version (64 bit)
python-3.8.6-amd64.exe
or select your version here
python.org/downloads
2. Download decrypt package (64 bit and matches python version 3.8x)
pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
or select your version here (to match the Windows/Linux 32/64 bit version and python version)
pypi.org/project/pycryptodome/#files
3. Download the decrypt python script
github.com/RealityNet/kobackupdec
eg. kobackupdec-master.zip
4. Install python
run python-3.8.6-amd64.exe
create new folder eg. d:\python38 and install
5. Install decrypt package
copy pycryptodome-3.9.8-cp38-cp38-win_amd64.whl to python38 folder then install as follows:
D:\Python38>py -m pip install pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
Processing d:\python38\pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
Installing collected packages: pycryptodome
Successfully installed pycryptodome-3.9.8
6. Copy the decrypt script to the python38 folder
kobackupdec.py
7. Decrypt the encrypted HiSuite folder eg. d:\Hisuite\HUAWEI P40 Pro_2020-06-12 19.16.10
Note: destination folder eg. f:\testrestore must be new (does not exist) and the backup_password is the password you used to encrypt the folder
D:\Python38>py -3 kobackupdec.py -vvv backup_password "d:\Hisuite\HUAWEI P40 Pro_2020-06-12 19.16.10" f:\testrestore

kcchan48 said:
As the information is scattered all over, here is the latest summary of the steps to decrypt your HiSuite backup folder (thanks to all the previous contributors):
The example steps assume you are running Windows 10 64 bit and running python 3.8.6:
1. Download python windows 3.8.6 version (64 bit)
python-3.8.6-amd64.exe
or select your version here
python.org/downloads
2. Download decrypt package (64 bit and matches python version 3.8x)
pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
or select your version here (to match the Windows/Linux 32/64 bit version and python version)
pypi.org/project/pycryptodome/#files
3. Download the decrypt python script
github.com/RealityNet/kobackupdec
eg. kobackupdec-master.zip
4. Install python
run python-3.8.6-amd64.exe
create new folder eg. d:\python38 and install
5. Install decrypt package
copy pycryptodome-3.9.8-cp38-cp38-win_amd64.whl to python38 folder then install as follows:
D:\Python38>py -m pip install pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
Processing d:\python38\pycryptodome-3.9.8-cp38-cp38-win_amd64.whl
Installing collected packages: pycryptodome
Successfully installed pycryptodome-3.9.8
6. Copy the decrypt script to the python38 folder
kobackupdec.py
7. Decrypt the encrypted HiSuite folder eg. d:\Hisuite\HUAWEI P40 Pro_2020-06-12 19.16.10
Note: destination folder eg. f:\testrestore must be new (does not exist) and the backup_password is the password you used to encrypt the folder
D:\Python38>py -3 kobackupdec.py -vvv backup_password "d:\Hisuite\HUAWEI P40 Pro_2020-06-12 19.16.10" f:\testrestore
Click to expand...
Click to collapse
I decrypted all the files as the procedure you said but images are in .tar format and every time open it shows error like archives in unknown format or damaged i tried downloading other archives like 7 zip or win zip but solved please help regarding this problem