Sync Zimbra Database with physical /mailstore possible?

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Post Reply
mzietlow
Posts: 6
Joined: Fri Jun 07, 2019 11:51 pm

Sync Zimbra Database with physical /mailstore possible?

Post by mzietlow »

Question,

My /opt/zimbra folder got fubar'd and I had to restore from backup 24h earlier...

Now the ZImbra database is showing me mail from 24h ago but I have physical msg files in my /mailstore/store/0 from today...

Is there some way to SYNC all these msg files back into the Zimbra database or am I just hosed?

Thanks!
Z
mzietlow
Posts: 6
Joined: Fri Jun 07, 2019 11:51 pm

Re: Sync Zimbra Database with physical /mailstore possible?

Post by mzietlow »

Since our deployment is rather small we ended up executing a find mtime command to determine which msg files were orphaned from the database and then script a zmmailbox loop to import the missing messages. zmmailbox is great for scripting single mass mailers but it's a HUGE PITA when were talking 1000+ of emails.... But it worked..

In hindsight we realize now it a mistake to restore the /opt/zimbra from backup but I would still like to know if there is some tool that can sync or rebuild physical mailstore to the logical datastore somehow...
User avatar
axslingr
Outstanding Member
Outstanding Member
Posts: 256
Joined: Sat Sep 13, 2014 2:20 am
ZCS/ZD Version: 8.8.15.GA.3869.UBUNTU18.64 UBUNTU18

Re: Sync Zimbra Database with physical /mailstore possible?

Post by axslingr »

How are you backing up /opt/zimbra?

Lance
Post Reply