DUMP WordPress SQL DB

dump.php

<?php
include 'wp-config.php';

$DBUSER = DB_USER;
$DBPASSWD = DB_PASSWORD;
$DATABASE = DB_NAME;

$filename = "backup-" . date("d-m-Y") . ".sql.gz";
$mime = "application/x-gzip";

header( "Content-Type: " . $mime );
header( "Content-Disposition: attachment; filename='" . $filename . "'" );

$cmd = "mysqldump -u $DBUSER --password=$DBPASSWD $DATABASE | gzip --best";   

passthru( $cmd );
exit(0);