Using PHP script: why mysqldump does not dump sql file? -
hye, i'm new in php , trying utilize mysqldump using php script. seek using command , dump process success. situation is, when tried dump using local computer, dump succeed. when code transfer server, mysqldump doesn't work. have tried solution related mysqldump topics, still doesn't work. hope can guide me. tq
<?php /*----------------------------------------------- mysqldump server ------------------------------------------*/ $dbhost = "*****"; $dbuser = "*****"; $dbpass = "*****"; $dbname = "*****"; //set date today $today=date("d-m-y"); //set file name $filename = "leave_".$today.".sql"; //mysqldump //for server $command = sprintf("/usr/bin/mysqldump --opt -h%s -u%s -p%s %s >/var/www/html/leave/leave/backup/%s", //for local //$command = sprintf("c:\appserv\mysql\bin\mysqldump --opt -h%s -u%s -p%s %s > %s", $dbhost, $dbuser, $dbpass, $dbname, $filename ); system($command); /*------------------------------------------------------------- save file sql local ---------------------------------------------------------------*/ $file = "leave_".$today.".sql"; if(!$file) { // file doesn't exist, output error die('file not found'); } else { // set headers inquire user save file. header('pragma: anytextexeptno-cache', true); header("pragma: public"); header("expires: 0"); header("cache-control: must-revalidate, post-check=0, pre-check=0"); header("cache-control: private", false); header("content-type: text/plain"); header("content-disposition: attachment; filename=$file"); // read file disk readfile($file); } ?>
i assume php permits execution of commands through system().
you not running in safe mode, or, if are, safe_mode_exec_dir contains commands need
php mysqldump
No comments:
Post a Comment