[horde] Horde Database help

[Michael J Rubinsky]

Quoting Andy Dorman <adorman at ironicdesign.com>:

> On 1/15/23 07:57, ANANT S ATHAVALE wrote:
>> Dear List,
>>
>> Due to some hardware issue, we had to move to a earlier setup  
>> server (Horde) which was active till 4 months before. Due to  
>> urgency, we just continued with the Horde data base which was  
>> existing on that server 4 months back.  With this, users were able  
>> to use the system.  Within 2 days, we could resolve the hardware  
>> issue on production server and again shifted back.
>>
>> In these 2 days, the earlier server would have updated Horde  
>> database.   Basically, we are interested in data where information  
>> like, a mail which was forwarded/redirected/replied etc information  
>> is stored which is generally visible when we open a mail and that  
>> information is displayed.  So, currently, we are missing that  
>> information for those 2 days mails on production server.
>>
>> We are using HGWE 5.2.22.
>>
>> We are using MariaDB.  Which are the tables which should be looking  
>> at for such information?
>>
>> Will it be possible to do restore only such records from old Horde  
>> Server Database (by dumping only such records) and importing in  
>> production server database?
>>
>> If yes, please suggest, how to import such records alone from old  
>> server Horde database to production server.
>>
>> At least some guidance /idea (steps).
>>
>> Thanks in advance.
>>
>
> Hi Avant. Our system uses postgresql as a database, but I don't  
> believe the mail data like you describe above is stored there. I  
> could be wrong, but I think that information is present in your mail  
> IMAP storage, ie. in our system we use Cyrus.
>
> I believe the databases like MariaDB and Postgresql store the  
> account and contact list information. The email metadata is part of  
> the mail IMAP system like Cyrus or Dovecot.


This is true for the actual email data, and possibly some metadata,  
but most likely the information regarding the forward, reply, redirect  
etc... history, THAT data is stored in the Horde_History tables. See  
imp/lib/Maillog for more information.


> Hope this helps.
>
> -- 
> Andy Dorman
> Ironic Design, Inc.
> AnteSpam.com
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9386 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20230115/261d731e/attachment-0001.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 851 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20230115/261d731e/attachment-0001.sig>