MySQL Forums
Forum List  »  Other Migration

load data local infile
Posted by: sam
Date: August 18, 2004 02:37PM

I am using MySql 4.0.15 and php 4.3.3 on a Win 2000 server running IIS 5.

I am having trouble with 'load data local infile' if I leave off the 'local' and place the data file on my server it works fine but it will not work with the data file on the client.

Any help would be appreciated.

==========
$link = mysql_connect($host,$user,$password)
or die("Could Not Connect to MySQL<P>");

mysql_select_db($db,$link)
or die("Could Not Open Database<P>");

$sql = "load data local infile 'c:/temp/local.txt' into table test fields terminated by ','";
$result = mysql_query($sql)
or die ("Could Not Import Data<P>");
==========

Options: ReplyQuote


Subject
Views
Written By
Posted
load data local infile
12027
sam
August 18, 2004 02:37PM
3938
August 20, 2004 10:37AM
2943
sam
August 23, 2004 02:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.