Cleaning up mail store
Jerry Malcolm <[email protected]> Sat, 20 Dec 2025 15:49:50 -0600
| Newsgroups | gmane.comp.jakarta.james.user |
|---|---|
| Message-ID | <[email protected]> |
Hi,
My james db has gotten totally out of control in size.=C2=A0 I'm trying to=
=20
figure out where the messages are that I can safely delete.=C2=A0 I looked =
at=20
the JAMES_MAILBOX table, and it has 28000+ mailboxes,=C2=A0 most of them Sp=
am=20
or Sent mailbox MAILBOX_NAMEs with spammer-like USER_NAMEs=20
('[email protected]'.=C2=A0 I have no =
clue=20
how or when they got created.=C2=A0 But I'm not going down that path at the=
=20
moment.=C2=A0 Is there any way in the database (direct sql) that I can safe=
ly=20
delete these mailboxes and all of the associated messages/rows in other=20
tables?
If that won't work, maybe there's a better option B.=C2=A0 I haven't really=
=20
investigated it yet, but I know it's coming...=C2=A0 I'm currently on JAMES=
=20
3.x and I'm planning to move up soon.=C2=A0 But if I remember correctly, th=
at=20
requires a significant db schema rework to move to the latest version,=20
correct?=C2=A0 If so, are there any utilities to assist?=C2=A0 Specifically=
, could=20
I create a completely new database and export/import/migrate only the=20
accounts/mailboxes/messages from legit accounts and just leave all of=20
the trash behind?=C2=A0 Suggestions?
Thx,
Jerry