Difference between revisions of "Dumping Messages From PalmDatabase"

Latest revision as of 20:54, 5 November 2009

<<- Return to webOS Patches

idk what I was doing wrong but with every modification to PalmDatabase.db3 the database got corrupted and it had to recreate new one...

@@ Line 1: / Line 1: @@
 {{template:patch}}
-ok this is a very raw version of stuff
+idk what I was doing wrong but with every modification to PalmDatabase.db3 the database got corrupted and it had to recreate new one...
-So we want to dump all our messages from PalmDatabase.db3
-here is one simple way to do it
-<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....
-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
---[[User:En0x|en0x]] 19:32, 2 October 2009 (UTC)