|
";
exit;
}
// 备份数据库
if($cmd =='bakdb' and $db!='' and $path !=''){
$dbname=$db;
@mysql_select_db($dbname) or die("选择数据库失败");
$filehandle = @fopen($path,"w");
if ($filehandle) {
$result = mysql_query("SHOW tables");
echo ($result) ? NULL : "出错: ".mysql_error();
while ($currow = mysql_fetch_array($result)) {
if (isset($currow[0])) {
sqldumptable($currow[0], $filehandle);
fwrite($filehandle,"\n\n\n");
}
}
fclose($filehandle);
echo "数据库".$dbname."已成功备份到 ".$path."";
mysql_close();
} else {
echo "备份失败,请确认目标文件夹是否具有可写权限.";
}
}
// 删除数据库
if ($cmd=='dropdb' and $db!=''){
$dbname=$db;
$result = mysql_drop_db($dbname)? "删除数据库:\t".$dbname."\t成功！":"删除数据库\t".$dbname."\t失败：".mysql_error();
echo $result;
$url =$_SERVER['PHP_SELF'];
echo "";
exit;
}
//删除表
if($cmd=='droptb' and $db!='' and $tbname !=''){
$dbname=$db;
mysql_select_db($dbname) or die("选择数据库失败");
$vtb="drop table $tbname";
$result = @mysql_query($vtb)? "删除数据库:\t".$dbname."\t中表:\t".$tbname."\t成功！":"删除数据库\t".$dbname."\t中表:\t".$tbname."\t失败：".mysql_error();
echo $result;
$url ="?db=".urlencode($dbname)."&cmd=showtb";
echo "";
exit;
}
//备份表
if($cmd=='baktb' and $db!='' and $tbname !='' and $path !=''){
$dbname=$db;
mysql_select_db($dbname) or die("选择数据库失败");
$filehandle = @fopen($path,"w");
if ($filehandle) {sqldumptable($tbname, $filehandle);
fwrite($filehandle,"\n\n\n");
fclose($filehandle);
echo "表".$tbname."已成功备份到 ".$path."";
mysql_close();
} else {
echo "备份失败,请确认目标文件夹是否具有可写权限.";
}
}
?>
|