$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(); }