I am having the command line to backup the db and wnat to run through the browser.How can I do it.Because when I execute the below code with the inputs it wont give me the output.Why?How can I achieve the db backup if it is not work out.
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
print system($command);
It sounds like what you want is passthru()
According to the documentation, it will dump the output of the command directly back to the browser.
$ret_val = null;
header("Content-type: application/gzip");
passthru("mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip", $ret_code);
# the extra equals sign below makes sure $ret_val isn't null
if($ret_val !== 0)
echo "Failboat";
That being said, this sounds like a really brittle way to do backups. You'd be better off saving the file to disk first and downloading seperately. IF you really want to get hacky with it though, try using tee to write the file to disk while streaming it back to the browser (warning, that's actually an even worse idea)
I would say one of this functions system or exec. If you need the ouput exec would be better
system($command)
Just for your reference the function signature from the doc
string exec ( string $command [, array &$output [, int &$return_var ]] )
and a quick snippet
exec($command, $output, $ret_var);
echo "return code: {$ret_var}" . PHP_EOL;
echo "output ------" . PHP_EOL;
foreach($output as $line){
print $line . PHP_EOL;
}
Eigther use mysqladmin (english version) or you may use an ajax call (over javascript) in one of your own pages.
