Duncan Hudson wrote:
> $sth_backup = $dbh->prepare("BACKUP table ? TO ?");
You cannot embed table names or column names with the
placeholder. If you do, that will not be mapped to
BACKUP table foo
but to
BACKUP table 'foo'
which will most probably fail.
Use
p
Hi, I'm trying to write a Perl script that will automate the backing up of
the tables in my database. I'm building an array of the tables in the
database, using show tables, and then I step through the array with a
foreach loop. I've setup the SQL statement (to do the backup) as follows:
$