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

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

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

<?php
/* 
导出
SELECT * INTO OUTFILE 'c:/name.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n'
FROM zones;

导入
LOAD DATA INFILE 'c:/name.txt' INTO TABLE zones  
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n';
*/	

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) or
die("Could not connect: " . mysql_error());
mysql_select_db(DBNAME) or
die("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) or
			die("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 '\n'";
			mysql_query($querySql) or
			die("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 '\n' 
			FROM `".$row[0]."`";
			mysql_query($querySql) or
			die("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();
?>