Database Backup Through mysqldump and exec(); ?

[FoxhoundX]

Alright, I'm trying to make a complete backup of my database, and I have this code which I got from another thread here:

 
<?
$host           = "localhost";
$user           = "myusername";
$pass           = "mypassword";

$backupDir      = "/public_html/sqldump/";
$backupFileName = "backup.sql";

$back           = $backupDir.$backupFileName;
system(sprintf("mysqldump --all-databases -h %s -u %s -p%s > %s",$host,$user,$pass,$back));
?>

However, there is no output created whatsoever. Is there something I did wrong? Perhaps the $backupDir needs to be my full system path? Not just what is shown on the FTP client? 😐

[LordShryku]

Have you tried the full system path? You're dead on there considering mysql has no clue about relative paths.

that script looks mighty familiar.... :p

[FoxhoundX]

Yeah, I tried the full system path which I got from this:

<?
echo $_SERVER['PATH_TRANSLATED'];
??

And again, no output was created.

[LordShryku]

Okay, lets run it down then. Is mysqldump in your PATH? Meaning if you ran that command directly on the command line, does it work? With my script, I usually point to the full path anyway, just for portability. ie.
/usr/local/mysql/bin/mysqldump blah blah
instead of just
mysqldump blah blah