How To: Back Up Text Messages When Exchanging Phones - Page 3

atlanta · 10/02/2009, 07:49 AM

Quote:

Originally Posted by drewp

Ugggh, This database stuff is difficult. I am not experienced in running/writing sql queries.

The recordset com_palm_pim_Contact has the names of all my contacts...

However the corresponding phone numbers and email addresses for each contact are located in the recordset com_palm_pim_ContactPoint

(A similar situation exists for TextMsgs, and CallLogs [superlog])

1) How would I form a query that would display a result view that had both name, number, and email [if present], from both these recordsets? Keep in mind that contacts may have more than one phone number/email. My plan here would be to import into Outlook and sync with Google.

2) Would I need to form a query that included ALL of the fields in each recordset if my plan was to import them into the DB of a new or WebOSDoctored [wiped] phone? Making sure all fields were populated in the new DB if they were in the old DB.

Help?!

Hey go to my previous post it has sql commands on backing up text messages and look at how i joined the sms tables, it will give you a clue of how to combine the contacts and numbers. Just specify the table and fields you want from both and have it combine on to common fields

irateb · 10/02/2009, 11:56 AM

Quote:

Originally Posted by drewp

I found the bookmark database here....

Code:

/var/palm/data/file_.usr.palm.applications.com.palm.app.browser_0

My filename was: 0000000000000004.db

Is that what it's called for everyone else?

This DB File also contains all the browser history.

Also, it looks like the browser cookie info is located here

/var/palm/data/browswer-cookies.db

Restoring this means you won't have to re-login to PreCentral.net

I found this a bit too late or I would have tried to restore using these and see if my bookmarks history & cookies were restored successfuly or not.

Maybe someone else is a bit more brave. Maybe I'll try it over the next couple of days..

According to the 1.2 Improvements/Enhancements thread, bookmarks are now backed up, so maybe we don't have to worry about it? That being said, my filenames for the bookmarks and cookies are the same as yours...

wwjd4pk · 10/02/2009, 11:59 AM

Awesome info thanks!

en0x · 10/02/2009, 12:50 PM

well what i was thinking was that the best possible way to dump all the text messages to a file...

use sqlite to dump the database content to a text file... copy the text file to new device and use sqlite to put it back to new database.... gotta play with it

hckyplayer024 · 10/02/2009, 12:50 PM

So I did this and while I do have all my texts and call logs backed up now, all my text messages have an empty box where the avatar is supposed to be. Is there a command or a way I can have the messenger app rescan my contacts for their avatar and then put it in the messaging application? Help is greatly appreciated

DrewPre · 10/02/2009, 10:18 PM

Quote:

Originally Posted by hckyplayer024

So I did this and while I do have all my texts and call logs backed up now, all my text messages have an empty box where the avatar is supposed to be. Is there a command or a way I can have the messenger app rescan my contacts for their avatar and then put it in the messaging application? Help is greatly appreciated

This is exactly the problem I was having when I made this comment.....

Quote:

Originally Posted by drewp

this does not appear to be working.....well...not totally.

The avatars that were missing were ones from my gmail contacts. I was also having problems with gTalk and I mentioned that also. I managed to clear it up by deleting the problematic contacts and recreating them in gmail on my PC and then resyncing them on the Pre.

There was so much going on there it was hard to remember exactly what I did. My ego tells me I don't need to take notes ..... I am about as sharp as a peice of chalk.

DrewPre · 10/04/2009, 12:01 AM

**SIGH**

Apparently I am not done yet.

I went to do a manual backup using the 'backup' app and the Pre logged me off telling me that I need to reboot. Of course when I did I booted up to the screen below. Asking me to wipe the drive or start over...starting over just reboots it to that screen all over again.

Of course, I was still able to root into the Pre and when I did a ps -A -F I noticed all the apps where still running. Hmmmmm, I also noticed that LunaSysMgr was running with some weird parameters. LunaSysMgr -u mininmal -a fisrtuse

Naturally, I issued a stop LunaSysMgr && start LunaSysMgr -u luna

This restarted Luna in normal mode and i recoverd use of my Pre. Temporarily! After rebooting it went back to the screen below.

Looks like the culprits are the files located in /var/luna/data/Apps/br/config. They do not refer to the Browser application. They refer to the Backup and Restore Application.

An inspection of the file /var/luna/data/Apps/br/config/application.properties & BRSyncSource.properties reveal what should be backed up and how often as well as where it is being backed up....

application.properties

Code:

#Thu Sep 11 16:50:16 GMT+02:00 2003
applicationAuthor=Funambol
applicationDisplayName=Funambol Java Command Line Plug-In
applicationSupportMail=funambol-users@lists.sourceforge.net
applicationSupportUrl=http\://www.funambol.com

BRSyncSource.properties

Code:

# Thursday September 20, 2007 - Initial version
# Sunday, February 17, 2008 - Revised for multiple backup folders
# 

