-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tomasz Chmielewski said the following on 22/04/09 15:57: > When using MySQL as a quarantine method, what query should I use to > remove all messages and any entries associated with them older than, > say, 6 months (with "$timestamp_fmt_mysql = 1;" setting)?
Dunno if it is what you are looking for, but in http://www.ijs.si/software/amavisd/README.sql-mysql.txt there is an example after "BRIEF EXAMPLE of a log/report/quarantine database housekeeping" paragraph title. Ciao, luigi - -- / +--[Luigi Rosa]-- \ Real Programmers write self-modifying code, especially if they can save 20 nanoseconds in the middle of a tight loop. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknvJfYACgkQ3kWu7Tfl6ZRc1gCePxJbxCfifqjo4nZYq04uqJM9 XMAAn3sSkie/BB/Dqrgk3qDPtq0V1vaO =GVwo -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
