dump.php

<?php
/**
 * dump.php?output=1
 * 
 * Usage: curl http://domain.com/dump.php > dump.sql
 */
$bin = PHP_OS == 'Darwin' ? '/usr/local/mysql/bin/mysqldump' : '/usr/bin/mysqldump';
$user = 'root';
$password = '';
$db = 'cenotes';
$cmd = "$bin -u $user -p'$password' --default-character-set=utf8 $db";
$print = false;

if (!empty($_SERVER['QUERY_STRING'])) {
	parse_str($_SERVER['QUERY_STRING'], $query);
	if (isset($query['output']) && $query['output'] == 1) {
		$print = true;
	}
}

header('Content-Type: text/html; charset=utf-8');
if ($print) {
	$output = shell_exec($cmd);
} else {
	$cmd = $cmd . ' > ' . dirname (__FILE__)  . '/dump.sql';
	$output = exec($cmd . ' > ' . dirname (__FILE__)  . '/dump.sql');
}

echo "/*$cmd*/";
echo "\n";
echo $output;
?>