importing your existing subscriber base

here's a little perl script that will set your existing mailing list users as being subscribed in the database.
IT REQUIRES: a text file with the e-mail addresses of your list subscribers, 1 per line. You can get the export file from mailchimp, and then use whatever utility to get a file with just the e-mail address.

modify the database information to suit

NO support given, I just wanted to throw this out there, I whipped it up in a few minutes and got the job done. You're on your own

Code:

#!/usr/bin/perl

use DBI;
# MySQL database configurations
my $dsn = "DBI:mysql:YOURDATABASE";
my $username = "YOURDATABASEUSER";
my $password = 'YOURDATABASEPASS';

my $dbh = DBI->connect($dsn,$username,$password, \%attr);
foreach $E ( <STDIN> ) {
    chomp( $E );

    $sql = "UPDATE xf_user SET brmi_subscribe = 1 WHERE email = '$E'";
    print "$sql\n";

    $sth = $dbh->prepare($sql);
    $sth->execute();
    $sth->finish();
}

$dbh->disconnect();
exit;