MySQL dump on WAMP server using PHP

Question

I am trying to dump the mysql database using a PHP file. I am using windows 7 OS.

but I am always getting error; This is my code

$user='root';
$pass='mypassword';
$host='localhost';
//$sql_file='db_backup.sql';
$cmd = "e:\\wamp\\bin\\mysql\\mysql5.6.12\\bin\\mysqldump -h$host  -u$user -p$pass hospitalerp > db_backup.sql";
exec($cmd, $output, $return);
if ($return != 0) { //0 is ok
    die('Error: ' . implode("\r\n", $output));
}

echo "dump complete";

Any suggestion will be greatly appreciated. Thanks.

What kind of error? Add error_reporting(E_ALL); ini_set('display_errors', 1); at the top of your file to see any possible error and show us. — bcesars
– bcesars, Commented Mar 16, 2015 at 16:54
I have added the line as suggest by you, but I am still getting only the Error: is showing on the screen. — Pawan
– Pawan, Commented Mar 16, 2015 at 16:57

Pawan · Accepted Answer · 2015-03-16 17:37:50Z

2

Ok I found the solution, may someone find it useful.

$user='root';
$pass='mypassword';
$host='localhost';

$cmd='e:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump --user='.$user.' --password='.$pass .' --host=localhost hospitalerp > db_backup4.sql';
//var_dump($cmd);exit;
exec($cmd, $output, $return);
if ($return != 0) { //0 is ok
    die('Error: ' . implode("\r\n", $output));
}

echo "dump complete";

answered Mar 16, 2015 at 17:37

Pawan

3,84417 gold badges52 silver badges88 bronze badges

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

1 Comment

Teepeemm Over a year ago

It appears the change was in $cmd, where you switched from double quotes and escaped backslashes to single quotes and non-escaped backslashes. Is that correct?

Carlos Sifuentes Ludeña · Accepted Answer · 2015-10-19 21:48:36Z

2

I note that mysqldump need the exe extension, just like:

$cmd='e:\wamp\bin\mysql\mysql5.6.12\bin\mysqldump.exe --user='.$user.' --password='.$pass .' --host=localhost hospitalerp > db_backup4.sql';

I tried this on a Windows 10 PC

answered Oct 19, 2015 at 21:48

Carlos Sifuentes Ludeña

215 bronze badges

Collectives™ on Stack Overflow

MySQL dump on WAMP server using PHP

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related