Topic: SOLVED - Problem with large number of mails (~33K) in user mailbox

[miroj]

Hi,

I'm confronting an issue with mail, can't read it nor see attachments due the large number of mails (more than 32K mails). Unfortunately the auto-archive function in Horde (to archive mails per year) is not working, and all mails are in one folder (current).

As workaround, I have moved about 20K mails in other folder and the issue has disappeared. I would appreciate a help (if anyone faced similar problem) how to solve the issue, to make mails available in the Archive and appropriate year (hopefully that would be the solution).

Any other best practice or solution to archive mails within SME and the same to be available to users?

Thanks in advanced.

[Stefano]

Did you try with an email client like thunderbird?
I'll try to test creating a large number of mails on a test machine

As a possible solution, take a look at imapsync.. yiu can use it to archive emails.. just search the web fir the right recipe

[CharlieBrady]

You can use standard tools to select and move messages - each message is just a file. For instance, you can do:

cd ~/Maildir/cur
mkdir -p ../.folder1/{new,tmp,cur}
ls -rt | head -40 | cpio -duvmp ../.folder1/cur
ls -rt | head -40 | xargs rm

to copy the 40 oldest messages in INBOX into an IMAP folder called 'folder1' and then delete them from INBOX.

Instead of 'ls -rt | head -40' you could use some other command to generate the file list. e.g. you could use 'grep -l' to select by text (e.g. by subject, or sender), or you could use 'find' to select by date.

[miroj]

Hi Stefano and CharlieBrady,

@Stefano, yes Thunderbird client was used on regular bases with IMAP, as well a smart phone to read mails. The same problem was occurring in all three cases. I'll look at your proposal for archiving with imapsync.

@CharlieBrady, thanks! This solved the issue. Elegant and logical solution.

I'm marking this issue as solved. Thank you again!