can i execute a SQL file with PHP?

[jerich0]

I know that i can execute a SQL sentence for a MySQL database, but i dont know if i can execute an entire *.sql file.

Can anybody help me and said me how?

Thanks!!

[dannys]

You can't just send a .sql file, no - that won't work.

You can, however, read the file into an array (with each line being 1 array element) and the use a foreach loop to send each line to mysql_query(). - This would do what you're after

[edwardsbc]

It is probably also possible to "upload" the *.sql file through a script and the execute the mysql client through exec() or its ilk (http://www.php.net/manual/en/ref.exec.php . You would want to be careful about security and user permission issues when doing this though.

I also say probably because I haven't attempted to do this, so I don't know if it will work as you expect.

[Flameeyes]

i've had the same problem, and i resolved with this simple function:

	function execute_sql_script($filename)
	{
		$fd = fopen($filename, "r");

	$query = "";
	while(!feof ( $fd ))
	{
		$line = fgets($fd, 4096);
		if ( strstr($line, ";") != false )
		{
			$query .= substr($line, 0, strpos($line, ";"));
			mysql_query($query);
			if ( mysql_errno() )
				echo "<font color=\"red\">Error executing query</font><br><pre>$query</pre><br>".mysql_errno().": ".mysql_error()."<br>\n";
			$query = "";
		} else
			$query .= $line;
	}
}

The problem is if there's multiple query on a single line.