I really need help in transfering/copying the text messages from my N900 to PC.
I already tried the code in Xterm:
Open xterm (you don't need root) and enter the following command (note: case matters. a <> A in linux)
~ $ 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.
but it only shows a little part of my text messages (and those are the ones I already deleted about 2 years ago. Is there any way I can copy the recent sms (or recover the sms I just deleted a few months ago) to PC? Please help! This is very important to me. And I'm not familiar with this technical issue, so please give me something with step-by-step LOLz =] Thanks a lot!