Default Backend to SQL Backend Guide

Default Backend to an SQL Backend Mailing List Conversion

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 Profile Fields, Partial Mailing List Sending, Multiple Mailing List Sending and some other neat things. For this reason, we highly suggest to set up Dada Mail using the SQL backend, using either MySQL or PostgreSQL

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 beforehand:

https://dadamailproject.com/support/documentation-11_22_0/basic_to_contemporary_installation.pod.html

If you've installed Dada Mail using the included Dada Mail installer, you are already running a Contemporary Installation of Dada Mail.

Upgrade via the Dada Mail Installer

You can reconfigure your Dada Mail to use the SQL backend by using the Dada Mail installer.

Reenable the Dada Mail Installer

Renable the Dada Mail installer by moving the dada/installer directory back into place - it may have been renamed to, installer-disabled(followed by a random string of letters/numbers) and changing the permissions of the, dada/installer/install.cgi script to, 755. Visit the, install.cgi script again in your web browser and follow the directions to install Dada Mail with one of the SQL backends:

https://dadamailproject.com/d/install_dada_mail.pod

The installer should:

Once completed, your previous mailing lists will not be available, until after you run the Migration Scripts

Running the Migration Scripts

There are separate migration scripts to migrate your Default Backend files to the SQL backend.

They may be found in the,

dada/extras/scripts

directory of your Dada Mail distribution.

None of the require any configuration themselves and installation is as simple as changing their permissions to, 755.

You will want to make sure to run them in this order:

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

Once you've run these migration scripts, your Dada Mail installation should be moved from the Default backend, to one of the SQL backends.


Dada Mail Project

Download

Installation

Support