I know that on the N900 conversations are stored in ~/.rtcom-eventlogger/el.db but I'm wondering how to export and import via the SQLite shell.
(Asking because a friend of mine accidentially deleted her Conversations thread with me and would like to have it back.)
After the initial Events table dump, there are a few problems that can be solved by an awk script. First off, you'll have to generate unique integers that won't conflict with her primary key 'id' field. Secondly, all the 'local' and 'remote' values need to be swapped.
On your n900:
sqlite3 ~/.rtcom-eventlogger/el-v1.db
.mode insert
.output ~/.rtcom-eventlogger/friend.txt
select * from Events where remote_uid == '<friend remote_uid>';
<ctrl-d>
sed -i 's/ table / "Events" /' ~/.rtcom-eventlogger/friend.txt
