Paul J Stevens wrote: > Larry Rosenman wrote: >> Greetings, >> I've been following DBMail for a LONG time. I finally think it >> is at the point where I can replace my UW-IMAP server with the >> DBMail software. One question I have is how can I accomplish what I >> do with UW-IMAP as far as making monthly archives of my mailfolders >> at the beginning of each month. >> >> The file structure I use is: >> ~/Mail >> | >> /lists >> | >> various directories for different projects etc. >> >> At the end of the month, I take the INBOX file from ~, move it to >> ~/Mail/INBOX-mm where mm is the month number, and then move the >> entire structure to ~/MAIL-ARCHIVE/yyyy/mm > > SQL is your friend. > > On sqlite and postgres you can do: > > update dbmail_mailboxes set name="MAIL-ARCHIVE/yyyy/mm" > where mailbox_idnr = ( > select mailbox_idnr from dbmail_mailboxes b > join dbmail_users u on b.owner_idnr=u.user_idnr > where u.userid='testuser1' and b.name='INBOX' > ); > > mysql doesn't allow this type of sub-select, so you need to do a > two-step: first retrieve the mailbox_idnr using the select, then > update the record involved.
I want to basically make the whole hierarchy under the MAIL-ARCHIVE/yyyy/mm, I.E. MAIL-ARCHIVE/2006/11/lists/pgsql/hackers >From when it was ~/Mail/lists/pgsql/hackers (and, yes, this would be on PostgreSQL). Can we do that? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [email protected] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
