To populate the DSPAM database, you need to follow several steps.

1. First create a database. Login to the mysql command prompt.
+
-----------------------------
$ mysql -u root -p
mysql> CREATE database dspam;
-----------------------------

2. Next, you need to create a dspam user. At the same MySQL prompt:
+
-----------------------------------------------------------------------------------
mysql> GRANT ALL PRIVILEGES ON dspam.* TO dspam@'localhost' IDENTIFIED BY 'passwd';
-----------------------------------------------------------------------------------
+
Replacing passwd with your chosen password.

3. Optimizing the datebase:
+
If you want a space optimized db do:
+
------------------------------------------------------------------------
$ mysql -u dspam dspam -p < /var/lib/dspam/mysql/mysql_objects-space.sql
------------------------------------------------------------------------
+
If you want a speed optimized db do:
+
------------------------------------------------------------------------
$ mysql -u dspam dspam -p < /var/lib/dspam/mysql/mysql_objects-speed.sql
------------------------------------------------------------------------
+
Enter the password you set in the previous step, and the database should be populated.

4. Remember to edit /etc/dspam/dspam.conf accordenly

If you want to use the postgresql, sqlite3 or Berekely DB4 backends you can
find instructions in the dspam documentation.