Mine

<?phpclass SQL_Export{	var $cnx;	var $db;	var $server;	var $port;	var $user;	var $password;	var $table;	var $tables;	var $exported;	function SQL_Export($server, $user, $password, $db, $tables)	{		$this->db = $db;		$this->user = $user;		$this->password = $password;				$sa = explode(":", $server);		$this->server = $sa[0];		$this->port = $sa[1];		unset($sa);		$this->tables = $tables;		$this->cnx = mysql_connect($this->server, $this->user, $this->password) or $this->error(mysql_error());		mysql_select_db($this->db, $this->cnx) or $this->error(mysql_error());	}	function export()	{		foreach($this->tables as $t)		{			$this->table = $t;			$header = $this->create_header();			$data = $this->get_data();			$this->$exported .= "###################\n# Dumping table $t\n###################\n\n$header" . $data . "\n";		}				return($this->$exported);	}	function create_header()	{		$fields = mysql_list_fields($this->db, $this->table, $this->cnx);		$h = "CREATE TABLE `" . $this->table . "` (";				for($i=0; $i<mysql_num_fields($fields); $i++)		{			$name = mysql_field_name($fields, $i);			$flags = mysql_field_flags($fields, $i);			$len = mysql_field_len($fields, $i);			$type = mysql_field_type($fields, $i);			$h .= "`$name` $type($len) $flags,";			if(strpos($flags, "primary_key")) {				$pkey = " PRIMARY KEY (`$name`)";			}		}				$h = substr($h, 0, strlen($d) - 1);		$h .= "$pkey) TYPE=MyISAM;\n\n";		return($h);	}	function get_data()	{		$d = null;		$data = mysql_query("SELECT * FROM `" . $this->table . "` WHERE 1", $this->cnx) or $this->error(mysql_error());				while($cr = mysql_fetch_array($data, MYSQL_NUM))		{			$d .= "INSERT INTO `" . $this->table . "` VALUES (";			for($i=0; $i<sizeof($cr); $i++)			{				if($cr[$i] == '') {					$d .= 'NULL,';				} else {					$d .= "'$cr[$i]',";				}			}			$d = substr($d, 0, strlen($d) - 1);			$d .= ");\n";		}		return($d);	}	function error($err)	{		die($err);	}}$t = array("addressbook", "affiliates", "approve", "approvelog", "configuration", "extranumbers", "faq", "favlsit", "groups", "news", "paypal", "sms", "sponsor", "superior", "users");$exporter = new SQL_Export("localhost:3306", "db_user", "pass", "dbname", $t);$sql = $exporter->export();header("Content-type: text/plain");header("Content-Disposition: attachment; filename=backup.sql");header("Pragma: no-cache");header("Expires: 0");echo $sql;?>