MuSQL以文件形式导入导出整个数据库

MuSQL以文件形式导入导出整个数据库：<？php/* 导出SELECT * INTO OUTFILE "c:/name.txt"FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """LINES TERMINATED BY " "FROM zones;导入LOAD DATA INFILE "c:/name.txt" INTO TABLE zonesFIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """LINES TERMINATED BY " ";*/define（HOST,"127.0.0.1"）;define（USER,"user"）;define（PWD,"pwd"）;define（DBNAME,"dbname"）;define（DIR,"C:/xampp/htdocs/backup/"）;//1为导入 0为导出define（OPERATION,1）;mysql_connect（HOST,USER,PWD） ordie（"Could not connect: " . mysql_error（））;mysql_select_db（DBNAME） ordie（"Could not select db: " . mysql_error（））;$result = mysql_query（"show tables"）;if（！is_dir（DIR））{die（"Folder does not exist"）;}if（OPERATION）{while （$row = mysql_fetch_array（$result, MYSQL_NUM）） {$fileName=DIR.$row[0].".txt";if（file_exists（$fileName））{$querySql="TRUNCATE TABLE `".$row[0]."`";mysql_query（$querySql） ordie（"Could not truncate table: ". $querySql . mysql_error（））;$querySql = "LOAD DATA INFILE "".$fileName."" INTO TABLE `".$row[0]."`FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """LINES TERMINATED BY " "";mysql_query（$querySql） ordie（"Could not insert into table: ". $querySql . mysql_error（））;echo "insert into table ".$row[0]." success.<br/>";}else{echo "Not insert into table ".$row[0]."<br/>";}}echo "The task is finished";}else{if （is_writable（DIR）） {while （$row = mysql_fetch_array（$result, MYSQL_NUM）） {$fileName=DIR.$row[0].".txt";if（file_exists（$fileName））{unlink（$fileName）;}$querySql = "SELECT * INTO OUTFILE "".$fileName.""FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """LINES TERMINATED BY " " FROM `".$row[0]."`";mysql_query（$querySql） ordie（"Could not dump table: ". $querySql . mysql_error（））;echo "dump table ".$row[0]." success.<br/>"; }echo "The task is finished";}else{echo "Folder ".DIR." can not writeable";}}mysql_free_result（$result）;mysql_close（）;？>MySQL总结之SQL语句的应用EZDML支持在Oracle和SQL Server异构数据库之间导出备份和导入恢复数据相关资讯 MuSQL教程本文评论查看全部评论（0）