急急急!!!!!!怎样在linux下把mysql库导出到客户端?? 要想简单的话,就装个phpmyadmin吧,这样就行了。不过要注意安全哦! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是我在setting.php的变量class Setting{};// to prepare to connect to the booking database$CONFIG = new Setting; // Object for the dirctory struture$CONFIG->dbuser = "root";$CONFIG->dbpass = "pass";$CONFIG->dbname = "kl"; $path->main = $DOCUMENT_ROOT."/JED"; WEB路径$path->mysqldir = "/usr/local/bin"; mysqldump执行文件路径(看看mysql帮助)$path->backupdbdir = "$path->main/file/backupdb";备份数据存放路径$SAS_SESSION[userlogin][uloginid]用户名用于组成文件名$str=date("YmdHis"); if($CONFIG->dbuser==""){$dbuser="";}else{$dbuser=" -u ".$CONFIG->dbuser." ";} if($CONFIG->dbpass==""){$dbpass="";}else{$dbpass=" -p".$CONFIG->dbpass." ";} exec($path->mysqldir."/mysqldump ".$dbuser." ".$dbpass." ".$CONFIG->dbname." > ".$path->backupdbdir."/".$str.$SAS_SESSION[userlogin][uloginid].".sql"); $temp_dir=explode("/file/",$path->backupdbdir); $filepath = "../../file/".$temp_dir[1]."/".$str.$SAS_SESSION[userlogin][uloginid].".sql"; Header("Content-type: application/file"); Header("Accept-Ranges: bytes"); Header("Accept-Length: ".filesize($filepath)); Header("Content-Disposition: attachment; filename=".$str.$SAS_SESSION[userlogin][uloginid].".sql"); $fd = fopen( $filepath, "r" ); echo fread($fd,filesize($filepath)); fclose($file); Header("Location:backupdb.php");exit; 用xml+php不错backup.php<?if ($table=="")header("Location:listtable.php");?><html><head><title>使用XML备份Mysql数据库</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body bgcolor="#FFFFFF" text="#000000"><?$con=mysql_connect('localhost','root','');$query="select * from $table ";//数据库查询$result=mysql_db_query("dragon",$query,$con);$filestr="<"."?xml version=\"1.0\" encoding=\"GB2312\"?".">";$filestr.="<".$table."s>";while ($row=mysql_fetch_array($result))//列出所有的记录{$filestr.="<".$table.">";$fields=mysql_list_fields("embed",$table,$con);$j=0;//$num_fields=mysql_field_name($fields,$j);//echo $num_fields;while ($j < mysql_num_fields($fields)){ $num_fields=mysql_field_name($fields,$j); $filestr.="<".$num_fields.">"; $filestr.=$row[$j]; $filestr.="</".$num_fields.">"; $j++;}$filestr.="</".$table.">";}$filestr.="</".$table."s>";echo $filestr;//以下是文件操作代码$filename=$table.".xml";$fp=fopen("$filename","w");fwrite($fp,$filestr);fclose($fp);echo "数据表".$table."已经备份成功!";?></body></html>listtable.php<html><head><title>使用XML备份Mysql数据库</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body bgcolor="#FFFFFF" text="#000000">请选择要备份的表格:<?$con=mysql_connect('localhost','root','');$lists=mysql_list_tables("dragon",$con);//数据库连接代码$i=0;while($i < mysql_num_rows($lists)){ $tb_name=mysql_tablename($lists,$i); echo "<a href=backup.php?table=".$tb_name.">".$tb_name."</a>";//列出所有的表格$i++;}?></body></html> 把mysql下data文件加考到客户机的mysql下就可以了 phpmyadmin导出数据.然后再到客户端导入. 如果你想用程序自动实现的话,我倒是可以帮你写写如果只是取$table表的结构,主要是分析下面两个结果集:show fields from $tableshow keys from $table 对一个数据库逐个表进行分析,就出来了。实际上很简单,你研究一下phpmyadmin生成sql语句的代码就知道了 新手问下这条正则什么意思? 导出execl问题。。急在线 附件上传下载怎么写啊 关于header函数跳转的问题 一个变量读取的问题 新手来讨论一下,高手来帮一下。这样的问题不知道大家碰到过没有? 在线等!!关于函数间的变量传递问题! 为什么我的表单提交的数据不能接收呢?(在线等,救命) php4.0.34+apache2.0.43+win2000professor的配置? 关于数据读取的问题 怎样改变输组的key值 如果在Javascript里执行php语名?
class Setting{};// to prepare to connect to the booking database
$CONFIG = new Setting; // Object for the dirctory struture
$CONFIG->dbuser = "root";
$CONFIG->dbpass = "pass";
$CONFIG->dbname = "kl"; $path->main = $DOCUMENT_ROOT."/JED"; WEB路径
$path->mysqldir = "/usr/local/bin"; mysqldump执行文件路径(看看mysql帮助)
$path->backupdbdir = "$path->main/file/backupdb";备份数据存放路径
$SAS_SESSION[userlogin][uloginid]用户名用于组成文件名$str=date("YmdHis");
if($CONFIG->dbuser==""){$dbuser="";}else{$dbuser=" -u ".$CONFIG->dbuser." ";}
if($CONFIG->dbpass==""){$dbpass="";}else{$dbpass=" -p".$CONFIG->dbpass." ";}
exec($path->mysqldir."/mysqldump ".$dbuser." ".$dbpass." ".$CONFIG->dbname." > ".$path->backupdbdir."/".$str.$SAS_SESSION[userlogin][uloginid].".sql"); $temp_dir=explode("/file/",$path->backupdbdir);
$filepath = "../../file/".$temp_dir[1]."/".$str.$SAS_SESSION[userlogin][uloginid].".sql";
Header("Content-type: application/file");
Header("Accept-Ranges: bytes");
Header("Accept-Length: ".filesize($filepath));
Header("Content-Disposition: attachment; filename=".$str.$SAS_SESSION[userlogin][uloginid].".sql");
$fd = fopen( $filepath, "r" );
echo fread($fd,filesize($filepath));
fclose($file);
Header("Location:backupdb.php");exit;
backup.php
<?
if ($table=="")
header("Location:listtable.php");
?>
<html>
<head>
<title>使用XML备份Mysql数据库</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?
$con=mysql_connect('localhost','root','');
$query="select * from $table ";
//数据库查询
$result=mysql_db_query("dragon",$query,$con);
$filestr="<"."?xml version=\"1.0\" encoding=\"GB2312\"?".">";
$filestr.="<".$table."s>";
while ($row=mysql_fetch_array($result))
//列出所有的记录
{$filestr.="<".$table.">";
$fields=mysql_list_fields("embed",$table,$con);
$j=0;
//$num_fields=mysql_field_name($fields,$j);
//echo $num_fields;
while ($j < mysql_num_fields($fields))
{
$num_fields=mysql_field_name($fields,$j);
$filestr.="<".$num_fields.">";
$filestr.=$row[$j];
$filestr.="</".$num_fields.">";
$j++;
}
$filestr.="</".$table.">";
}
$filestr.="</".$table."s>";
echo $filestr;
//以下是文件操作代码
$filename=$table.".xml";
$fp=fopen("$filename","w");
fwrite($fp,$filestr);
fclose($fp);
echo "数据表".$table."已经备份成功!";
?>
</body>
</html>listtable.php<html>
<head>
<title>使用XML备份Mysql数据库</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
请选择要备份的表格:
<?
$con=mysql_connect('localhost','root','');
$lists=mysql_list_tables("dragon",$con);
//数据库连接代码
$i=0;
while($i < mysql_num_rows($lists))
{
$tb_name=mysql_tablename($lists,$i);
echo "<a href=backup.php?table=".$tb_name.">".$tb_name."</a>";
//列出所有的表格
$i++;
}?>
</body>
</html>
show fields from $table
show keys from $table