IRedMail/FAQ/Delete.Quarantined.Mails.Manually
From iRedMail
(Difference between revisions)
| Line 10: | Line 10: | ||
</pre>}} | </pre>}} | ||
| + | Referrence: | ||
| + | * [[IRedMail/FAQ/Delete.Sent.Received.Mail.Log.Manually |How to delete log of Sent/Received mails manually]] | ||
[[Category: iRedMail/FAQ]] | [[Category: iRedMail/FAQ]] | ||
Current revision as of 08:05, 9 May 2011
Example to delete quarnatined mails which older than 7 days:
| Terminal: |
$ mysql -uroot -p
mysql> USE amavisd;
mysql> DELETE FROM msgs\
WHERE content IN ('S', 's', 'V', 'Y')\
AND quar_type IN ('Q', 'F')\
AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY));
|
Referrence:
