mysqldump

[ashley98860615]

Hey

The below script will create the text file fine (tried gz but doens't work on local machine) but the text file is empty. Any ideas why?

<?php
$suffix = gmdate('Y-m-d'); 
$directory = '../backups'; 
$fileName = $directory.'/otatf_'.$suffix.'.txt';
$password = "password";
$username = "myusername";
$hostname = "localhost";
$dbname = "mydatabase";

if(!is_dir($directory)) die("$directory is not a directory");

$command = "mysqldump --user $username --password=$password $dbname > $fileName";
if(system($command)) echo "<font color=green>Backup Created in $fileName</font>";
else echo "<font color=red>Couldn't create backup ($fileName)</font><br /><br />Command:<br />$command"; 
?>

[tomhath]

Looks like it should work.

Echo what's in $command and try typing it on a command line (from the directory php is running in if possible) to verify that it works.