Import selected SMS from a backup [answered]

Question

2

Import selected SMS from a backup [answered]

asked 2015-07-05 00:15:29 +0300

nomeata
1175 ●41 ●53 ●57

I accidentially deleted all SMS of one contact. So I went to a backup of two days earlier, opened /home/nemo/.local/share/commhistory/commhistory.db in sqlite3 and extracted the relevant rows:

.mode insert Events
.output foo.sql
select * from Events where type = 2 and remoteUid LIKE '%12345';

I copied the resulting foo.sql to my Jolla and imported it with

sqlite3 /home/nemo/.local/share/commhistory/commhistory.db < foo.sql

and the new rows are definitely there and were not there before.

However, they are not shown in the messaging app. Do I need to copy more, or update some kind of index?

edit retag flag offensive reopen delete

The question has been closed for the following reason "the question is answered, an answer was accepted" by raketti
close date 2015-07-05 01:01:41.760847

Comments

1

Is it possible to restore them from the commhistory-tool_groups.dump?

I did a backup and a reset of the phone. After the update marathon i wanted to restore the backup, but Sailfish couldn't find it. . The backup is called sailfish_backup_2017-01-05T11-35-18Z.tar and Contains

Accounts
Browser
Calendar
Gallery
Media
Message
Notes
People
Phone

I find in it the commhistory-tool_groups.dump Can I some how restore the SMS communication?

Linus Kasch ( 2017-01-05 23:09:18 +0300 )edit

Is it possible to restore them from the commhistory-tool_groups.dump?
I did a backup and a reset of the phone. After the update marathon i wanted to restore the backup, but Sailfish couldn't find it. . The backup is called sailfish_backup_2017-01-05T11-35-18Z.tar and Contains
Accounts Browser Calendar Gallery Media Message Notes People Phone
I find in it the commhistory-tool_groups.dump Can I some how restore the SMS communication?
Linus Kasch ( 2017-01-05 23:09:18 +0300 )edit

Accepted Answer

1

answered 2015-07-05 00:19:50 +0300

nomeata
1175 ●41 ●53 ●57

I found the problem. The Events table references the Group table using the groupId column. Because I deleted all SMS of that contact it got assigned a new group later.

I was able to fix it by issuing

update Events set groupId = 116  where type = 2 and remoteUid LIKE '%12345';

on my Jolla. Now all SMS are back.

edit flag offensive delete publish link

Import selected SMS from a backup [answered]

The question has been closed for the following reason "the question is answered, an answer was accepted" by raketti
close date 2015-07-05 01:01:41.760847

Comments

1 Answer

Question tools

Stats

Related questions

Import selected SMS from a backup [answered]

The question has been closed for the following reason "the question is answered, an answer was accepted" by raketti close date 2015-07-05 01:01:41.760847

Comments

1 Answer

Question tools

Public thread

Stats

Related questions

The question has been closed for the following reason "the question is answered, an answer was accepted" by raketti
close date 2015-07-05 01:01:41.760847