IRedMail/FAQ/Delete.Sent.Received.Mail.Log.Manually
From iRedMail
(Difference between revisions)
(Created page with 'Example to delete sent and received mail logs which older than 7 days: {{cmd|<pre> $ mysql -uroot -p mysql> USE amavisd; mysql> DELETE FROM msgs\ WHERE content IN …') |
|||
| Line 8: | Line 8: | ||
AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)); | AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY)); | ||
</pre>}} | </pre>}} | ||
| + | |||
| + | Reference: | ||
| + | * [[iRedMail/FAQ/Delete.Quarantined.Mails.Manually |How to delete quarantined mails manually]] | ||
| + | |||
| + | [[Category: iRedMail/FAQ]] | ||
Current revision as of 08:08, 9 May 2011
Example to delete sent and received mail logs which older than 7 days:
| Terminal: |
$ mysql -uroot -p
mysql> USE amavisd;
mysql> DELETE FROM msgs\
WHERE content IN ('U', 'M', 'H', 'O', 'C') \
AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY));
|
Reference:
