<?php<\/span><\/div>$file_script<\/span>=<\/span>"data.sql"<\/span>;<\/span><\/div>//possible option: restore|backup<\/span><\/div>$action<\/span>=<\/span>"restore"<\/span>;<\/span><\/div> <\/div>
$user<\/span>=<\/span>"root"<\/span>;<\/span><\/div>$pwd<\/span>=<\/span>"root"<\/span>;<\/span><\/div>$bd<\/span>=<\/span>"test"<\/span>;<\/span><\/div> <\/div>
if<\/span>(<\/span>$action<\/span>==<\/span>"restore"<\/span>){<\/span><\/div> //This is the command<\/span><\/div> $cmd<\/span>=<\/span>"mysql -u <\/span>$user<\/span> -p<\/span>$pwd<\/span> <\/span>$bd<\/span> < <\/span>$file_script<\/span>"<\/span>;<\/span><\/div> $output<\/span>=<\/span>shell_exec<\/span>(<\/span>$cmd<\/span>);<\/span><\/div> <\/div>
echo<\/span> $cmd<\/span>;<\/span><\/div> echo<\/span> $output<\/span>;<\/span><\/div>}<\/span> else<\/span> if<\/span>(<\/span>$action<\/span>==<\/span>"backup"<\/span>){<\/span><\/div> $withprocedure<\/span>=<\/span>true<\/span>;<\/span><\/div> $nodata<\/span>=<\/span>true<\/span>;<\/span><\/div> $option<\/span>=<\/span>""<\/span>;<\/span><\/div> <\/div>
if<\/span>(<\/span>$withprocedure<\/span>)<\/span><\/div> $option<\/span>.=<\/span>"-R "<\/span>;<\/span><\/div> if<\/span>(<\/span>$nodata<\/span>)<\/span><\/div> $option<\/span>.=<\/span>"--no-data "<\/span>;<\/span><\/div> <\/div>
$cmd<\/span>=<\/span>"mysqldump -u <\/span>$user<\/span> -p<\/span>$pwd<\/span> <\/span>$option<\/span> <\/span>$bd<\/span> > <\/span>$file_script<\/span>"<\/span>;<\/span><\/div> <\/div>
$output<\/span>=<\/span>shell_exec<\/span>(<\/span>$cmd<\/span>);<\/span><\/div> <\/div>
echo<\/span> $cmd<\/span>;<\/span><\/div> echo<\/span> $output<\/span>;<\/span><\/div>}<\/span><\/div> <\/div>
?><\/span><\/span><\/div> <\/div>
<\/div><\/pre><\/div>\n \n <\/div>\n\n