Running .sql with PHP

[Neptunus Maris]

Is this correct?

 

<?php

mysql_query("SOURCE file.sql");

?>

 

Is that correct to run a *.sql file on your server through PHP?

 

Thanks,

Neptune

[DarkWater]

Why don't you try it yourself? =P

[Neptunus Maris]

Why don't you try it yourself? =P

 

Damn...lol

[DarkWater]

It IS the correct way to do it, but you really could have tried it yourself. =P

[Barand]

Any idea what versions of PHP/MySQL you need for that? I can't get it to work.

 

<?php
mysql_query ('SOURCE mytest.sql') or die(mysql_error());
?>

 

-->

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SOURCE mytest.sql' at line 1

 

[cheechm]

 

<?php
mysql_query ('LOAD DATA INFILE mytest.sql') or die(mysql_error());
?>

[Barand]

This worked

<?php
exec ('mysql < mytest.sql') ;
?>