Why doesn't my PHP database backup script work?

Question

When I manually run the output from print it works fine. However the actual program produces the following error:

sh: /mysqldump: No such file or directory

<?php

$backupFile = "backup/wordpress" . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump -hlocalhost -uusername -ppassword dbname | gzip > $backupFile";
print $command;
system($command);


?>

Ass3mbler · Accepted Answer · 2011-01-26 22:28:19Z

1

try adding the full path in front of mysqldump

answered Jan 26, 2011 at 22:28

Ass3mbler

3,9452 gold badges23 silver badges18 bronze badges

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

Comments

John Parker · Accepted Answer · 2011-01-26 22:28:32Z

0

You need to specify the full path to the mysqldump command line tool.

Entering...

which mysqldump

...from the shell will tell you the necessary path.

answered Jan 26, 2011 at 22:28

John Parker

54.5k11 gold badges133 silver badges131 bronze badges

Collectives™ on Stack Overflow

Why doesn't my PHP database backup script work?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related