+ Reply
Results 1 to 10 of 10

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: how do you merge two sms.db files? [texts from two iphones]

is a discussion within the

File Mods

forums, a part of the

iPhone Modding

section;
...
  1. #1
    What's Jailbreak?
    Join Date
    Mar 2010
    Location
    Philadelphia
    Posts
    21
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Default how do you merge two sms.db files? [texts from two iphones]
    hi, i backed up my sms/texts [\private\var\mobile\Library\SMS] from my iphone 3g. then i went out and got the iphone 4. it took a month for the jailbreakme.com to come out, so i couldn’t load my backup from my 3g to iphone 4 on release day. question: how do i MERGE my iphone 3g sms backup with my iphone 4 sms backup?

    i tried this site (https://smsmerge.homedns.org/) even though it said it wouldn’t work with frimwares 3.0 and up without any results (no surprise, i had to try)

  2. #2
    What's Jailbreak?
    Join Date
    Aug 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Download a sqlite database explorer/manager. I can't think of the name of the one I used right now. That should allow you to open the sms.db files, and depending on which manager you find, possibly let you merge them.

  3. #3
    What's Jailbreak?
    Join Date
    Mar 2010
    Location
    Philadelphia
    Posts
    21
    Thanks
    3
    Thanked 2 Times in 2 Posts

    yeah i downloaded sqlite manager plugin for firefox and got this error when trying to add a new record in the "message" table:

    SQLiteManager: Create statement failed (executeWithParams): INSERT INTO "main"."message" ("ROWID") VALUES (4325345) [ no such function: read ]
    Exception Name: NS_ERROR_FAILURE
    Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] and sqlitemanager from sqlabs.


    then i used sqlitemanager from sqlabs and got a similar error when trying to add a new record:

    no such function: read
    error code: 1


    i think the errors are causes by the triggers that involve deleting and inserting. has anybody tried merging two sms.db in this forum with success?

  4. #4
    What's Jailbreak?
    Join Date
    Aug 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Found this on another forum, by username: Piranha:

    "they put the triggers on the tables which use internal functions of sms framework.
    So if you try changing values by hand, outside of SMS app, those functions are not defined and they will fail."

  5. #5
    What's Jailbreak?
    Join Date
    Mar 2010
    Location
    Philadelphia
    Posts
    21
    Thanks
    3
    Thanked 2 Times in 2 Posts

    uggh, thanks though

    Quote Originally Posted by rudzz34 View Post
    Found this on another forum, by username: Piranha:

  6. #6
    What's Jailbreak?
    Join Date
    Sep 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    It's a little late, but the script on https://smsmerge.homedns.org is now updated for iOS3.x and 4.x sms.db files.

    Please try again.

    Regards
    Simon

  7. #7
    Green Apple
    Join Date
    Feb 2008
    Posts
    57
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Quote Originally Posted by Seomon View Post
    It's a little late, but the script on https://smsmerge.homedns.org is now updated for iOS3.x and 4.x sms.db files.

    Please try again.

    Regards
    Simon
    looking to do the same thing,, this isnt working for me. i was looking at the script and saw a time out set.. my one file is 8.6 MB the other is 2.4MB.. any chance the timeout is stopping this from working?

  8. #8
    What's Jailbreak?
    Join Date
    Jun 2009
    Posts
    16
    Thanks
    0
    Thanked 1 Time in 1 Post
    Same issue here.

    Gateway Time-out

    The gateway did not receive a timely response from the upstream server or application.

  9. #9
    What's Jailbreak?
    Join Date
    Sep 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by okitsugu View Post
    looking to do the same thing,, this isnt working for me. i was looking at the script and saw a time out set.. my one file is 8.6 MB the other is 2.4MB.. any chance the timeout is stopping this from working?
    It should work now with larger files. Please try again

  10. #10
    iPhone? More like MyPhone
    Join Date
    May 2008
    Posts
    124
    Thanks
    78
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by rudzz34 View Post
    Found this on another forum, by username: Piranha:
    Quote Originally Posted by Seomon View Post
    It's a little late, but the script on https://smsmerge.homedns.org is now updated for iOS3.x and 4.x sms.db files.

    Please try again.

    Regards
    Simon
    A nice tool to have next time.

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts