一段导出数据库的代码

一段导出数据库的代码

2004-06-16          点击: 11

一段导出数据库的代码 <? // $dbname="mytest"; $filename="file.sql"; mysql_pconnect ("localhost:3306","root",""); // function sqldumptable($table) { global $DB_site; $tabledump = "DROP TABLE IF EXISTS $table;/n"; $tabledump .= "CREATE TABLE $table (/n"; $firstfield=1; $fields = mysql_query("SHOW FIELDS FROM $table"); while ($field = mysql_fetch_array($fields)) { if (!$firstfield) {$tabledump .= ",/n";} else {$firstfield=0;} $tabledump .= " $field[Field] $field[Type]"; if (!empty($field["Default"])) {$tabledump .= " DEFAULT '$field[Default]'";} if ($field[Null] != "YES") {$tabledump .= " NOT NULL";} if ($field[Extra] != "") {$tabledump .= " $field[Extra]";} } mysql_free_result($fields); $keys = mysql_query("SHOW KEYS FROM $table"); while ($key = mysql_fetch_array($keys)) { $kname=$key['Key_name']; if ($kname != "PRIMARY" and $key['Non_unique'] == 0) { $kname="UNIQUE|$kname";} if(!is_array($index[$kname])) { $index[$kname] = array();} $index[$kname][] = $key['Column_name']; } mysql_free_result($keys); // get each key info while(list($kname, $columns) = @each($index)){ $tabledump .= ",/n"; $colnames=implode($columns,","); if($kname == "PRIMARY"){ $tabledump .= " PRIMARY KEY ($colnames)";} else { if (substr($kname,0,6) == "UNIQUE") { // key is unique $kname=substr($kname,7); } $tabledump .= " KEY $kname ($colnames)"; } } $tabledump .= "/n);/n/n"; // get data $rows = mysql_query("SELECT * FROM $table"); $numfields=mysql_num_fields($rows); while ($row = mysql_fetch_array($rows)) { $tabledump .= "INSERT INTO $table VALUES("; $fieldcounter=-1; $firstfield=1; // get each field's data while (++$fieldcounter<$numfields) { if (!$firstfield) { $tabledump.=","; } else { $firstfield=0; } if (!isset($row[$fieldcounter])) { $tabledump .= "NULL"; } else { $tabledump .= "'".addslashes($row[$fieldcounter])."'"; } } $tabledump .= ");/n"; } mysql_free_result($rows); return $tabledump; } //函数结束 // $result = mysql_list_tables ($dbname); $i = 0; while ($i < mysql_num_rows ($result)) { $tb_names[$i] = mysql_tablename ($result, $i); $dump.=sqldumptable($tb_names[$i])."/n/n/n"; $i++; } echo $dump;//可以在浏览器里输出看看 $filehandle=fopen($filename,"w"); fwrite($filehandle,$dump."/n/n/n"); fclose($filehandle); echo "<p>数据成功导出!</p>"; ?> 把$filename="file.sql";改成$filename="file.txt";