Mine

$sqlq = "SHOW TABLES FROM ".$database_name;
$result = mysql_query($sqlq);
while ($row = mysql_fetch_row($result)) {

//	$result2 = mysql_query("SHOW COLUMNS FROM ".$row[0]);
//	if (mysql_num_rows($result2) > 0) {
//	   while ($row2 = mysql_fetch_assoc($result2)) {
//		   $str.="`".$row2['Field']."` ";
//		   $str.="".$row2['Type']." ";
//		   if(is_numeric($row2['Default'])) {
//		   	$str.="".(!empty($row2['Default'])?"default ".$row2['Default']:"")." ";
//		   } else {
//		   	$str.="".(!empty($row2['Default'])?"default '".$row2['Default']."'":"")." ";
//		   }
//		   $str.="".($row2['Null']=="YES"?"NULL":"NOT NULL")." ";
//		   $str.="".($row2['Key']=="PRI"&&$row2['Extra']=="auto_increment"?"PRIMARY KEY":"")." ";
//		   $str.=$row2['Extra']."";
//		   $elms[]=$str;
//		   unset($str);
//	   }
//	}
//	echo("\n\nDROP TABLE IF EXISTS `".$row[0]."`;\n");
//	echo("CREATE TABLE ".$row[0]." (\n".join(",\n  ",$elms)."\n);\n\n\n");
//	unset($elms);
	
	
	$q=mysql_query("SELECT * FROM ".$row[0]);
	while($roww=mysql_fetch_row($q)) {
		foreach($roww as $key=>$val) {
			if(is_numeric($val)) {
				$keys[]=addslashes($val);
			} else {
				$val = ereg_replace("\n","\\n",addslashes($val));
				$val = ereg_replace("\r","\\r",addslashes($val));
				$keys[]="\"".$val."\"";
			}
		}
		echo("INSERT INTO ".$row[0]." VALUES(".join(", ",$keys).");\n");
		unset($keys);
		flush();
	}
	
	flush();

}