Mysqldump generate empty file in php

Question

I try to save my database in PHP but not work its work only with Shell

With shell (work good)

mysqldump --user=root --password= --host=localhost site > C:\xamppp\htdocs\site\sql\tests.sql

With php (file is created but empty)

system('mysqldump --user=root --password= --host=localhost site > C:\xamppp\htdocs\site\sql\test.sql', $result);

for $result i have 1

I work with XAMP on Windows 7, i test exec and system but its same Thanks you

Community · Accepted Answer · 2017-05-23 12:16:10Z

2

$return_var = NULL;
$output = NULL;
$command = "mysqldump -u mysql-user -h your_host -pmysql-pass database_name > /directory_path/file.sql";
exec($command, $output, $return_var);

or you can refer to this answer mysqldump via PHP

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered May 30, 2015 at 15:45

Oli Soproni B.

2,8103 gold badges24 silver badges47 bronze badges

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

1 Comment

p4c Over a year ago

Thanks the path with PHP its not correct now its work with C:\xamppp\mysql\bin\mysqldump

e-Learner · Accepted Answer · 2015-05-30 15:47:05Z

1

Use 2>&1

<?php system("mysqldump --user=root --password= --host=localhost site > C:\xamppp\htdocs\site\sql\test.sql 2>&1", $result); ?>

answered May 30, 2015 at 15:47

e-Learner

5171 gold badge4 silver badges15 bronze badges

Collectives™ on Stack Overflow

Mysqldump generate empty file in php

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related