Parse error: syntax error, unexpected 'ssh2_exec' (T_STRING)

Question

I want to dump mysql database with ssh connection.

<?php
$vps_ip= 'xxxxxx';
$user="yyyy";
$passwd="zzzz";
$connection = ssh2_connect($vps_ip, 22);
ssh2_auth_password($connection, $user,$passwd);
$cmd="mysqldump -u root -pmypass database > /home/back.sql"
ssh2_exec($connection,$cmd);
?>

The error message:

Parse error: syntax error, unexpected 'ssh2_exec' (T_STRING) in  **** on line 7 

I can dump mysql database into /home/back.sql

mysqldump -u root -pmypass database > /home/back.sql

How to fix the parser error in 'ssh2_exec'?

Answer 1

Try:

$vps_ip= 'xxxxxx';
$user="yyyy";
$passwd="zzzz";
$connection = ssh2_connect($vps_ip, 22);
ssh2_auth_password($connection, $user,$passwd);
$cmd="mysqldump -u root -pmypass database > /home/back.sql" ; //ERROR IS HERE, MISSING ;
ssh2_exec($connection,$cmd);