Loading An SQL File To MYSQL

[hearny]

Can Anybody tell me how to load an SQL file to MYSQL using PHP, SQL Scripts are generated by PHP, but dont know of any function for it. Tried to call it in a query using
$query="source PATHNAME";
$result = mysql_query($query);
but it will not load. However if I echo the query and copy and paste it into mysql at the command prompt it works, so the syntax is valid, HELP PLEASE,
Hearny.:o

[keith73]

you need to use LOAD DATA INFILE

http://www.mysql.com/doc/en/LOAD_DATA.html

• keith

[hearny]

Thanks Keith It Didnt Quite Do It But It Pointed Me In The Rigth Direction, Hearny