Gee, and I was just working on extracting the relevant queries from the 2.1 code so that I might just do that very thing. :)
I'm looking at a php script right now to do this right now. So since it's in your head I'll try some extraction. 1) When you mention the "date" I assume you are using the Date field from the header? 2) The SQL statement: select is_header,messageblk from dbmail_messageblks b join dbmail_messages m using (physmessage_id) where message_idnr in (xxxxxxx); Seems to be valid in the older 2.0 train. Can you see any reason why that might not work? 3) I believe the mbox format only requires: From: <[EMAIL PROTECTED]> <insert complete header here> <insert message body here> <explicit \r\n empty line> From: <[EMAIL PROTECTED]> etc... Doing that output looks pretty easy, so the last question is how would I import that back in should I have to restore a user? 4) I'm guessing it would be simpler to export the data as SQL for a direct insert, but I expect the problem is that if the user_idnr changes your are pretty well screwed. Plus the mbox format is probably as small as it gets on the export correct? Thanks. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: Tuesday, May 16, 2006 3:59 PM To: DBMail mailinglist Subject: Re: [Dbmail] Backup and Restore Niblett, David A wrote: > What a very cool app, question is where do I find said application? dbmail-export is in 2.1, but only the feature marked as 'current' is real. The rest is in my head only, but quite straightforward to do. Just add command switches to tweak the queries used to dump (parts of) (lists of) mailboxes. > > I'm running 2.0.10, is it available in the 2.0 version? Ahem, no. And it wont be unless someone does something in python/perl whatever. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
