FORUMS
Remove All Ads from XDA

[TOOL] Whatsapp Xtract: Backup Messages Extractor / Database Analyzer / Chat-Backup

207 posts
Thanks Meter: 290
 
By ztedd, Senior Member on 5th April 2012, 07:13 AM
Post Reply Email Thread
2nd January 2019, 05:38 AM |#1371  
Senior Member
Flag Singapore
Thanks Meter: 37
 
More
Hi everyone

How do I encrypt the db back? My old db is corrupted, therefore I had to repair it. Now I want to restore it.
2nd February 2019, 05:51 AM |#1372  
Member
Thanks Meter: 7
 
More
Hi
Is there any way to use this method for transferring whatsapp messages from Android to iPhone?
2nd February 2019, 12:01 PM |#1373  
gh-thomas's Avatar
Junior Member
Thanks Meter: 5
 
More
Quote:
Originally Posted by ztedd

Merging of multiple whatsapp databases is still on the feature request list.

But you can use this tool to merge two sqlite databases and afterwards convert the merged database with Whatsapp Xtract:
SQLite Compare
http://www.codeproject.com/Articles/...ompare-Utility

HOW TO MERGE SQLITE DATABASE FILES WITH SQLite Compare:

  • 1. Open the old database file in SQLite Database Browser ( http://sqlitebrowser.sourceforge.net/ ). Open the table messages in Browse Data. Press the Button " > " as often as necessary to get to the last page. Scroll down to the last message. Now write down the number (_id) of that last message, e.g. 65422
  • 2. Now open the new database file in SQLite Database Browser. Open the table messages in Browse Data. Click on the first entry (which has most fields with value "-1"). Click on Delete Record. Have a look at the now first entry and write down the number (_id) of that first message, e.g. 12
    Now Click on Execute SQL and execute the following SQL statement:
    UPDATE messages set _id = (65422 + 1 + _id - 12)
    (replace 65422 by your last message _id in the old database and 12 by your first message _id in the new database)
  • 3. Now all messages in the new database have the correct _id's.
    Click on Save. Close all windows of SQLite Database Browser.
  • 4. Download & Install SQLite Compare ( http://www.codeproject.com/Articles/...ompare-Utility ). Open SQLite Compare.
  • 5. File - Compare
    For example:
    Left file: msgstore-2012-06-01.1.plain.db
    Right file: msgstore-2012-06-07.1.plain.db
    (Make sure to have a backup of both files!)
    x Compare schema and data
    x Compare BLOB fields
    OK
  • 6. Double Click on table "messages" in the result window OR left click on table "messages" and hit button "Edit selected difference..."
  • 7. A new window opens, "Table messages"
    Click on blue button "R" (it's located after "Refresh Comparison", "L" and before "≠", "=")
  • 8. Now on the right side all messages are shown that aren't included in the left file.
    Now you can select multiple messages (first left click on the first message to select, then scroll down to the last message to select and press SHIFT + left click on the last message to select).
    I noticed that you can't handle too many messages at once as it produces an error. Just try. I succeeded with about 1000-1500 messages.

    Now click on the button with the arrow from right to left: ←

    Now the selected messages are copied from the right database to the left database.
  • 9. Repeat the steps in (8.) until all the messages are copied from the right file to the left file.
  • 10. Maybe you also need to to this for the table chat_list if there are some new chat contacts in the newer backup file.
  • 11. Now the left file (e.g. msgstore-2012-06-01.1.plain.db) contains all the messages from the prior file msgstore-2012-06-01.1.plain.db and the newer file msgstore-2012-06-07.1.plain.db. (No saving necessary as the tool automatically applies the changes to the file after pressing the ← button).
  • 12. Now you have 3 options how to go on:

    a) Do you want to merge another database file, appending it to the merged file? Then repeat the steps with an even newer database file on the right, e.g. msgstore-2012-06-12.1.plain.db, if you have multiple database files to merge.

    b) Do you want to import the merged database file to Whatsapp? Then rename the merged database file (the left one) to "msgstore.db", copy it to the sdcard to location /sdcard/WhatsApp/Databases/msgstore.db and make sure that it's the only file in that folder. Now install Whatsapp and confirm when asked to import the Backup during installation.

    c) Or do you want to convert the merged database file to browser-friendly html using Whatsapp Xtract? Then give the left file msgstore-2012-06-01.1.plain.db to Whatsapp Xtract, e.g. using drag and drop onto the whatsapp_xtract_drag'n'drop_database(s)_here.bat.

Thank you for this guide @ztedd!
However I couldn’t compare my databases using SQLite Compare because of an error when opening the database. Could it be because of a new format?
Quote:

File opend that is not a database file
file is encypted or is not a databse.

Is it possible to use a tool like the Navicat for SQLite (which has a 14-day trial) to successful merge two databases?
And if yes, could someone make a tutorial how it works? I have no clue about SQL
I also tried merjapp by namnoops and sch3m4's wforensic, but both of them are unfortunately outdated and merge with missing information.
15th February 2019, 06:24 PM |#1374  
nioBee's Avatar
Member
Thanks Meter: 13
 
More
SQlite Compare problem in merging database
Quote:
Originally Posted by ztedd

HOW TO MERGE SQLITE DATABASE FILES WITH SQLite Compare:

  • ...
  • 5. File - Compare
    For example:
    Left file: msgstore-2012-06-01.1.plain.db
    Right file: msgstore-2012-06-07.1.plain.db
    (Make sure to have a backup of both files!)
    x Compare schema and data
    x Compare BLOB fields
    OK

I have a problem at this point, SQlite Compare doesn't work, I get this error:
File opened that is not a database file
file is encrypted or is not a database


The files are not encrypted, I can open them with WhatsApp Viewer and also with SQLite Database Browser (I did all the steps till nr 5 without problems)

Any hints on how to solve?
Post Reply Subscribe to Thread

Guest Quick Reply (no urls or BBcode)
Message:
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes