E-Mail tables in DB

Discussion in 'General' started by pyte, Oct 6, 2022.

  1. pyte

    pyte Well-Known Member HowtoForge Supporter

    as i'm still doing some migration preparations for our whole E-Mail system into ISPConfig, i still have to test my migration scripts.
    My current script prepares and migrates the following data from a mysql db to ispconfig:
    -> mail domains
    -> mailboxes
    -> alias / catachall
    -> transport

    Looking good so far. However as dumb as i am sometimes, i didn't limit the sql query for the source DB so i've created hunderts of new maildomains, mailboxes etc. and now need to remove these for further testing :)

    Which tables in the ISPConfig DB hold these entries, and can i drop them safely?

    Cheers for the help in advance!
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    It's basically the tables that start with mail_ in their names like mail_user and mail_domain and the tables that start with spamfilter_. Deleting records in them is generally uncritical, but it leaves remnant config files in Rspamd (depending on the filter rules you set for the mailboxes or domains) and also the mailboxes in /var/vmail/ which you might clean up separately.
    pyte likes this.
  3. pyte

    pyte Well-Known Member HowtoForge Supporter

    Makes sense, thank you :)

Share This Page