How do I Re-build the Anti-spam Database?
Posted by on 01 August 2012 01:37 PM

There are times when the Anti-spam database can become corrupt, through one reason or another. It is, at this time that it is

recommended that you start the Database from scratch. However, we know that it is important to not lose all the white list and

black list items that you already have, so below are the steps needed to re-build and then migrate the old data to the new

database.

1- go to [Anti-Spam] [DB settings] and either take a screen shot or write down the information listed there in the ODBC. (you will want this information later).

2- Then close the Icewarp Console.

3- Go to the install folders and rename \Icewarp\spam to \Icewarp\spam_old

4- Run Icewarps install files again.

Now, the Anti-spam has been re-created.

1- go to [Anti-Spam] [DB settings] and either take a screen shot or write down the information listed there in the ODBC.

2- This should be different, but if it is the same, that's okay too.

Then do the following:

To transfer data from your current database to a new database, you simply need to follow the below steps.

2- Create a new ODBC DSN that points to the old database(or edite the one that existed to point to the spam_old folder).

3- Open up the Icewarp Console, and go to [System] [Tools] [Database Migration]

4- Choose the type of database that you will be transferring. (from Accounts, Anti-Spam, or Groupware.)

5- In the Source DSN section place the ODBC DSN of the original database.

6- In the Destination DSN section place the ODBC DSN of the new database (see your screen shot after the install)

7- Once you do this, simply click on the Start Migration button.

Now, it should work properly.