importing a mySQL dump with PHP

[mdegalli]

I have an .sql file dumped from phpMyAdmin. I want to use it with an installation script I am writing in php. The script should create the database with parameters from a form, then input the dumped file.

Ican create the new database, but I can't figure out how to import the .sql file.

Any pointers would be appreciated!

Thanks,
-Mark

[yelvington]

Read the dumpfile into a variable. For details, see the filesystem section of the manual. Hint: an easy way to do it is with file() and implode().

Then execute the variable as a query. The annotated manual page for mysql_query() has some interesting comments that address the issue of executing a query that consists of multiple SQL statements; you should read them as well.

[BCE_OXYEHHO]

Here is waht I usually do (I use postgres but it's the same idea for MySQL):

  echo "Creating 'dbname' database...<br>"; 
$result = exec("createdb -U username dbname");
echo("Populating...<br>");
$output =exec("psql -U username -q dbname -f dumpdata.sql");

[mdegalli]

I had trouble with some of the examples, but finally got it to work. I couldn't get the exec() method to work at all.

Thanks a lot for your suggestions!!

Here's my working function:

function sendquery( $db_host, $db_base, $db_user, $db_pw, $filename ) {
	// THIS MAY NOT BE THE MOST EFFICIENT WAY, BUT IT WORKS :-)

GLOBAL $messages;
$mess = 'Connexion with server ' . $db_host . ' failed';
mysql_connect( $db_host, $db_user, $db_pw ) or die($mess);
mysql_select_db( $db_base ) or die($mess);

$fcontents = file($filename);  // filename should include path like "../../stock/file.sql"
$i=0;
foreach ($fcontents as $value) {  // take out comments in file:
	if ($value{0} == "#") {
		$fcontents[$i] = "\n";
	}
	echo $fcontents[$i]."<BR>";
	$i++;
}

$filestring = implode("",$fcontents);  // convert to large string and take out \n, parse back into array by ";"
$filestring = str_replace("\n","",$filestring);
$newcontents = explode(";",$filestring);
$i=0;
foreach ($newcontents as $value) {
	echo $value."<BR>";
	$error = mysql_query("$value");
	if ($error == 1) {
		//	$messages .= "line $i good<BR>";   // uncomment for debugging
	}else{
		//	$messages .= "line $i ERROR !!!!!!!!!!!!!!!!!!!!!!!!!!!<BR>"; // uncomment for debugging
	}
	$i++;
}
}

[tasistro]

I've solved my exec problems using backtics

like

$command = "psql -U username -q dbname -f dumpdata.sql";
$output=$command;

Saludos
Gerardo