gistfile1.txt

<?php
$file_script="data.sql";
//possible option:  restore|backup
$action="restore";

$user="root";
$pwd="root";
$bd="test";

if($action=="restore"){
	//This is the command
	$cmd="mysql -u $user -p$pwd $bd < $file_script";
	$output=shell_exec($cmd);
	
	echo $cmd;
	echo $output;
} else if($action=="backup"){
	$withprocedure=true;
	$nodata=true;
	$option="";
		
	if($withprocedure)
		$option.="-R ";
	if($nodata)
		$option.="--no-data ";
	
	$cmd="mysqldump -u $user -p$pwd $option $bd > $file_script";
	
	$output=shell_exec($cmd);
	
	echo $cmd;
	echo $output;
}

?>