General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] restore addresses


Chronological Thread 
  • From: Christian Mack < >
  • To:
  • Subject: Re: [SOGo] restore addresses
  • Date: Tue, 09 Dec 2014 13:38:49 +0100

Hello Rudolf Harney

Am 2014-12-01 um 17:55 schrieb Rudolf Harney:
>
> we run sogo 2.2.9 on a ubuntu server with a postgreSQL database. By a
> mistake (what else?) about half of the addresses were removed.
>
> We don't have backups (we will though, in future).
>
> I saw, the addresses still are in the "data" table, with c_deleted=1. Is
> there a way to restore them? I tried simply setting c_deleted=0 but that
> didn't help - I guess, I would also have to change the _quick tables ...
> I didn't find a documentation of the db scheme in the net.
>
> I know that c_lastmodified=1417427410 and c_lastmodified=1417427411 has
> all addresses I need.
>
> Any suggestions, how I can retrieve the data?
>

I only know of this old thread, which was about calendars, but I assume
this will work for address books too.
https://lists.inverse.ca/sogo/arc/users/2012-09/msg00109.html


Kind regards,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page