Simple script to dump mysql databse

mysqldump.php

<?php

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$database = 'database_name';
$user = 'user';
$pass = 'password';
$host = 'localhost';

$filename = "/backup-" . date("dmYHis") . ".sql";
$dir = dirname(__FILE__).$filename;

exec("mysqldump --user={$user} --password={$pass} --host={$host} {$database} --result-file={$dir} 2>&1", $output);

echo "<h3>Backing up database to `<code>{$dir}</code>`</h3>";
echo "<a href='$filename'>Download dump file</a><br/>";
var_dump($output);

?>