dada_subscribers_plaintext2sql.pl

- Name dada_subscribers_plaintext2sql.pl
- Description
- How to use this script
- COPYRIGHT

# Name dada_subscribers_plaintext2sql.pl

# Description

Cute name, huh?

Basically, this small script takes the information of a Dada Mail plaintext subscription list and ports it to the MySQL format.

Fairly simple and straightforward.

# How to use this script

- Backup Everything

  SQL tables, list files (all of them)

- Create the Subscribers SQL table

  The SQL statement to run should be saved in a file called dada_subscribers.sql which is located in the dada/extras/SQL directory of the distribution

- Set DB_TYPE to the correct SQL type (MySQL, Postgres)

  Directions are located in the Config.pm about this, search for, $SUBSCRIBER_DB_TYPE

- Fill in %SQL_PARAMS in the Config.pm file

  Again, directions should be supplied in the Config.pm file.

After the above (do not skip a step) are done, make sure Dada Mail is still running by visiting it in your webbrowser. The program should run exactly as before, except no subscribers will be present.

Upload this script into the same directory that you have the mail.cgi script in, and run it, either from your web browser, or via a shell connection (which is prefered).

That should be it.

ps. backup everything.

# COPYRIGHT

Copyright (c) 1999-2008 Justin Simoni All rights reserved.

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.