ZhangHuangbin at 08:08, 9 May 2011

ZhangHuangbin — Mon, 09 May 2011 08:08:13 GMT

← Older revision		Revision as of 08:08, 9 May 2011
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]]

ZhangHuangbin: Created page with 'Example to delete sent and received mail logs which older than 7 days: {{cmd|

 $ mysql -uroot -p mysql> USE amavisd; mysql> DELETE FROM msgs\               WHERE content IN …'

ZhangHuangbin — Mon, 09 May 2011 08:07:36 GMT

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 …'

New page

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 ('U', 'M', 'H', 'O', 'C') \
AND time_num < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 7 DAY));
</pre>}}

IRedMail/FAQ/Delete.Sent.Received.Mail.Log.Manually - Revision history

ZhangHuangbin at 08:08, 9 May 2011

ZhangHuangbin: Created page with 'Example to delete sent and received mail logs which older than 7 days: {{cmd|
$ mysql -uroot -p mysql> USE amavisd; mysql> DELETE FROM msgs\ WHERE content IN …'