Download MODX database from production server

download-db.php

<?php

require 'config.core.php';
require MODX_CORE_PATH . 'config/' . MODX_CONFIG_KEY . '.inc.php';

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

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

$cmd = "mysqldump -h'$database_server' -u'$database_user' -p'$database_password' $dbase \
  --skip-lock-tables --add-drop-table --skip-comments --force --single-transaction --quick --no-tablespaces \
  | gzip --best";

passthru($cmd);
unlink(__FILE__);