Copy sms from N900 to PC

Open xterm (you don't need root) and enter the following command (note: case matters. a <> A in linux)

Code :
~ $ sqlite3 .rtcom-eventlogger/el.db "select * from events where event_type_id in (7,8) order by id;" > /home/user/MyDocs/sms_dump.txt


This will create sms_dump.txt which will contain all of your inbound (type 7) and outbound (type 8) SMS records in chronological order. You can also export the other types contained in the table, just add them to the sqlite3 command above in the brackets separated by comas.

Here is the list of the types:

1 = inbound call
2 = outbound call
3 = missed call
4 = voicemail message
5 = inbound IM (integrated conversations only)
6 = outbound IM (integrated conversations only)
7 = inbound SMS
8 = outbound SMS