Mysqldump create empty sql file? [php & mysql on Windows]
- by mysqllearner
Hi all,
I tried to dump a database:
<?php
$dbhost = "localhost";
$dbuser = "XXXX";
$dbpass = "XXXXXXXX";
$dbname = 'testdb';
$list = shell_exec ("C:\wamp\bin\mysql\mysql5.1.33\bin\mysqldump.exe $dbname --user=$dbuser--password=$dbpass > dumpfile.sql");
?>
I tried both specified full path to mysqldump.exe or just use mysqldump, it still give me a 0kb dumpfile.sql
Details:
Programming Language: PHP
Database: MySql 5.XX
OS(server): Windows Server 2003. (currently testing on Windows Vista machine)
EDIT @ Jeremy Heslop:
I tried:
shell_exec("C:\wamp\bin\mysql\mysql5.1.33\bin\mysqldump.exe --opt -h $dbhost -u$dbuser -p$dbpass $dbname > test.sql");
safe_mode = off
Still no luck man.
