Load SQL file into DB

[papaface]

Hello,

I have a .txt file that has the code to create tables etc in a database.

How can I just load that into the database rather than having to type out it all manually in PHP?

 

regards

[chigley]

Use PHPMyAdmin if you have it

[papaface]

No. I mean how can I get it to run through PHP but without me having to put the SQL in PHP mysql_query("");

 

Is there some way to load the file and then get PHP to execute it on the database?

[chigley]

If each query is on a separate line:

 

<?php

$lines = file("file.txt");

foreach($lines as $linenumber => $line) {
$query = mysql_query($line) or die("Error on query $linenumber: ".mysql_error());
}

?>