Export MySql/MariaDb dump

mysql dump php

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$database = 'dbname';
$user = 'user';
$pass = '***';
$host = 'localhost';
$now = date('Ymdhis');
$dir = dirname(__FILE__) . "/dump{$now}.sql";
echo "<h3>Export database to `<code>{$dir}</code>`</h3>";
exec("mysqldump --user={$user} --password={$pass} --host={$host} {$database} --result-file={$dir} 2>&1", $output);
var_dump($output);