Difference between revisions of "Dumping Messages From PalmDatabase"

From WebOS Internals
Jump to navigation Jump to search
Line 1: Line 1:
 +
{{template:patch}}
 +
 
ok this is a very raw version of stuff
 
ok this is a very raw version of stuff
  
Line 5: Line 7:
 
here is one simple way to do it
 
here is one simple way to do it
  
echo ".mode insert" > cookies; sqlite3 -init cookies /var/luna/data/dbdata/PalmDatabase.db3 'select * from com_palm_pim_Message' >messages.sql;rm cookie
+
<pre><nowiki>echo ".mode insert" > cookies; sqlite3 -init cookies /var/luna/data/dbdata/PalmDatabase.db3 'select * from com_palm_pim_Message' >messages.sql;rm cookie</nowiki></pre>
  
 
the question now is how to import it to freshly created database....
 
the question now is how to import it to freshly created database....
Line 23: Line 25:
 
I hate losing my messages
 
I hate losing my messages
  
-- en0x
+
--[[User:En0x|en0x]] 19:32, 2 October 2009 (UTC)-- en0x

Revision as of 19:32, 2 October 2009


ok this is a very raw version of stuff

So we want to dump all our messages from PalmDatabase.db3

here is one simple way to do it

echo ".mode insert" > cookies; sqlite3 -init cookies /var/luna/data/dbdata/PalmDatabase.db3 'select * from com_palm_pim_Message' >messages.sql;rm cookie

the question now is how to import it to freshly created database....


anyway what I was trying to do is to:


remove my database on pre... does palm has a script to create the new database?! (PalmDatabase.db3)??????? if yes then run the script... and try to import my messages to check if everything is working fine....


if everything is working fine we should be able to write a simple script to do that automatically for us... and it also could send the whole messages.sql to our email so we will have it for future reference and also we will be able to use the file to insert the messages to our new PalmDatabse.db3 file after webos doctor.

I hate losing my messages

--en0x 19:32, 2 October 2009 (UTC)-- en0x