I believe the problem is with your use of "LOCAL". This is telling the
server to try to load the file on the computer it is running on. If this is
not where the file is on the computer running mysqld this could explain why
it cant read it. Try removing the "LOCAL" part, you also might want to
enable compression depending on how fast the link between the two computers
are.
ryan
> I'm tring to import a text file to mysql. The problem I am having is
> that the mysql database is located on a seperate server from the web
> site. I can do query's and inserts but I can not get the mysql server to
> grab a txt file from the web server and load it into the database. I
> have been using the following code:
>
> $query = "LOAD DATA LOCAL INFILE '$tmp\\$file1_name' ";
> $query .= "INTO TABLE usr FIELDS ";
> $query .= "TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
> (name,email,login,active,defaultpw)";
>
> The site is located on an NT server and the database is on a UNIX
> server. Not sure if that matters or not.
>
> Any help would be great..
>
> Ian
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
