接上一篇文章，导出一个表，或者整个数据库到SQL形式-CSDN博客

本文链接：https://blog.csdn.net/flyfish778/article/details/4786891

<?php
require_once '../../smartyConfig/smartyConfig.class.php';
require_once '../../game/include/function.php';
require_once '../../game/include/config.php';
require_once '../../game/server/server.class.php';
require_once '../../game/include/db.class.php';

$smarty->setTemplate_dir(GAME_ROOT);
$smarty->setCompile_dir(GAME_ROOT_C);

//*******************************************************
//*******************mysqldump路径定义********************
//*******************************************************
//$mysqldumpRoot="/usr/local/mysql/bin/mysqldump"; //214

$mysqldumpRoot="E:/AppServ/MySQL/bin/mysqldump";

$md5Str=$_POST['md5Str'];
$serverName=$_POST['serverName'];
$uid=$_POST['uid'];
$cid=$_POST['cid'];

$tableName=$_GET['tableName'];
// $dbLink=mysql_connect($serverInfos[$serverName][1],DEFAULT_USER,DEFAULT_PASSWORD,DEFAULT_DB_NAME);
// mysql_query("set names 'gb2312'");
// mysql_select_db(DEFAULT_DB_NAME);
// $query=mysql_query("select * into outfile 'a.sql' from ".$tableName,$dbLink);
//
$now_date = date('Y-m-d_H-i-s');
//echo $myphpdumpRoot." -h".$serverInfos[$serverName][1]." -u".DEFAULT_USER." -p".DEFAULT_PASSWORD." ".DEFAULT_DB_NAME." ".$tableName.">".DEFAULT_DB_NAME."_".$tableName.$now_date.".sql";
if(empty($tableName))
{
exec($mysqldumpRoot." -h".$serverInfos[$serverName][1]." -u".DEFAULT_USER." -p".DEFAULT_PASSWORD." ".DEFAULT_DB_NAME.">".DEFAULT_DB_NAME.$now_date.".sql");
}
else
{
exec($mysqldumpRoot." -h".$serverInfos[$serverName][1]." -u".DEFAULT_USER." -p".DEFAULT_PASSWORD." ".DEFAULT_DB_NAME." ".$tableName.">".DEFAULT_DB_NAME."_".$tableName.$now_date.".sql");
}