My-Symbian ~ My-Maemo ~ My-MeeGo

[maemo_meego]

I've deleted all the conversations for given mobile number by mistake. As I always keep my backups (created with Backupmenu) current I have managed to restore them.
Below I'm going to outline the procedure.

Warnings:
1. This is not detailed 'step by step' description for newbies. The procedure requires some working knowledge of linux/sql. If you don't understand typed commands don't take the risk.
2. Though it allows me to restore removed conversations I can't guarantee proper restoring in your case.


Short description:
Export selected data from backuped Events and Headers to CSV file and import (insert) them to live Events and Headers tables of N900.

Long description (I use +48602123456 as an example of mobile number):
On PC host (linux system):

Code:

1. Restore el-v1.db from backup // use command like 'tar xf 20101118-1019-optfs.tar  ./user/.rtcom-eventlogger' 2. Run 'sqlite3 el-v1.db'     sqlite> .separator #][#     // set separator to string that never appeared at SMS content     sqlite>.output Events_sms.txt     sqlite>select * from Events where (service_id=3 and event_type_id=7) and remote_uid like '%123456%';     sqlite>.output Headers_tokens.txt     sqlite>select * from Headers where event_id in (select id from Events where (service_id=3 and event_type_id=7) and remote_uid like '%123456%');

Transfer above two *.txt files to N900 (e.g using sftp)
On N900:

Code:

1. cd /home/user/.rtcom-eventlogger 2. Run 'sqlite3 el-v1.db'    sqlite>.separator #][#    sqlite>.import Events_sms.txt Events    sqlite>.import Headers_tokens.txt Headers

That's all.
rgrds

--
john

[lastninja]

nice tutorial!

[pvanbeek]

Thanks for that - if only I knew that when I had to restore mine - sounds much safer than the hack I ended up using:
http://my-symbian.com/forum/viewtopic.php?t=42422

[Tomfille]

Thanks for the tutorial, though i couldn't do without a professional help in this issue. Your tutorial was much of help.