See dbmail-export man page. You want -D and -s with an imap search matching your subject. See the Exmaples section, and if you need help with the search string, either run it in your imap client and see what it uses, or ask back on the list. And you might use -u to restrict your tests to a specific user until you have it "right".
On Wed, 2009-07-22 at 23:01 -0700, Piotr Wadas wrote: > Hello, > > When administrator migrates mbox folders to dbmail, in some of them > is a imap message, common pop3/imap ignores it, but when migrated, > this message appears on the list, and frightened users call support, to > ask "what is this and what shall I do with this". And yes, this is no joke. > Any quick sql query to delete from database all messages for all users > (envelopes and bodies) with particular SUBJECT header? or for particular > user? I'd rather to delete the messages, than delete envelope and let > dbmail-util do the rest (it has enough to do with really deleted messages). > Probably Net::POP3 perl script would do the same, but removing from > tables would be much simplier. > > Regards, > DT -- Jesse Norell Kentec Communications, Inc. [email protected] _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
