Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I have 8. year old email server (CPanel) that is around 100GB.
Because of costs I need to archive the whole thing somehow.
Only acceptable way is for me to get the 'Mail' directory from CPanel
and turn it into searchable database. So that for example, I can query
for user at date and get attachments.
Is there any solution that can help me with this or I'm going to
need to somehow turn 'Mail' directory into SQL database and I don't
even know how I'm going to handle attachments that are stored in text files?
I have 8. year old email server (CPanel) that is around 100GB.
Because of costs I need to archive the whole thing somehow.
Only acceptable way is for me to get the 'Mail' directory from CPanel
and turn it into searchable database. So that for example, I can query
for user at date and get attachments.
Is there any solution that can help me with this or I'm going to
need to somehow turn 'Mail' directory into SQL database and I don't
even know how I'm going to handle attachments that are stored in text files?
Help pls!
Why not disable SMTP delivery (listen locally only) and sending outside the host, back it up, and leave it running otherwise just as is. This way you can use email clients to read that mail. That way attachments would still be there, and work as they always have.
If one REALLY wanted to get tricky, one might even be able to make that mail directory be read only and have it still work, but I would want to perform several tests to verify that nothing would break doing that.
I have 8. year old email server (CPanel) that is around 100GB. Because of costs I need to archive the whole thing somehow.
Only acceptable way is for me to get the 'Mail' directory from CPanel and turn it into searchable database. So that for example, I can query for user at date and get attachments.
Is there any solution that can help me with this or I'm going to need to somehow turn 'Mail' directory into SQL database and I don't even know how I'm going to handle attachments that are stored in text files?
I'd agree with the option of running a local IMAP server and dumping to it. But if you REALLY need a genuine SQL database, you can use perl or python with an IMAP module (imaplib for Python, Net::IMAP for Perl), and write a program to parse things. Can easily get the sender, recipient, message body, and attachments. From there, shove them into a DB table. Attachments can be inserted as blobs in a database.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.