Dumping Messages From PalmDatabase - Revision history

En0x: Replacing page with '{{template:patch}} idk what I was doing wrong but with every modification to PalmDatabase.db3 the database got corrupted and it had to recreate new one...'

2009-11-05T19:54:40Z

Replacing page with '{{template:patch}} idk what I was doing wrong but with every modification to PalmDatabase.db3 the database got corrupted and it had to recreate new one...'

En0x at 13:21, 3 October 2009

2009-10-03T13:21:53Z

En0x at 19:59, 2 October 2009

2009-10-02T19:59:10Z

En0x at 19:45, 2 October 2009

2009-10-02T19:45:18Z

En0x: added few things

2009-10-02T19:34:08Z

added few things

En0x at 19:32, 2 October 2009

2009-10-02T19:32:55Z

En0x at 19:32, 2 October 2009

2009-10-02T19:32:18Z

En0x at 19:30, 2 October 2009

2009-10-02T19:30:11Z

En0x: this is a first version and very raw with spelling errors etc of how to dump messages to sql file

2009-10-02T19:29:59Z

this is a first version and very raw with spelling errors etc of how to dump messages to sql file

New page

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

← Older revision		Revision as of 19:54, 5 November 2009
Line 1:		Line 1:
	{{template:patch}}		{{template:patch}}

−	~~ok so i took a look at the PalmDatabase.db3 and it looks like we need to dump 3 tables~~	+	idk what I was doing wrong but with every modification to PalmDatabase.db3 the database got corrupted and it had to recreate new one...
−
−	~~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~~
−
−	~~WELL IT LOOKS LIKE com_palm_pim_Message is not the right thing. This a view in sqlite database... I have search for a table that keeps all the info..~~
−
−	~~back to search~~
−
−	~~to dump the messages to file:~~
−	~~<pre><nowiki>echo ".mode insert" > cookies; sqlite3 -init cookies /var/luna/data/dbdata/PalmDatabase.db3 'select * from com_palm_pim_Message' >/tmp/messages.sql;rm cookie</nowiki></pre>~~
−
−	~~to insert it to our database:~~
−	~~<pre><nowiki> cat /tmp/messages.sql\| sqlite3 /var/luna/data/dbdata/PalmDatabase.db3</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~~
−
−	~~-- according to sqlite com_palm_pim_Message is a view need to research about it~~... ~~i'm not so good in sqlite~~
−
−	~~--[[User:En0x\|en0x]] 19:32, 2 October 2009 (UTC)~~

← Older revision		Revision as of 13:21, 3 October 2009
Line 1:		Line 1:
	{{template:patch}}		{{template:patch}}
		+
		+	ok so i took a look at the PalmDatabase.db3 and it looks like we need to dump 3 tables

	ok this is a very raw version of stuff		ok this is a very raw version of stuff

← Older revision		Revision as of 19:59, 2 October 2009
Line 6:		Line 6:

	here is one simple way to do it		here is one simple way to do it
		+
		+	WELL IT LOOKS LIKE com_palm_pim_Message is not the right thing. This a view in sqlite database... I have search for a table that keeps all the info..
		+
		+	back to search

	to dump the messages to file:		to dump the messages to file:

@@ Line 7: / Line 7: @@
 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>
+to dump the messages to file:
 the question now is how to import it to freshly created database....

← Older revision		Revision as of 19:32, 2 October 2009
Line 25:		Line 25:
	I hate losing my messages		I hate losing my messages

−	--[[User:En0x\|en0x]] 19:32, 2 October 2009 (UTC)~~-- en0x~~	+	--[[User:En0x\|en0x]] 19:32, 2 October 2009 (UTC)

@@ Line 26: / Line 26: @@
 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)

← Older revision		Revision as of 19:30, 2 October 2009
Line 22:		Line 22:

	I hate losing my messages		I hate losing my messages
		+
		+	-- en0x