PHP code to download backup of MySQL database.

This will backup the MySQL database and store it in the specified path.

<?php 
define("BACKUP_PATH", "Backup/");
$server_name = "localhost";
$username = "root";
$password = "password";
$database_name = "dbname";
$date_string = date("Ymd");

$cmd = "C:/xamp/mysql/bin/mysqldump --routines -h {$server_name} -u {$username} -p{$password} {$database_name} > " . BACKUP_PATH . "{$date_string}_{$database_name}.sql";
$filename = $date_string."_".$database_name.".sql";
$filepath = "Backup/".$filename;
exec($cmd);

header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-Disposition: attachment; filename=$filename");
header("Content-Type: application/zip");
header("Content-Transfer-Encoding: binary");

// Read the file
readfile($filepath);
exit;
?>

<?php

define("BACKUP_PATH", "Backup/");

$server_name = "localhost";

$username = "root";

$password = "password";

$database_name = "dbname";

$date_string = date("Ymd");

$cmd = "C:/xamp/mysql/bin/mysqldump --routines -h {$server_name} -u {$username} -p{$password} {$database_name} > " . BACKUP_PATH . "{$date_string}_{$database_name}.sql";

$filename = $date_string."_".$database_name.".sql";

$filepath = "Backup/".$filename;

exec($cmd);

header("Cache-Control: public");

header("Content-Description: File Transfer");

header("Content-Disposition: attachment; filename=$filename");

header("Content-Type: application/zip");

header("Content-Transfer-Encoding: binary");

// Read the file

readfile($filepath);

exit;