[Resolved] mysqldump - parse error

[baffled_in_UK]

Hi,

I copied this snippet from this forum but it gives me a parse error, I've spent an hour looking at the manual but I must be having a particularly "thick" day as I can't see the error. Any ideas?

$host  = "localhost"; 
$user  = "user"; 
$pass  = "pass"; 

$backupDir  = "/home/usr/"; 
$backupFileName = "backup.sql"; 

$back = $backupDir.$backupFileName 
system(sprintf("mysqldump --all-databases -h %s -u %s -p%s > %s",$host,$user,$pass,$back)); 
?>  

Many thanks.

[wilku]

There is no semicolon at the end of one line:

$back = $backupDir.$backupFileName;

I hope it helps.

[baffled_in_UK]

I was so busy looking at the mysqldump statement I never looked for the obvious!

Thank you.