---
title: "Återskapande av databas"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/66160-återskapande-av-databas"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Bulan"
published: "2003-01-26T07:59:01.000Z"
updated: "2003-01-26T07:59:01.000Z"
replies: 0
views: 332
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/66160-återskapande-av-databas"
---

# Återskapande av databas

## #1 — Bulan, 2003-01-26T07:59Z

Hej detta script fungerar förträffligt bra för att återställa databasen på unix linux maskiner men jag får det ej att fungera under windows kan någon förklara varför ?

```php
 
<?
include "backup.php";
?>
<html>
<head>
<title>phpMyBackup v.<? echo $version;?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function restore(what) {
   if (confirm("Are you sure you want to overwrite the database with the file " + what +  "?")) {
         window.location = "restore.php?file=" + what;
   }
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellpadding="3">
  <tr>
    <td bgcolor="#DDDDDD" align="center"> <b><font face="Verdana, Arial, Helvetica, sans-serif">phpMyBackup 
      v.<? echo $version;?></font></b></td>
  </tr>
</table>
<p align="center"><?
if ($file!="") {
	$filename = $file;
	set_time_limit(180);
	if ($compression ==1) $file=gzread(gzopen($path.$file, "r"), 10485760);
	else $file=fread(fopen($path.$file, "r"), 10485760);
	$query=explode(";#%%\n",$file);
	for ($i=0;$i < count($query)-1;$i++) {
		mysql_db_query($dbname,$query[$i],$conn) or die(mysql_error());
	}
	echo "<b>$filename successfully restored!</b>";
}
?></p>
<div align="center">
  <table border="0" cellpadding="5">
    <tr align="center"> 
      <td><u><i>File</i></u></td>
      <td><u><i>Size</i></u></td>
      <td><u><i>Date</i></u></td>
    </tr>
    <?
	$dir=opendir($path); 
	while ($file = readdir ($dir)) { 
	    if ($file != "." && $file != ".." && eregi("\.sql",$file)) { 
	        echo "<tr><td>$file&nbsp;</td>
	        	<td align=\"right\">&nbsp;" . bcdiv(filesize($path.$file),1024,1) . " kB&nbsp;</td>
	        	<td>&nbsp;" . date("Y-m-d H:i",filemtime($path.$file)) . "</td>
	        	<td>&nbsp;<a href=\"javascript:restore('$file')\"><b>Restore</b></a>&nbsp;</td>
	        	<td>&nbsp;<a href=\"dump/$file\">View/Download</a></td>&nbsp;</tr>"; 
	    } 
	}
	closedir($dir);
?>
  </table>
</div>
</body>
</html>
```

Permalänk: https://www.webforum.nu/p/66160

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/66160-återskapande-av-databas
