Thread: Variours Issues with my N900 - Need advice
View Single Post
9000 is offline 9000
2010-07-30 , 09:13
Posts: 1,425 | Thanked: 983 times | Joined on May 2010 @ Hong Kong
#3
Actually your SMS is in the database el*.db under /home/user/.rtcom-eventlogger/

I'm not sure if copying it back could restore all your SMS. I haven't tried.

However, you could export it in HTML.

Code:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT start_time,service_id,event_type_id,free_text, remote_uid FROM Events ORDER BY start_time DESC;” > output.html
In my case I need to replace el.db with el-v1.db as my el.db is empty, i.e.

Code:
sqlite3 -html /home/user/.rtcom-eventlogger/el-v1.db "SELECT start_time,service_id,event_type_id,free_text, remote_uid FROM Events ORDER BY start_time DESC;" > output.html
My apology this isn't much help. I hope someone else could give you a better solution.

EDIT: Oops I just found out that the <TABLE></TABLE> was missing from the output html such that you might have problem opening it with a normal browser. You can add them back though.
Last edited by 9000; 2010-07-30 at 09:20.
 

The Following 3 Users Say Thank You to 9000 For This Useful Post: