Updating retained date after pilerimport

[Brian Harrington]

I have imported our existing archives using the pilerimport utility. The retained date seems to be set base on the import time and not the sent date. Is there a script to update the retained date to be sent date + 7552 days?

Thanks!

[Janos SUTO]

Well, no such script, though the mission is not completely impossible. A proper update statement may help you, eg.

update metadata set retained=sent+652492800;

However you want to preserve the emails for ~20 years (=7552 days). I suggest to not enable the purge feature at all, and thus no message will be purged ever. Note that before running the sql query, be sure to backup the metadata table.

[Brian Harrington]

thanks. It was a typo, I meant 2557. I will get that update done.