So I found myself creating a lot of notes using my Palm Pre and it’s ‘Memos’ program. The only problem with this is that I needed to export my notes and there is currently NO WAY to do this! ARG!!!!!

What I ended up doing is the following. *using my Mac Mini and the terminal application

1) Connect to palm pre using terminal and running novaterm


root@castle:/#


2) Copy the following database to an area of the device that you have USB read/write access


cp /var/luna/data/dbdata/PalmDatabase.db3 /media/internal


3) Drag and Drop the database to someplace on your local filesystem

4) Using the terminal application, ‘cd’ to the directory where the .db3 file is located

5) Open sqlite database


mymacmini:/# sqlite3 PalmDatabase.db3


6) Set output to file


sqlite> .output palmPreNote.txt


7) Run following sql statement


sqlite> select text from com_palm_pim_Memo;