Dump local database to SQL file

mysqldump.php

<?php
//http://stackoverflow.com/questions/6750531/using-a-php-file-to-generate-a-mysql-dump
//error_reporting(E_ALL); ini_set('display_errors', 'on');

$DBUSER   = "root";
$DBPASSWD = "pass";
$DATABASE = "mydb";

header('Content-Type: text/plain');
header('Content-Disposition: attachment; filename="backup-' . date("Y-m-d-His") . '.sql"');

echo backup_tables('localhost', $DBUSER, $DBPASSWD, $DATABASE);

/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $name, $tables = '*')
{	
	$return = '';
	$link = mysql_connect($host,$user,$pass);
	mysql_select_db($name,$link);
	mysql_query('SET NAMES utf8');
	
	//get all of the tables
	if($tables == '*') {
		$tables = array();
		$result = mysql_query('SHOW TABLES');
		while($row = mysql_fetch_row($result)) {
			$tables[] = $row[0];
		}
	}
	else {
		$tables = is_array($tables) ? $tables : explode(',', $tables);
	}
	
	//cycle through
	foreach($tables as $table)
	{
		$result = mysql_query('SELECT * FROM '.$table);
		$num_fields = mysql_num_fields($result);
		
		$return .= 'DROP TABLE IF EXISTS '.$table.';';
		$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
		$return .= "\n\n".$row2[1].";\n\n";
		
		for ($i = 0; $i < $num_fields; $i++) {
			while($row = mysql_fetch_row($result)) {
				$return.= 'INSERT INTO '.$table.' VALUES(';
				for($j=0; $j < $num_fields; $j++) {					
					if(is_null($row[$j])) {
						$return .= 'NULL';
					}
					else {
						$row[$j] = addslashes($row[$j]);
						$row[$j] = preg_replace("@\n@","\\n",$row[$j]);
						$return .= '"'.$row[$j].'"';
					}
					if($j < ($num_fields-1)) { $return .= ','; }
				}
				$return .= ");\n";
			}
		}
		$return.="\n\n\n";
	}	
	return $return;
}
?>