Mysqldump创建空的sql文件? [php& Windows上的mysql] [英] Mysqldump create empty sql file? [php & mysql on Windows]

问题描述

我试图转储数据库:

<?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");
?>

我尝试了指定mysqldump.exe的完整路径，或者只是使用mysqldump，它仍然给我一个0kb的dumpfile.sql

I tried both specified full path to mysqldump.exe or just use mysqldump, it still give me a 0kb dumpfile.sql

详细信息: 编程语言:PHP 资料库:MySql 5.XX 操作系统(服务器):Windows Server2003.(当前在Windows Vista计算机上进行测试)

Details: Programming Language: PHP Database: MySql 5.XX OS(server): Windows Server 2003. (currently testing on Windows Vista machine)

编辑@ Jeremy Heslop:

EDIT @ Jeremy Heslop:

我尝试过:

shell_exec("C:\wamp\bin\mysql\mysql5.1.33\bin\mysqldump.exe --opt -h $dbhost -u$dbuser -p$dbpass $dbname > test.sql");

safe_mode =关闭

safe_mode = off

还是没有运气的人.

推荐答案

叫我疯了，但是您不需要在路径名中转义那些反斜杠吗?我猜测该命令将失败，并且由于错误是在stderr上，因此没有任何写入.

Call me crazy, but don't you need to escape those backslashes in your path name? I'm guessing that the command fails, and since the error is on stderr, nothing gets written.

这篇关于Mysqldump创建空的sql文件? [php& Windows上的mysql]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！