#
# The user folder for backup and restore
# To backup multiple folder to the list, just append path
# seperated by TWO "|" chars
# Example: userdata-folder=folder1||folder2||folder3
# Note for subfolder characters use standard unix approach
# of forward slash in place of back slash.
#
userdata-folder=/var/luna/files

#
# It basically mean that perform backup of only files
# or only active records. the comparison is case sensitive.
# selective backup [All / Files / ARs]
# default: All
#
#selective-backup=All

#
# The timeslice in minutes for the automatic
# backup to trigger. If this property is missing or
# set to zero the time to next backup is obtained from
# the server. Further, if the server fails to provide
# the next backup time due to connectivity failure
# or otherwise the default is set to 24 hours
# from the current backup time.
#auto-backup-interval=1440
auto-backup-interval=0

The backup application in the AppLauncher said that my last successful backup was 9/30/2009. So Looking at the time stamps, I guess anything dated after 9/30/2009 would be okay to restore...all other files in the location /var/luna/data/Apps/br/config should be excluded.

Specifically the files

Code:

/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW.bin
/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW_guids.bin
/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW_luids.bin
/var/luna/data/Apps/br/config/spds/syncml.properties [maybe]

I'll be updating the exclude list later..... Standby to Standby.

DrewPre · 10/04/2009, 12:06 AM

The question now becomes .... if I change

Code:

userdata-folder=/var/luna/files

...to...

Code:

userdata-folder= /

will the backup app backup my entire Palm Pre???

LMAO

sirfred999 · 10/04/2009, 03:07 AM

cool post

DrewPre · 10/04/2009, 08:59 AM

Code:

/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW.bin
/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW_guids.bin
/var/luna/data/Apps/br/config/spds/lastsyncstate_PALMBRW_luids.bin
/var/luna/data/CarrierNetworkSettings.db3
/var/luna/data/dbdata/PalmAccountDatabase.db3

Okay so this is the revised 'exclude' list from /var/luna

I also included a restoration of the files

Code:

/var/palm/browser-cookies.db
/var/palm/file_.usr.palm.applications.com.palm.app.browser_0/0000000000000004.db

All in All I retained, call logs, txt msg convos, browser history, bookmarks and cookies. The Backup app now also works and currently says that my last successful backup was at 8:30am on 10.04.09

This was all done on webOS 1.2. Will update to 1.2.1 and see how it goes.

bdhu2001 · 10/04/2009, 09:03 AM

The easiest way is to get your text through your GVoice number. Your text are always there and when you click history, in the GVoice app on your phone, they come back up.

DrewPre · 10/04/2009, 09:09 AM

do you have spare invites?

I've submitted my email address and they haven't given me an account yet.

May I have an gVoice invite from you, please?

bdhu2001 · 10/04/2009, 09:13 AM

Quote:

Originally Posted by drewp

do you have spare invites?

I've submitted my email address and they haven't given me an account yet.

May I have an gVoice invite from you, please?

Resubmit. I put them in for my husband and kids and everyone got their invites. Yours may have gone to your trash or junk mail by mistake. They don't give us the ability to invite, but I'll see if someone failed to use theirs.

DrewPre · 10/04/2009, 09:22 AM

Maybe you have the magic touch, can you put mine in for me as well!?!

DrewPre · 10/04/2009, 09:42 AM

Okay, updated to 1.2.1 and performed a backup via the backup app successfully. 9:41a 10.04.09

DrewPre · 10/05/2009, 03:58 AM

PalmDatabase.db3 File - WebOS Internals

I am such a glutence for punishment!!!!

bdhu2001 · 10/05/2009, 05:42 AM

Quote:

Originally Posted by drewp

PalmDatabase.db3 File - WebOS Internals

I am such a glutence for punishment!!!!

Why not just copy the files to your desktop through QuickInstall as a text? Try finding and doing the files that way, before you try the backup.

DrewPre · 10/05/2009, 05:49 AM

Dood, have you read this thread?

1.) copying the files to your PC does not get your contacts out of your Palm Profile and into your Google Gmail contacts and subsequently into Outlook. Yes, there are apps out there that already do this but ...
a.) I am too cheap a ******* to pay for them.
b.) I am never going to pay for something that I can do myself [excluding sex]
c.) I am never going to walk away from a learning experience.

2.) QuickInstall will not read DB3 files as text! I don't think you understand what WebOS QI does or either what these SQLite DB3 files are.

3.) This thread has been completely about how to preserve your call logs, chat conversations, browser bookmarks and history. What I have suggested and have successfully completed is migrating my palm profile to google.

bdhu2001 · 10/05/2009, 06:02 AM

Originally posted by drewp:

Quote:

What I have suggested and have successfully completed is migrating my palm profile to google.

I stand corrected. I thought someone simply wanted to backup their text and for me the best way is GVoice. For those of you who are more adventurous, I take off my hat to you. You develop, test, and pass on that knowledge to the rest of us.

satchmo82 · 10/07/2009, 02:24 PM

I don't know if anyone else has done this, but I took my PalmDatabase.db3 file and was able to load it into the Palm Emulator. I do see my text messages on there. I haven't tested much else tho.