|
|
Posted by Tim Van Wassenhove on 10/31/45 11:17
On 2005-05-30, Jamie Meyers <gtg061q@mail.gatech.edu> wrote:
> Nevermind, I decided to parse the .sql file and create the query there. I
> do not think there is any way to import the .sql file via php. Thanks
> anyways. And if anyone would like this script after I fix it up a little
> more, let me know.
Assuming each instruction is on a line.. (untested)
$db = mysql_connect(....);
mysql_select_db(....);
$fp = fopen('somefile.sql', 'r');
while($fp != feof())
{
$line = fread($fp, 2048);
$line = mysql_real_escape_string($db, $line);
mysql_query($line);
}
fclose($fp);
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
Navigation:
[Reply to this message]
|