<?php

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

$database = 'database_name';
$user = 'database_user';
$pass = 'database_password';
$host = 'localhost';

$dir_sql = dirname(__FILE__) . '/dump.sql';
$dir_zip = dirname(__FILE__) . '/dump.zip';

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

// create zip file
$z = new ZipArchive();
$z->open($dir_zip, ZIPARCHIVE::CREATE);
$z->addFile($dir_sql);
$z->close();

// remove sql file
@unlink($dir_sql);

echo "Backup file created at {$dir_zip}";