PHP script to make a backup of MySQL

[foxden]

I'm having a problem with this script. It is suppose to simply get the current time stamp, make a backup of my db and tack on the date to the file name. It isn't working and I'm not getting any results back. I've tried shell_exec, exec, system, passthru to no avail.

Please help.

$mysql_bkup = "mysqldump --add-drop-table -c -u user -p password -B db_name>/var/www/html/db/bk_upd.sql.";
$mysql_bkup .= "$today3";

if ($go != "yes")
{
echo "$form";
}

elseif ($go == "yes")
{

$me = shell_exec($mysql_bkup);

[kbrij]

You need full chmod 777 permission on that directory where it is going to put the backup data.

the shell_exec is fine.

It works in my case.

also i have noticed a missing closing bracket after the shell_exec in your code.

brij.

[foxden]

Thanks!!!!
That was it...I just failed to copy that closing bracket in my snippet.

Thanks again.

Josh