提个很简单的问题!请回答

[来得查理]

在mysql 里面执行导出.sql文件的语句怎么写啊?

还有导入的语句怎么写?

请知道的兄弟们告诉我,不胜感谢!!!

[fewbad]

呵呵，楼主瞧你那憨样。偶指你的PIC....

<?php
$host="localhost"; 
$user="root"; 
$password=""; 
$dbname="dbname"; 
     
mysql_connect($host,$user,$password); 
mysql_select_db($dbname); 
     
$mysql= "set charset gb2312;\r\n";#for mysql>=5.0 
$q1=mysql_query("show tables"); 
while($t=mysql_fetch_array($q1)){ 
     $table=$t[0]; 
     $q2=mysql_query("show create table `$table`"); 
     $sql=mysql_fetch_array($q2); 
     $mysql.=$sql['Create Table'].";\r\n\r\n"; 
     
     $q3=mysql_query("select * from `$table`"); 
      while($data=mysql_fetch_assoc($q3)) 
      { 
             $keys=array_keys($data); 
             $keys=array_map('addslashes',$keys); 
             $keys=join('`,`',$keys); 
             $keys="`".$keys."`"; 
             $vals=array_s($data); 
             $vals=array_map('addslashes',$vals); 
             $vals=join("','",$vals); 
             $vals="'".$vals."'"; 
             
             $mysql.="insert into `$table`($keys) s($vals);\r\n"; 
      } 
     $mysql.="\r\n"; 
     
} 
echo $mysql;
?>

[junp2007]

工具http://topic.csdn.net/u/20080407/21/d591ba87-e3d1-4fe2-ac4d-4939dcaf7bf2.html

[laruence]

>select * from **** > out.sql


#mysql -u root DBNAME < out.sql

[knowledge_Is_Life]

lz要干嘛？