SYMBIAN OS SECTION
  -My-Symbian.com-
MAEMO  SECTION
-My-Maemo-
MEEGO  SECTION
-My-MeeGo-
SOFTWARE STORECONTACT


My-Symbian.com Forums

 
My-Symbian ~ My-Maemo ~ My-MeeGo
Symbian & Linux based Communicator and Smartphone Info Center
The Oldest Symbian Community Website - Since 1999
 
 Watched TopicsWatched Topics   FAQFAQ   SearchSearch   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   RulesRules   Log inLog in 
Lightweight, simplified version of the forumsMobile version
[Backupmenu] How to Restore Deleted SMS Conversation Thread

 
Post new topic   Reply to topic    My-Symbian ~ My-Maemo ~ My-MeeGo Forum Index -> Maemo 5 Fremantle
View previous topic :: View next topic  
Author Message
maemo_meego
Forum Newbie
Forum Newbie

Please add your avatar!

Joined: 25 Feb 2010

Posts: 4

Thanks received:
2 in 1 posts
Thanks given: 0


Phone: E90, N900

PostPosted: Friday, 26.Nov.2010 01:19    Post subject: [Backupmenu] How to Restore Deleted SMS Conversation Thread   Reply with quote   

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
Back to top

The following users say THANKS! for this post: Tomfille, Anagarika

lastninja
Site supporter
Site supporter



Joined: 13 Mar 2006

Posts: 204

Thanks received:
3 in 3 posts
Thanks given: 0

Location: Sweden
Phone: Motorola A920 / Motorola A925 / Nokia N900

PostPosted: Friday, 26.Nov.2010 01:28    Post subject:   Reply with quote   

nice tutorial! Smile
Back to top
pvanbeek
Site supporter
Site supporter

Please add your avatar!

Joined: 21 Mar 2007

Posts: 200

Thanks received:
2 in 2 posts
Thanks given: 77


Phone: N9 N900 formerly P990i, P800 6600

PostPosted: Friday, 26.Nov.2010 11:00    Post subject:   Reply with quote   

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
Back to top
Tomfille
My first post!
My first post!

Please add your avatar!

Joined: 20 Oct 2011

Posts: 1

Thanks received:
0 in 0 posts
Thanks given: 1


Phone: Sony Ericsson Symbian S60, Nokia N900

PostPosted: Thursday, 20.Oct.2011 14:01    Post subject:   Reply with quote   

Thanks for the tutorial, though i couldn't do without a professional help in this issue. Your tutorial was much of help.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    My-Symbian ~ My-Maemo ~ My-MeeGo Forum Index -> Maemo 5 Fremantle All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
View previous topic :: View next topic

Similar Topics on this forum
Topic Author Forum Replies Posted
No new posts Copying SMS messages from SIM card Michal Jerz Maemo 5 Fremantle 5 Sunday, 13.Mar.2011 19:07 View latest post
No new posts Cellular Data Not Available / No SMS / No Signal - NOTHING! Fiery Phoenix Maemo 5 Fremantle 14 Wednesday, 26.Jan.2011 15:20 View latest post
No new posts No conversation or call history since pr1.3 pfloyd9 Maemo 5 Fremantle 5 Saturday, 04.Dec.2010 04:55 View latest post
No new posts Backups from old backupmenu may not restore on different dev pvanbeek Maemo 5 Fremantle 1 Saturday, 06.Nov.2010 12:03 View latest post
No new posts N900 firmware thread dannycamps Maemo 5 Fremantle 63 Monday, 25.Oct.2010 17:30 View latest post
No new posts no contacts to send sms problem cokeman2 Maemo 5 Fremantle 1 Wednesday, 04.Aug.2010 04:16 View latest post
No new posts sms to multiple recipients cokeman2 Maemo 5 Fremantle 5 Thursday, 29.Jul.2010 08:53 View latest post
No new posts BackupMenu - finally a proper backup/restore tool for N900 Michal Jerz Maemo 5 Fremantle 0 Friday, 23.Jul.2010 03:52 View latest post
No new posts N900 firmware thread (Old) ahiles Maemo 5 Fremantle 77 Tuesday, 25.May.2010 09:03 View latest post
No new posts N900 firmware thread (Old) ceroberts75 Maemo 5 Fremantle 69 Tuesday, 16.Feb.2010 10:58 View latest post

Posting/discussing/exchanging warez/cracks/serial numbers/links to web sites offering such resources and/or any other illegal content
is FORBIDDEN on this forum and results in an immediate BAN.


Symbian and all Symbian-based marks and logos are trade marks of Symbian Software Limited.
This website is not in any way endorsed or supported by Symbian Software Limited.    (C) 2001 My-Symbian.com All Rights Reserved