mysqldump sql file save without content

Question

i have this php script.when i run the script mysqldump, The file got saved but the content is empty. Any help is appreciated.

thank you.

$filename = "backup-" .  date("YmdHis") .  ".sql";
$pathfile = public_path('database') .'/' .$filename;

exec('mysqldump -u'.env('DB_USERNAME').' -p'.env('DB_PASSWORD').' '.env('DB_DATABASE'). ' > ' . $pathfile);

echo 'done';

No Error is printing, But the file is empty

Add param 2 to the exec command so you can see the output like `exec('mysqldump -u'.env('DB_USERNAME').' -p'.env('DB_PASSWORD').' '.env('DB_DATABASE'). ' > ' . $pathfile, $OUTPUT_ARRAY);` — RiggsFolly, Aug 30 '19 at 12:18
i add this line and out put was $OUTPUT_ARRAY is 127 . and still same problam.thank you — No One, Aug 30 '19 at 12:24
So it is not on the PATH. Fix that OR add the complete path to the mysqldump call, which would be safer shoudl you ever move this code — RiggsFolly, Aug 30 '19 at 12:58
mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: YES)" when trying to connect — No One, Aug 30 '19 at 13:16
Thank You So much. This answer works for me. So it is not on the PATH. Fix that OR add the complete path to the mysqldump call, which would be safer shoudl you ever move this code If you can put it as answer i can mark it as answer. thank you in advance. — No One, Aug 30 '19 at 13:29

score 1 · Accepted Answer · answered Aug 30 '19 at 13:37

1

You need to make sure that the mysqldump processor is in a folder that is on your PATH or you have to add the complete path to the mysqldump processor to the PHP call to the processor.

answered Aug 30 '19 at 13:37

RiggsFolly

93,638
21
103
149

mysqldump sql file save without content

1 Answers1