$DBH = DBI->connect("DBI:mysql:dump_database", "root", "", { RaiseError => 0, PrintError => 0, AutoCommit => 1 });
$query = "BACKUP TABLE tbl_name[lsql_CatLinks, lsql_CatRelations, lsql_Category, lsql_Changes, lsql_ClickTrack, lsql_Editors, lsql_EmailMailings, lsql_EmailTemplates, lsql_Links, lsql_MailingIndex, lsql_MailingList, lsql_MailingListIndex, lsql_Reviews, lsql_Users, lsql_Verify] TO 'file.sql'";
$sth = $DBH->prepare($query);
$sth = $DBH->execute();
mysql_close($DBH);

Software error:

Can't locate object method "execute" via package "DBI::db" at /home/ace-host/public_html/small_dumps/getsql.cgi line 47.

For help, please send mail to the webmaster (admin), giving this error message and the time and date of the error.

#!/usr/bin/perl

use CGI::Carp qw(fatalsToBrowser);
require DBI;

$DBH = DBI->connect("DBI:mysql:dump_database", "admin", "147896321", { RaiseError => 0, PrintError => 0, AutoCommit => 1 });
$query = "BACKUP TABLE tbl_name[lsql_CatLinks, lsql_CatRelations, lsql_Category, lsql_Changes, lsql_ClickTrack, lsql_Editors, lsql_EmailMailings, lsql_EmailTemplates, lsql_Links, lsql_MailingIndex, lsql_MailingList, lsql_MailingListIndex, lsql_Reviews, lsql_Users, lsql_Verify] TO '/home/ace-host.com/public-html/small_dumps/file.sql'" or die $dbh->errstr;
$sth = $DBH->do($query);
#$sth = $DBH->execute();
$DBH->disconnect;

print "Content-type: text/html \n\n";
print "done";

$sth = $DBH->do($query);
if (!$sth) { print "there was an error <BR>\n"; }

$sth = $DBH->do($query);
if (!$sth) { print "there was an error. It was: " . $DBH->errsrt . "<BR>"; }

[$DBI::err] $DBI::errstr

BACKUP TABLE * TO '/home/ace-host.com/public_html/small_dumps/file.sql'

mysqldump -h localhost -u username -p password
databasename > /home/ace-host.com/public-html/small_dumps/file.sql