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