mysql dump using php script

Question

I tried the below code to backup my database "db_school".

<?php
    shell_exec('mysqldump -u root -h localhost db_school > backup-file.sql');
?>

The new file named "backup-file.sql" is created but, the problem is that it is totally empty. Following is my database table:

-------------------------------------
id  |  school_name   |  city
-------------------------------------
1   |  cp school     |  New York
2   |  public school |  San Fracisco
-------------------------------------

Note: my 'root' user has no password I know there are many posts on this topic but each suggests the code similar to above

There may be some error happening and is not captured anywhere, can you try 2>&1 in your command or even echo the output of the command. — code.tweetie
– code.tweetie, Commented Nov 15, 2013 at 12:00
the command runs successfully in shell and even I tried printing the output but it is empty either — Adi
– Adi, Commented Nov 15, 2013 at 12:02

Vishal Kamal · Accepted Answer · 2013-11-15 12:06:42Z

1

Make sure folder having full permission (777 read/write).

because this code create new file name "backup-file.sql" , so folder having permission to create new file.

please give the permission to that folder where this php file executes.

answered Nov 15, 2013 at 12:06

Vishal Kamal

1,1242 gold badges10 silver badges35 bronze badges

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

2 Comments

Adi Over a year ago

thanks vishal, i think your answer will make it but I don't know how to give permissions on local machine

Vishal Kamal Over a year ago

Which operating system you have

developerCK · Accepted Answer · 2013-11-15 11:58:52Z

0

try this dear

a set of one or more complete databases

<?php
    shell_exec('mysqldump -u root -h localhost --database db_school > backup-file.sql');
?>

answered Nov 15, 2013 at 11:58

developerCK

4,5263 gold badges19 silver badges35 bronze badges

1 Comment

Adi Over a year ago

thanks for the answer but, again the same...an empty file... could there be problem with my system or xampp?

Collectives™ on Stack Overflow

mysql dump using php script

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related