Magento database dump

mageDbDump.php

<?php

$xml = simplexml_load_file("app/etc/local.xml");

$db_host = (string)$xml->global->resources->default_setup->connection->host;
$db_name = (string)$xml->global->resources->default_setup->connection->dbname;
$db_username = (string)$xml->global->resources->default_setup->connection->username;
$db_password = (string)$xml->global->resources->default_setup->connection->password;

$mysqldump = trim(shell_exec("which mysqldump"));
$tar = trim(shell_exec("which tar"));

$sqlFileName = "backup.sql";

$dumpData = $mysqldump . " ";
$dumpData .= "-u " . $db_username . " ";
$dumpData .= "-p" . $db_password . " ";
$dumpData .= "-h " . $db_host . " ";
$dumpData .= $db_name . " > " . $sqlFileName;

echo "Executing:\n" . $dumpData . "\n";
// Backup database
shell_exec($dumpData);

$compressDB = $tar . " -zcvf " . $sqlFileName . ".tar.gz " . $sqlFileName;
echo "Executing:\n" . $compressDB . "\n";
// Compress database
shell_exec($compressDB);