[Resolved] batch sql question

[stuartc1]

Hi everyone -

Im looking for a quick solution: I need to run SQL to create and populate a small database on many Servers. I have the script to connect and run single queries, but im looking to run a list of queries on each server.
anyone know the best way to do this?

[superwormy]

What database are you using? For MySQL, the mysqldump command line utility works great.

[stuartc1]

thanks anyway - this was pretty simple to solve using explode(). I used something along these lines.

// open the .sql file
$fp = @fopen("full.sql", "r");
$file = fread($fp, 1024);
fclose($fp);

$lines = explode(';',  $file); // split the .sql into sepearte queries
$cnt = count($lines); // count array elements
$st = "host_address";
mysql_connect($st, "root") or die("cannot connect to $st<br/>");
for($j=0; ($j<$cnt-1); $j++) {
			if(!mysql_query($lines[$j])) {
					// echo any errors
					echo "Error on line $j of Query:<br>";
					echo $lines[$j]."<br><Br>";
					die;
			}
		}
mysql_close();