backupmysql.php

<?php
#
# source : https://gist.github.com/micc83/fe6b5609b3a280e5516e2a3e9f633675
#

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

$database = 'namadb';
$user = 'user';
$pass = 'pass';
$host = 'localhost';
#$dir = dirname(__FILE__) . '/dump.sql';
$dir = '/var/www/html/dump.sql';
echo "<h3>Backing up database to `<code>{$dir}</code>`</h3>";

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

var_dump($output);