mysqldump using php for database backup is not working

Question

I have written this piece of code to take my database backup. I am using MySQL as my DB and PHP as a compiler.

<?php
$dbhost   = "localhost";
$dbuser   = "root";
$dbpwd    = "admin";
$dbname   = "mydatabase";
mysql_connect($dbhost, $dbuser, $dbpwd, $dbname) or die('Problem');
$dumpfile = $dbname . "_" . date("Y-m-d_H-i-s") . ".sql";
passthru("/usr/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd --all-databases > $dumpfile");
echo "$dumpfile "; passthru("tail -1 $dumpfile");
?>

The code get executed but the problem is the downloaded file is of 0KB i.e there is no data in the file.

What is the issue. I have searched a lot on internet but unable to find solution for myself.

are you sure the /usr/bin/mysqldump is available on the windows machine? shouldnt it be c:\blah\mysql... ? — MilMike
– MilMike, Commented Jun 18, 2012 at 11:30

Ted Hopp · Accepted Answer · 2012-10-25 03:35:36Z

2

If you are using Windows, place the mysqldump.exe executable in the same location as your backup script. That should work

edited Oct 25, 2012 at 3:35

Ted Hopp

235k48 gold badges412 silver badges533 bronze badges

answered Oct 25, 2012 at 3:11

Pret

213 bronze badges

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

Comments

metalfight - user868766 · Accepted Answer · 2012-06-18 10:46:23Z

0

Check permission for the directory in which your code is running. It should have write permission.

answered Jun 18, 2012 at 10:46

metalfight - user868766

2,7501 gold badge17 silver badges21 bronze badges

1 Comment

Django Anonymous Over a year ago

I have given full privilege to the folder still its not working.

Collectives™ on Stack Overflow

mysqldump using php for database backup is not working

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related