backup database using mysqldump with php not working

Question

please i want to backup my database using php. i have tried many answered question on this similar problem but still not working.

$username = "***";
$password = '******';
$database = 'mydatabase';
$filename = date("Y-m-d_H:i:s") . ".sql";


exec("(/usr/bin/mysqldump --opt -u$username -p$password $database> $filename) 2>&1", $output, $result);

var_dump($result);
echo "<br />";
var_dump($output);
echo "<br />";

this is the response

int(1) 
array(0) { }

There would be no output though, you are writing to a file aren't you? The .sql doesn't get created? — user3783243
– user3783243, Commented Oct 22, 2018 at 13:10
Given code is working properly. It will create .sql file if you have write permission on executing directory. It will throw warning related to passing password in CLI which can be removed by using .cnf file. — Imran Khan
– Imran Khan, Commented Oct 22, 2018 at 13:12
There would be no output though, correct. 2>&1 is redirecting the error output in the standard, since you already redirected the standard output with >$filename it looks correct that in case of you are not seing nothing , perhaps you need to use a tee to have something in the output. The standard linux command return is 0 for successfull, other values means an error and you are getting 1 but the only place where an error is shown will be inside the file redirected output. — A. Lion
– A. Lion, Commented Oct 22, 2018 at 13:32

Raymond Tey · Accepted Answer · 2018-10-22 13:13:54Z

1

try

exec( '/usr/bin/mysqldump --user="'.$username .'" --password="'.$password .'" "'.$database .'" > "'.$filename .'"' );

answered Oct 22, 2018 at 13:13

Raymond Tey

4944 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

backup database using mysqldump with php not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related