List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:March 14 2001 3:08pm
Subject:Re: Trouble automating backup
View as plain text  

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

	prepare("BACKUP table $table TO $othertable")

instead.
Thread
Trouble automating backupDuncan Hudson14 Mar
  • Re: Trouble automating backupJochen Wiedmann14 Mar
  • Re: Trouble automating backupGreg Meckes14 Mar
    • Re: Trouble automating backupDodger14 Mar