仿照phpMyAdmin写的一个简单MYSQL备份、还原程序
时间:2007-04-11 来源:yueming
仿照phpMyAdmin写的一个简单MYSQL备份、还原程序,已测试通过(不适合复杂结构),仅供参考!
config.php文件:
backup.php文件:
echo "# \n";
echo "# Database backup file \n";
echo "# copyright @ phpteam 20002-2003 \n";
echo "# \n";
echo "# Host : " . $dbhost ."\n";
echo "# Database: " . $dbname ."\n";
echo "# Date : " . date("d-M-Y",time()) . "\n";
echo "# \n\n\n";
$i=0;
while ($i
if($pkey_exist!=0)
{
$pkey = mysql_result($result,0,'column_name');
$struc .= " PRIMARY KEY ($pkey)\n";
}
else
{
// replace ,\n
$struc = substr($struc,0, strlen($struc)-2);
$struc .= "\n";
}
echo $struc;
echo ");\n\n";
// data
echo "# \n";
echo "# Dumping data for table '$table' \n";
echo "# \n\n";
$query = "select * from $table";
$result = mysql_query($query);
$j = 0;
while($row=mysql_fetch_row($result))
{
$data .= "INSERT INTO $table VALUES(";
for($k=0; $k
import.php文件:
config.php文件:
backup.php文件:
echo "# \n";
echo "# Database backup file \n";
echo "# copyright @ phpteam 20002-2003 \n";
echo "# \n";
echo "# Host : " . $dbhost ."\n";
echo "# Database: " . $dbname ."\n";
echo "# Date : " . date("d-M-Y",time()) . "\n";
echo "# \n\n\n";
$i=0;
while ($i
if($pkey_exist!=0)
{
$pkey = mysql_result($result,0,'column_name');
$struc .= " PRIMARY KEY ($pkey)\n";
}
else
{
// replace ,\n
$struc = substr($struc,0, strlen($struc)-2);
$struc .= "\n";
}
echo $struc;
echo ");\n\n";
// data
echo "# \n";
echo "# Dumping data for table '$table' \n";
echo "# \n\n";
$query = "select * from $table";
$result = mysql_query($query);
$j = 0;
while($row=mysql_fetch_row($result))
{
$data .= "INSERT INTO $table VALUES(";
for($k=0; $k
import.php文件:
相关阅读 更多 +