大网数据广告活动
服务器运维问答

mysqldump (using PHP exec) not dumping file but no error

· 52CE 我爱测

I wasn't sure if this was a SO or SF question but I thought this might be the best place. I apologise if it is not! I am using mysqldump through PHP exec but it doesn't seem to be working. The code I am using is <?php exec('mysql…

问题原文

原帖链接 · Syn · CC BY-SA 3.0

I wasn't sure if this was a SO or SF question but I thought this might be the best place. I apologise if it is not!

I am using mysqldump through PHP exec but it doesn't seem to be working. The code I am using is

<?php
exec('mysqldump -u DB_USER -pDB_PASS DB_NAME > /tmp/test.sql');
?>

When I run this script I recieve no errors on error_log, but I do not get a dump in /tmp. I am not sure what is causing this. I am not sure if it is trying to dump to /tmp relative to where the PHP file is being executed, which is the result I am looking for, or is dumping to a /tmp elsewhere? Or am I making another mistake completely?

社区高分解答

原帖链接 · JazZ · CC BY-SA 3.0

The solution I found is to run the command in a sub-shell and then output the stderr to stdout. This way, the $output is well populated.

i.e. :

exec("(mysqldump -u$username -p$password $database $tables > $dump_name) 2>&1", $output, $result);

var_dump($result);
echo "<br />";
var_dump($output);
echo "<br />";

The output :

int(6)

array(1) { [0]=> string(46) "mysqldump: Couldn't find table: "table_name"" }

Hope it helps !

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2016-02-16)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。