Restore MySQL Dump mit restorescript fehler

hi,

es treten jeweils folgende fehler beim restoren mit dem restorescript auf:

QuoteRestore MySQL Dump

Executing query 1
Error: No Database Selected
Query that could not be executed:
CREATE TABLE banned ( type tinytext NOT NULL, value tinytext NOT NULL) TYPE=MyISAM;

Also error no database selected. hab ich da im restore script irgendwas vergessen auszufüllen ?

danke schonmal für expertenhilfe.

(mit des restore script wollte ich nur mal die struktur restoren, was mittels phpadmin auch funktioniert...)

Quote<?php

// Author: Dave Smulders
// The main script is done by Dave Smulders.
// Modified: Andrea Hubacher
// 05. Apr 2002 - suppress non-error messages,
// 05. Apr 2002 - show query command line in eror messages
// 05. Apr 2002 - show summary at the end of the script (total number of queries and errors)

// This section needs to be adapted to your needs. Enter database information and name of dump sql file here.
// Rename the script file extension from .txt to .php and upload the php script and the dump file into the same directory.
// Then run the php restore script with your browser.

$db_name = "*****"; // replace ***** by your database name
$db_user = "*****"; // replace ***** by your database user
$db_passwd = "*****"; // replace ***** by your database password
$db_server = "localhost"; // can usually be left
$db_prefix = ""; // can be left empty

$sql_file = "vandeloo_forum.sql"; // replace by the name of your dump file

// From here on the script usually does not to be changed any more.

// Print Header
print <<<EOT
<html>
<head>
<title>Restore MySQL Dump</title>
</head>
<body>
<h1>Restore MySQL Dump</h1> 
EOT;

// Main Script starts here

//connect to database
$db = mysql_connect($db_server, $db_user, $db_passwd);
//select database
mysql_select_db($db_name, $db);

set_time_limit(10000);
$fd = fopen ($sql_file, "r");

$query = "";
$counter = 0;
$counterrs = 0;
while (!feof ($fd)) {
$line = fgets($fd, 4096);
$line = chop($line);

if(!ereg("^#",$line)) $query .= $line;
if((ereg(";\n?$",$line) or feof($fd)) and $query != "") {
$counter++;
if (!mysql_query($query))
{
echo "Executing query $counter ";
print "Error: ".mysql_error()." ";
print "Query that could not be executed: ";
print $query; print " \n";
$counterrrs++;
}
else
{
// do not display non-errors
// echo "Executing query $counter ";
// print "No Errors \n";
};
$query = "";
}
}
fclose ($fd);

// Print Summary
echo "Number of queries executed: ".$counter." ";
echo "Number of errors encountered: ".$counterrrs." ";

// Print html footer
print <<<EOT
</body>
</html>
EOT;

?>

	Welcome, Guest. Please Login or Register. April 29, 2025, 11:41:59 AM

News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!