[Neyland]

AdminCP->Maintenance->Database Backup. Bottom of page "CSV backup of single database table".

I got it to work, for those wanting to know, dump the CSV files in a folder along with the attached script. You'll need to edit with your information and make it executable (chmod u+x importer.pl)

#!/usr/bin/perl -w
use strict;

my $dir = '/home/DOMAINNAME/DIRNAME';
my $dbname = 'DATABASENAME';
my $dbuname = 'DATABASE_LOGIN_NAME';
my $dbpswd = 'DATABASE_PASSWORD';
my $importfilename;
my $cmd;

opendir(DIR, $dir) or die $!;

while (my $file = readdir(DIR)) {
    # No Directories
    next unless (-f "$dir/$file");

    #File names should == table names!! ie access.csv for the access table
    # Look for files ending in .csv
    next unless ($file =~ m/\.csv$/);

    # Provide full path to file we want to import
    $importfilename = "$dir/$file";

   # Call mysqlimport
   # Imports CSVs exported with column names in first row, comma delimted, enclosed by quote
   $cmd ="mysqlimport --local --delete --fields-terminated-by=, --ignore-lines=1 --fields-enclosed-by=\\' --fields-escaped-by=\\\\ --user=$dbuname --password=$dbpswd $dbname $importfilename";

   system($cmd);
}

closedir(DIR);
exit 0;