Mailing List Archive: Moving a large amount of mail to a different account

Moving a large amount of mail to a different account

Jul 14, 2017, 4:17 AM

Post #1 of 4 (1184 views)

hi.

I am considering moving a large amount of older emails to a seperate
account (for Archiving reasons).
Is there an easy way (maybe in the DB directly) to do this instead of
using an imap client (or maybe writing something simple in python )

Also I'd want to maybe merge some folders (probably ignoring duplicates
for the moment

-- the reason I want to do this is because that account is hardly
useable anymore with (especially) webmail clients, because it has > 3500
IMAP folders

Regards,
Thomas Raschbacher
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail

Re: Moving a large amount of mail to a different account [ In reply to ]

h.reindl at thelounge

Jul 14, 2017, 4:33 AM

Post #2 of 4 (1184 views)

Permalink

Am 14.07.2017 um 13:17 schrieb Thomas Raschbacher:
> I am considering moving a large amount of older emails to a seperate
> account (for Archiving reasons).
> Is there an easy way (maybe in the DB directly) to do this instead of
> using an imap client (or maybe writing something simple in python )
>
> Also I'd want to maybe merge some folders (probably ignoring duplicates
> for the moment
>
> -- the reason I want to do this is because that account is hardly
> useable anymore with (especially) webmail clients, because it has > 3500
> IMAP folders

look at the table-structure and the attachment, these are two methods of
our dbmail-cms-plugin, so yes it is possible, not sure how helpful the
moethods isolated are without the other classes since i desinged the
whole stuff in 2009 and never really had to touch the backend code since
then

Re: Moving a large amount of mail to a different account [ In reply to ]

sandino at sandino

Jul 14, 2017, 4:51 AM

Post #3 of 4 (1184 views)

Permalink

On 14/07/17 06:33, Reindl Harald wrote:
>
>
> Am 14.07.2017 um 13:17 schrieb Thomas Raschbacher:
>> I am considering moving a large amount of older emails to a seperate
>> account (for Archiving reasons).
>> Is there an easy way (maybe in the DB directly) to do this instead of
>> using an imap client (or maybe writing something simple in python )
>>
>> Also I'd want to maybe merge some folders (probably ignoring duplicates
>> for the moment
Dbmail already deduplicates messages.
>>
>> -- the reason I want to do this is because that account is hardly
>> useable anymore with (especially) webmail clients, because it has > 3500
>> IMAP folders
>
> look at the table-structure and the attachment, these are two methods
> of our dbmail-cms-plugin, so yes it is possible, not sure how helpful
> the moethods isolated are without the other classes since i desinged
> the whole stuff in 2009 and never really had to touch the backend code
> since then
Example 1: Move mailboxes from user 1001 to user 1234
BEGIN;
update dbmail_mailboxes set owner_idnr = 1234 where owner_idnr = 1001;
COMMIT;

Example 2: Move messages from user 1001 mailbox Archive to user 1234
mailbox Archive/OldUser
BEGIN;
update dbmail_messages set mailbox_idnr = (select mailbox_idnr from
dbmail_mailboxes where owner_idnr = 1234 and name = 'Archive/OldUser')
where mailbox = (select mailbox_idnr from dbmail_mailboxes where
owner_idnr = 1001 and name = 'Archive');
COMMIT;
>
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail

--
Sandino Araico Sánchez
http://sandino.net

Re: Moving a large amount of mail to a different account [ In reply to ]

lordvan at lordvan

Jul 16, 2017, 3:53 AM

Post #4 of 4 (1178 views)

Permalink

On 2017-07-14 13:51, Sandino Araico Sánchez wrote:
>
> user 1001 to user 1234
> BEGIN;
> update dbmail_mailboxes set owner_idnr = 1234 where owner_idnr = 1001;
> COMMIT;
>
> Example 2: Move messages from user 1001 mailbox Archive to user 1234
> mailbox Archive/OldUser
> BEGIN;
> update dbmail_messages set mailbox_idnr = (select mailbox_idnr from
> dbmail_mailboxes where > owner_idnr = 1234 and name =
> 'Archive/OldUser') where mailbox = (select mailbox_idnr from >
> dbmail_mailboxes where owner_idnr = 1001 and name = 'Archive');
> COMMIT;

Thanks. I was considering somethign like this, but I wasn't sure if
there was anything else involved? (maybe caches,.. ?) Did you test this
before?

Also should I run dbmail-util afterwards?

Regards

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail

Mailing List Archive

Mailing List Archive

Attached Files: