Default Backend to SQL Backend Guide

Converting a Dada Mail Install From a Default Backend to an SQL Backend

Introduction

By default, Dada Mail does not use an SQL backend, but rather uses a simpler method of using a PlainText file for your mailing list subscribers (the format is one email per line) and using what's called, dbm files for everything else: list settings, archives, schedules, etc. Most likely, you're using the Berekeley DB File format.

Although easier to set up, the Default backend for Dada Mail does not have as many features as the SQL backend alternative. These include Subscriber Profile Fields, Partial Mailing List Sending, Multiple Mailing List Sending and some other neat things.

A Contempory Installation

We highly suggest that you use the SQL Backend with a Contemporary Installation setup and NOT the Basic Installation setup. If you're not currently using a Contemporary Installation Method, switch:

http://dadamailproject.com/support/documentation-4_9_1/basic_to_contemporary_installation.pod.html

Setup a SQL Database

Instructions on Setting up Dada Mail's SQL Database Backend can be found here:

http://dadamailproject.com/installation/configuration-sql_backend.html

Run the Export Scripts

There are three separate export scripts that can be run, to move your Mailing List information from the Default backend, to the SQL backend.

The can be found in the,

dada/extras/scripts

directory of your Dada Mail distribution.

We suggest that you move them into the,

dada

directory before you run them.

They require no configuration themselves and installation is as simple as moving them into the dada directory and changing their permissions to, 755 but should be run in this order:

You may run them by simply visiting the scripts in your web browser, or running them from a shell.

Do Not run these scripts twice, or data will be doubled-up.

Loading